Senior Data Engineer- 1 Year Position
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 highly experienced Senior Data Engineer. 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 Senior Data Engineer serves as a hands-on technical resource for data, database, analytics, and integration needs. The role requires independently addressing complex and sometimes ambiguous data problems by understanding systems and business requirements, selecting appropriate solutions, and carrying them through development, validation, troubleshooting, and implementation. 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 structure 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 plan that starts accruing on 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.
- Company-sponsored career development programs and over 5,000 on-demand online training courses.
- Hybrid work schedules available depending on position.
- Employee Assistance Program.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
Education Level
No Education Listed
