| 762172 |
Data Analyst |
Yakshna Solutions, Inc., (YSI) is a CMMI Level 3 assessed, ISO 9001, 20000:1, 27001 certified, woman-owned small business enterprises, headquartered in Herndon, Virginia, USA. YSI provides professional IT solutions and services to business corporations and government organizations. YSI is committed to serve its business communities as a leading IT vendor providing innovative, quality, and cost-effective IT business solutions and services.
We offer a competitive benefits package that includes the following: 401(k), health, dental, and vision insurance, Life insurance, short-term and long-term disability insurance, paid time off, training, and professional development assistance.
DCJS is seeking a Data Analyst with SQL skills and Microsoft Dataverse experience to support post-migration data cleanup and reconciliation. The data migration from SQL Server to Dataverse has been completed, and this role will focus on reconciling records, identifying inconsistencies, and performing clean up tasks to ensure the integrity and usability of data in the new system. This position is hybrid, so teleworking is available, however, candidates will need to be onsite 1-2 days per week for onboarding and initial knowledge transfer.
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.
- Experience using KingswaySoft, SSIS, or other ETL tools (helpful but not required for this post migration phase).
YSI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
|