Senior Data Engineer- 1 Year Position

Deseret Mutual Benefit Administrators; Salt Lake City (UT); Hybrid; USD 110,000 - 165,000; Full time

Benefits offered by this job

Competitive pay

Rich medical, vision and dental plans

Generous paid leave and holidays

Tuition reimbursement

Career development through training

Job summary

DMBA (Deseret Mutual Benefit Administrators) seeks a Senior Data Engineer to lead hands-on data, DB, analytics, and integration work in a hybrid role with in-office Mondays and Tuesdays in Salt Lake City. This is a 12-month contract with potential extension.

The ideal candidate has deep SQL and relational data expertise and experience with SQL Server, Oracle, Alteryx, Tableau and Power BI in a data warehouse environment, capable of solving complex data problems across diverse sources.

Qualifications

• Advanced SQL skills and extensive experience with relational databases.
• Ability to understand complicated data models and translate business needs into data solutions.
• Experience validating, troubleshooting, and documenting data processes.

Responsibilities

• Design, develop, and maintain data solutions using SQL and related data technologies.
• Create and modify database objects, queries, views, stored procedures, and other data structures.
• Develop data transformations and processes for operational, analytical, and reporting needs.
• Assist with data warehouse development and enhancement.

Skills

Advanced SQL

Relational databases

Data analysis

Problem solving

Data validation

Tools

SQL Server

Oracle

Alteryx

Tableau

Power BI

Job description

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 a highly experienced Senior Data Engineer to serve as a hands-on technical resource for a broad range of data, database, analytics, and integration needs. 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.

This role is intended for someone who can independently take on complex and sometimes ambiguous data problems, understand the underlying systems and business requirements, determine an appropriate solution, and carry that solution through development, validation, troubleshooting, and implementation.

The ideal candidate will have deep SQL and relational data expertise, strong analytical and problem-solving skills, and experience working across multiple data technologies. Our environment includes SQL Server, Oracle, Alteryx, Tableau, Power BI, data warehouse technologies, and other enterprise data sources.

Key Responsibilities

Data Development & Engineering

• Design, develop, and maintain data solutions using SQL and related data technologies.
• Create and modify database objects, queries, views, stored procedures, and other data structures as needed.
• Develop data transformations and processes supporting operational, analytical, and reporting needs.
• Assist with data warehouse development and enhancement.

Data Analysis & Problem Solving

• Independently investigate complex and ambiguous data problems.
• Explore unfamiliar databases, schemas, and systems to understand their structure and relationships.
• Analyze datasets to identify patterns, relationships, anomalies, and potential issues.
• Translate business data needs into practical technical solutions.

Validation & Troubleshooting

• Trace data across source systems, transformation processes, databases, and reporting environments.
• Review and troubleshoot existing SQL, Alteryx workflows, data processes, and analytical solutions.

Analytics & BI Support

• Create and prepare datasets for use by reporting and analytics solutions.
• Understand how underlying data design affects downstream Power BI and Tableau reporting.
• Assist with Power BI, Tableau, or similar analytical development when appropriate.

Technical Skills

Required

• Advanced SQL skills and extensive experience working with relational databases.
• Strong understanding of database design, relational structures, keys, joins, data types, constraints, and data integrity.
• Experience creating, transforming, analyzing, validating, and troubleshooting data.
• Ability to understand complicated and unfamiliar data models.
• Ability to independently investigate and solve data problems with limited direction.
• Strong analytical, troubleshooting, and problem-solving skills.
• Experience translating ambiguous business or technical problems into workable data solutions.
• Ability to validate one's own work and determine whether the resulting data is correct.

Highly Valuable

• Experience with several of the following is desirable:
• Microsoft SQL Server / T-SQL
• Oracle
• Alteryx
• Data warehouse development
• ETL/data integration
• Data modeling
• Power BI
• Tableau
• Data validation and reconciliation

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