drjobs Data Analyst 3 (Hybrid)

Data Analyst 3 (Hybrid)

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Richmond - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Job Title: Data Analyst 3 (Hybrid)
Location: Richmond VA
Duration:12 Months

Job Description:
We are seeking a detailoriented Data Analyst with strong SQL skills and experience working with Microsoft Dataverse to support postmigration 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 12 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 Kingsway Soft SSIS or other ETL tools (helpful but not required for this postmigration phase).

Skills:
SkillRequired / DesiredAmountof ExperienceProficient in SQL3YearsStrong understanding of Microsoft Dataverse2YearsPower BI2YearsExperience analyzing large datasets2YearsPower Automate1YearsExperience with Kingsway Soft and/or SSISNice to have

Required Experience:

Senior IC

Employment Type

Contract

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.