Data Analyst 3 (Hybrid)

Job Title : Data Analyst 3 (Hybrid)

Location : Richmond, VA

Duration :  12+ Months

Job Description :

We are seeking a detail-oriented Data Analyst with strong SQL skills and experience working with Microsoft Dataverse to support post-migration data quality initiatives. The data migration from SQL Server to Dataverse has been completed, and this role will focus on reconciling records, identifying inconsistencies, and performing cleanup tasks to ensure the integrity and usability of data in the new system.

Teleworking available, however, candidate will need to be onsite 1-2 days per week for onboarding and initial knowledge transfer.

Key Responsibilities :

• Conduct detailed data cleanup, validation, and normalization within the Dataverse environment.
• Use SQL queries to analyze and compare records from legacy SQL systems and the current Dataverse platform.
• Perform data reconciliation to confirm accuracy and completeness of migrated data, identifying mismatches and resolving anomalies.
• Collaborate with stakeholders to understand business rules and define expected data standards.
• Develop scripts and tools to automate data quality checks and support ongoing data hygiene.
• Document findings and cleanup efforts to ensure transparency and auditability.
• Assist with building reports and views in Dataverse and Power BI to support data quality monitoring and operational needs.
• Support efforts to enforce data governance and improve data management practices.

Requirements :

Preferred Qualifications :

Skills : Skill

Required / Desired

Amount

of Experience

Proficient in SQL

Required

Years

Strong understanding of Microsoft Dataverse

Required

Years

Power BI

Required

Years

Experience analyzing large datasets

Required

Years

Power Automate

Required

Years

Experience with Kingsway Soft and / or SSIS

Nice to have