DCJS Data Analyst 3
Share
Job Location:
Richmond, VA - USA
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Engagement Type
Contract
Short Description
Were seeking a Data Analyst with SQL skills and Microsoft Dataverse experience to support post-migration data cleanup and reconciliation.
Hybrid work schedule Candidate must be able to work on site.
Complete Description
About the Role:
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:
-
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.
Preferred Qualifications:
-
Experience using KingswaySoft SSIS or other ETL tools (helpful but not required for this post-migration phase).
Required/Desired Skills
| 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 | 0 |
Questions
| Description | |
|---|---|
| Question 1 | Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment |
| Question 2 | Please list candidates email address. |
| Question 3 | what city and state is your candidate currently located |
| Question 4 | Can your candidate commit to working a hybrid on site schedule. |
Key Skills
- Data Analytics
- Microsoft Access
- SQL
- Power BI
- R
- Data Visualization
- Tableau
- Data Management
- Data Mining
- SAS
- Data Analysis Skills
- Analytics
