Senior Data Engineer- 1 Year Position

Deseret Mutual Benefit Administrators•Salt Lake City, UT

6d•Hybrid

About The Position

DMBA (Deseret Mutual Benefit Administrators) is a non-profit organization that administers benefits for companies owned or affiliated with The Church of Jesus Christ of Latter-day Saints. DMBA is 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 schedule, with required in-office work on Mondays and Tuesdays. The position is intended for someone who can independently take on complex, sometimes ambiguous data problems; understand underlying systems and business requirements; select an appropriate solution; and carry it through development, validation, troubleshooting, and implementation. The candidate should have deep SQL and relational data expertise, strong analytical and problem-solving skills, and experience with multiple data technologies. The environment includes SQL Server, Oracle, Alteryx, Tableau, Power BI, data warehouse technologies, and other enterprise data sources.

Requirements

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.

Nice To Haves

Experience with Microsoft SQL Server / T-SQL.
Experience with Oracle.
Experience with Alteryx.
Experience with data warehouse development.
Experience with ETL/data integration.
Experience with data modeling.
Experience with Power BI.
Experience with Tableau.
Experience with data validation and reconciliation.

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 supporting operational, analytical, and reporting needs.
Assist with data warehouse development and enhancement.
Independently investigate complex and ambiguous data problems.
Explore unfamiliar databases, schemas, and systems to understand their structures and relationships.
Analyze datasets to identify patterns, relationships, anomalies, and potential issues.
Translate business data needs into practical technical solutions.
Trace data across source systems, transformation processes, databases, and reporting environments.
Review and troubleshoot existing SQL, Alteryx workflows, data processes, and analytical solutions.
Create and prepare datasets for 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.

Benefits

Competitive pay.
Medical, vision, and dental benefits with low premiums.
401(k) company match.
8% EDRC Employer Discretionary Retirement Contribution.
Life insurance.
Onsite full-service financial planners at no cost.
Generous paid leave accruing from the first day.
Birthday off.
Additional sick leave.
12 paid holidays.
Award-winning wellness program with the ability to earn three additional days off per year.
Fun activities and an onsite gym.
Tuition reimbursement.
Career development through company-sponsored programs and more than 5,000 on-demand online training courses.
Employee Assistance Program.