Senior Data Engineer - Migration & Quality- 1 Year Position

Deseret Mutual Benefit Administrators; Salt Lake City (UT); Hybride; USD 120 000 - 150 000; Plein temps

Avantages offerts par ce poste

Competitive pay

Rich medical, vision and dental plans

Retirement plan with 401(k) match and

Generous paid leave and holidays

Wellness program with additional days

Tuition reimbursement

Career development programs

Hybrid work schedules

Employee Assistance Program

Résumé du poste

Deseret Mutual Benefit Administrators is seeking a Senior Data Engineer for Migration & Quality to lead a large-scale migration from Oracle to SQL Server health insurance claims processing platform, and to expand the enterprise data warehouse. This 12-month contract requires in-office work on Mondays and Tuesdays, with a hybrid schedule.

The role involves migrating reporting logic, data-load processes, and business rules, ensuring the warehouse becomes the long-term source of truth for reporting

Qualifications

• 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.
• Demonstrated ability to quickly learn unfamiliar database schemas, data models, and business processes.
• Strong data reconciliation skills, including the ability to identify, investigate, and resolve discrepancies across multiple systems.

Responsabilités

• Data Migration & Business Logic Conversion
• Data Quality & Reconciliation
• QA & Validation
• Data Analysis & Investigation

Connaissances

SQL Server

Data migration

Data quality

Data analysis

Problem solving

Reverse-engineering

Collaborative work

Outils

SQL Server / T-SQL

Description du poste

DMBA (Deseret Mutual Benefit Administrators) is a non-profit organization that administers benefits for companies who are owned or affiliated with The Church of Jesus Christ of Latter-day Saints.

Role Summary

We are seeking an experienced Senior Data Engineer for Migration & Quality to support a large-scale migration from an Oracle to SQL Server health insurance claims processing platform, as well as the continued expansion of the enterprise data warehouse. This is a 12-month contract position with the potential for a 12-month extension. The role follows a hybrid work schedule, with required in-office work on Mondays and Tuesdays. The primary responsibility of this role will be to migrate 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. Many existing reports, extracts, operational processes, and downstream systems currently rely on business logic embedded in legacy-specific fields, configurations, and workflows. As those legacy structures are retired, this role will be responsible for understanding current-state logic, identifying equivalent modern data and business rules, and helping ensure that the enterprise data warehouse becomes the long-term source of truth for reporting and downstream integrations. This individual will work closely with BI/ETL developers, senior engineers, architects, business subject matter experts, and AI-assisted analysis tools to determine how legacy logic should be translated into the future-state warehouse architecture. Success in this role requires the ability to quickly understand unfamiliar data schemas, data models, business rules, and legacy system behaviors. The ideal candidate enjoys investigating complex data discrepancies, tracing logic across multiple systems, reverse-engineering existing processes, and determining how business rules should be implemented in a modern data platform. This is a hands-on analytical, migration, validation, and data-quality role. The ideal candidate will have strong SQL skills and be comfortable independently working through large, complex relational datasets.

Key Responsibilities

• Data Migration & Business Logic Conversion
• Data Quality & Reconciliation
• QA & Validation
• Data Analysis & Investigation

Technical Skills

Required

• 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.
• Demonstrated ability to quickly learn unfamiliar database schemas, data models, and business processes.
• Strong data reconciliation skills, including the ability to identify, investigate, and resolve discrepancies across multiple systems.
• Ability to reverse-engineer existing reports, processes, data models, and business rules.
• Natural curiosity and investigative mindset with a passion for 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.

Preferred

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

What We Offer:

• Competitive pay
• Rich medical, vision and dental benefits with low premiums. One of the top health plans in Utah
• Rich retirement planning: including 401(k) company match, 8% EDRC Employer Discretionary Retirement Contribution (we just give you free money for retirement), life insurance, and full-service Financial Planners onsite at no cost
• Generous paid leave plan that starts accruing your first day, your birthday off, additional sick leave and 12 paid holidays
• Award winning wellness program with the ability to earn 3 additional days off a year, fun activities and an onsite gym.
• Tuition reimbursement
• Career development through company sponsored programs and over 5000 on-demand online training courses.
• Hybrid work schedules available depending on position
• Employee Assistance Program