Data Analyst Job at Intellibee Inc, Richmond, VA

NG9YYWtvMkJEN1hWZ1F0RXJoU1dLSFBreUE9PQ==
  • Intellibee Inc
  • Richmond, VA

Job Description

Data Analyst,Richmond, VA,United States

Data Analyst

We're seeking a Data Analyst with SQL skills and Microsoft Dataverse experience to support post-migration data cleanup and reconciliation.

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).

Skill Matrix

  • 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

Job Tags

2 days per week, 1 day per week,

Similar Jobs

The Shella Foundation

Data Entry Assistant Job at The Shella Foundation

 ...We are looking for a reliable and detail-oriented Remote Data Entry Assistant to help with basic data entry tasks. This is an easy...  ...or Google Sheets (preferred but not required) No previous experience required (training provided) Benefits Work from home... 

Clean Harbors

Lab Chemist I - Summer 2026 Internship Job at Clean Harbors

 ...a highly technical safety minded person for our Lab Chemist Internship to join our team in El Dorado, AR team. Responsibilities included...  ...instrumentation through GC, IC, ICP, and various analytical laboratory instruments Shadowing supervisor and technician, Learn... 

THE VA GROUP

SEO & Website Specialist Job at THE VA GROUP

 ...We are looking for a detail-oriented**SEO & Website Marketing**VA to support with marketing and digital presence. This part-time role is ideal for someone with hands-on experience in SEO and WordPress who enjoys improving website performance, supporting content updates... 

Ralston Public Schools

High School Special Education Teacher Job at Ralston Public Schools

 ...or professional meetings, or by conducting research. Organizes and maintains a system for accurate and complete record-keeping, grading, and reporting for all student activities, achievement and attendance as required by district procedures and applicable laws. Encourages... 

Daytona Aircraft Services, Inc.

Aircraft Mechanic Job at Daytona Aircraft Services, Inc.

 ...Health insurance ~ Paid time off Job Summary: The Aircraft Mechanic is responsible for inspecting, repairing, and maintaining aircraft...  ...Powerplant (A&P) certification. Minimum of 1 years of experience in aircraft maintenance. Strong knowledge of aircraft...