Senior Data Engineer - Migration & Quality - 1 Year Position

Deseret Mutual Benefit Administrators•Salt Lake City, UT

4d•Hybrid

About The Position

DMBA (Deseret Mutual Benefit Administrators), a non-profit organization that administers benefits for companies owned or affiliated with The Church of Jesus Christ of Latter-day Saints, is seeking a Senior Data Engineer for Migration & Quality. This is a 12-month contract position with the potential for a 12-month extension. The role supports a large-scale migration from an Oracle to a SQL Server health insurance claims processing platform and continued expansion of the enterprise data warehouse. Its primary focus is migrating reporting logic, data-load processes, and business rules from legacy solutions into the enterprise data warehouse while supporting the organization's transition to the new platform. As legacy structures are retired, the engineer will help identify equivalent modern data and business rules and establish the warehouse as the long-term source of truth for reporting and downstream integrations. The engineer will work with BI/ETL developers, senior engineers, architects, business subject matter experts, and AI-assisted analysis tools. This hands-on analytical, migration, validation, and data-quality role involves learning unfamiliar schemas and business processes, investigating discrepancies, tracing logic across systems, reverse-engineering processes, and determining how rules should be implemented in the future-state warehouse architecture. The position follows a hybrid schedule, with required in-office work on Mondays and Tuesdays.

Requirements

Strong SQL and relational database skills, particularly with SQL Server.
Strong analytical and problem-solving ability.
Experience performing data validation, reconciliation, data profiling, migration testing, or database-level QA.
Ability to write SQL to compare and analyze large datasets across complex database structures.
Ability to quickly learn unfamiliar database schemas, data models, and business processes.
Strong data reconciliation skills, including identifying, investigating, and resolving discrepancies across multiple systems.
Ability to reverse-engineer existing reports, processes, data models, and business rules.
Curiosity and an investigative mindset, with an interest in understanding how data moves through enterprise systems.
Ability to work from incomplete documentation and independently develop appropriate validation and reconciliation approaches.
Ability to collaborate with engineers, business stakeholders, and AI-assisted tools to solve complex data problems.

Nice To Haves

Microsoft SQL Server / T-SQL experience.
Experience validating ETL, ELT, or data warehouse processes.
Experience with data migrations and large-scale system conversions.
Experience migrating reporting logic from legacy systems to modern data platforms.
Experience with healthcare or health-plan data.
Experience using AI-assisted analysis and development tools to accelerate data analysis, validation, and documentation.

Responsibilities

Migrate reporting logic, data-load processes, and business rules from legacy solutions into the enterprise data warehouse.
Support the organization's transition from an Oracle to a SQL Server health insurance claims processing platform.
Determine how legacy logic should be translated into the future-state warehouse architecture in collaboration with BI/ETL developers, engineers, architects, business subject matter experts, and AI-assisted analysis tools.
Understand current-state logic and identify equivalent modern data and business rules as legacy structures are retired.
Help ensure the enterprise data warehouse becomes the long-term source of truth for reporting and downstream integrations.
Perform data migration, business logic conversion, data quality and reconciliation, QA, validation, data analysis, and investigation.
Investigate complex data discrepancies and trace logic across multiple systems.
Reverse-engineer existing reports, processes, data models, and business rules.
Develop validation and reconciliation approaches when documentation is incomplete.
Identify, investigate, and resolve discrepancies across systems.

Benefits

Competitive pay.
Medical, vision, and dental benefits with low premiums.
Retirement planning including a 401(k) company match and an 8% EDRC Employer Discretionary Retirement Contribution.
Life insurance.
Onsite full-service financial planners at no cost.
Generous paid leave that starts accruing on the first day, birthday off, additional sick leave, and 12 paid holidays.
Wellness program with the ability to earn three additional days off a year, activities, and an onsite gym.
Tuition reimbursement.
Career development through company-sponsored programs and more than 5,000 on-demand online training courses.
Hybrid work schedules available depending on position.
Employee Assistance Program.