▶Apply

Data Analyst

Trillium Professional is now 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.

Pay rate is $45/hour! Apply now!

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

Trillium has been recruiting and placing professionals for over 30 years. From Fortune 100 companies to small businesses, our philosophy remains the same: to achieve excellence by providing quality employees and an uncompromising level of service. We believe in honesty, integrity, and a simple philosophy of providing value to our customers and our employees. We strive to be unsurpassed in the recruitment and placement of quality and skilled professionals. Trillium is an Equal Opportunity Employer.

Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for the employers and the California Fair Chance Act.

By applying to this job, I agree to receive electronic communications including SMS text and email regarding future opportunities, referral bonus incentives, and other promotions from Trillium. You may opt out at any time from future communications by responding STOP to any electronic communication. You may view our full privacy policy at https://trilliumstaffing.com/jobs/privacy/.

Trillium offers a comprehensive benefit package that includes the ability to participate in health insurance and retirement plans, paid holidays, state required leave, and vacation days, if applicable. Trillium’s offerings are dependent on the state in which the assignment is located, length of time worked, and may change depending on assignment. Benefit packages for direct hire placements vary based on the client company.

 

Contact Us if you have any questions

Our intentions are to fill job vacancies as quickly as possible with qualified candidates. We are always accepting applications if a time sensitive job has an application deadline it is noted in the job description. Click on "Apply" to begin the apply process.