Data Architect

Data Analyst

Onsite

Description:

Diversified Systems is searching for a senior level Data Analyst to support reporting, analytics, and data warehouse efforts following a recent tax accounting system migration. This role is hands-on and delivery focused, with responsibility for refining existing data definitions, developing reports, and supporting application migration efforts.

In addition to technical responsibilities, this role will function as a business analyst when needed, working directly with business SMEs to uncover, validate, and clarify data definitions, rules, and logic. The Senior Data Analyst will partner closely with business analysts, developers, and the IT Project Manager to ensure shared and accurate understanding of data across reporting and application teams.

Responsibilities:

Lead refinement, validation, and ongoing documentation of the existing enterprise data dictionary desired.

Work directly with business SMEs to elicit, clarify, and confirm data definitions, calculations, and business rules desired.

Function as a business analyst when needed to bridge gaps between business understanding and technical implementation desired.

Support and collaborate with business analysts by validating data logic and ensuring consistency across requirements, reports, and applications desired.

Design, develop, and maintain reports using Power BI and SSRS desired.

Assist with conversion and redevelopment of reports impacted by application migrations desired.

Provide advanced SQL Server expertise including complex queries, functions, and stored procedures desired.

Support data warehouse development and optimization including indexing strategies desired.

Query system tables and analyze performance and data behavior to support reporting and application needs desired.

Translate business logic into clear, actionable technical specifications for reporting and analytics desired.

Identify data quality issues and partner with technical teams to define and implement resolutions desired.

Document data lineage, transformations, and report logic clearly and consistently desired.

Communicate progress, risks, and data related issues to the IT Project Manager desired.

Perform other related duties as assigned desired.

Requirements:

7 years Professional data analysis or business intelligence experience required.

Advanced SQL Server knowledge performance tuning and table partitioning required.

Demonstrated experience with Power BI and or SSRS required.

Strong experience working with data warehouses required.

Demonstrated experience eliciting and documenting requirements directly from business stakeholders required.

Ability to work directly with SMEs, business analysts, developers, and project managers required.

High level of attention to detail and strong documentation skills nice to have.

Strong written and verbal communication skills desired.

Experience supporting financial, tax, or property related systems highly desired.

Experience assisting with system migrations or large scale report conversions highly desired.

Experience independently validating data logic and resolving ambiguity highly desired.

Experience working in public sector or highly visible environments highly desired.

About Diversified Systems

Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.

Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.

Diversity, Equity and Inclusion

DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.