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.
- Proficient in SQL, including complex joins, data comparison, and troubleshooting.
- Strong understanding of Microsoft Dataverse, including schema, data relationships, and business rules.
- Experience with data quality and reconciliation efforts following system migrations.
- Ability to analyze large datasets and identify discrepancies, duplicates, and inconsistencies.
- Familiarity with Power Platform tools, particularly Power BI and Power Automate.
- Strong documentation and communication skills for reporting findings and working with both technical and business teams.
- Experience using Kingsway Soft, SSIS, or other ETL tools (helpful but not required for this post-migration phase).
| Skill | Required / Desired | Amount | of Experience |
| Proficient in SQL | Required | 3 | Years |
| Strong understanding of Microsoft Dataverse | Required | 2 | Years |
| Power BI | Required | 2 | Years |
| Experience analyzing large datasets | Required | 2 | Years |
| Power Automate | Required | 1 | Years |
| Experience with Kingsway Soft and/or SSIS | Nice to have |
Recommended Jobs
Marine Welder
Job Description Job Description Job Description: QED Systems, an experienced marine engineering, planning, and ship modernization firm, is seeking Marine Welders. Qualified candidates must …
Barista Counter Team
$18-$25 Description Gustave Boulangerie, a new bakery in the heart of Del Ray VA, is seeking a skilled and enthusiastic Counter and Barista to join our team. Our bakery will be providing the fine…
Caregiver 3-11pm shift
Job Description Job Description Benefits: Competitive salary Flexible schedule ComForCare Home Care is a franchise of premier in-home care providers. We take time to understand the nee…
Assistant Community Manager
Job Description Job Description Assistant Community Manager Assistant Community Manager This position is responsible for assisting the Community Manager in the overall operations of the pro…
Data Scientist
Teracore is a Service Disabled Veteran Owned Small Business (SDVOSB) classified management consulting and information technology services firm. We are committed to creating and maintaining a corporat…
Senior Splunk Engineer
Our client, a IT Solutions organization, is hiring a Senior Splunk Engineer to join the team in Virginia on a contract basis. The successful candidate will play a key role in developing secure, scalab…
Fleet Manager
PURPOSE: Serve as driver's supervisor/representative in Operations. Manage drivers performance in identified categories and be primary communication link to drivers. Work to achieve optimum driver an…
Floater Teacher FT
Job Description Job Description Benefits: ~401(k) matching ~ Competitive salary ~ Dental insurance ~ Flexible schedule ~ Health insurance ~ Paid time off ~ Training & development …
Pharmacy Technician
Job Description Job Description Company Description International Health and Medical Services delivers customized medical and security risk management and wellbeing solutions to enable our c…
Construction Crew Leader (Richmond, VA)
Job Description Job Description Description: Lead member of a 3 to 6-person field crew. Lead and direct the construction of in-ground swimming pools. Duties and Responsibilities · Read co…