Business Intelligence and ETL Manager

Deseret Mutual Benefit Administrators - Salt Lake City, UT

Full-time - Mid Level

Salt Lake City, UT

About the position

The Business Intelligence and ETL Manager at Deseret Mutual Benefit Administrators is a leadership role focused on overseeing the BI/ETL team, managing complex data projects, and ensuring the successful delivery of business intelligence solutions. The position requires a self-motivated individual who is adept at project management, team development, and utilizing various ETL tools to enhance data processes. The manager will also mentor team members and facilitate collaboration between technical and business stakeholders to meet organizational data needs.

Responsibilities

• Supervise, prioritize, coordinate, and organize the work of BI/ETL team members.
• Project manage and monitor the varied and complex BI and ETL needs of the company, ensuring successful beginning-to-end delivery of projects.
• Lead and mentor the team in daily work using Agile methodologies, utilizing Jira for project management.
• Coordinate with engineers and the business on requirements, tasks, solutions, and deliverables, ensuring standards are followed and improved.
• Facilitate problem-solving sessions with business and technical leaders to identify business needs and translate them into BI requirements.
• Mentor, train, and develop team members' technical and professional skills.
• Utilize and implement ETL tools to reduce code, increase throughput, and build workflows for data transformation.
• Create dashboards, visualizations, reports, analytics, and alerts to meet end-user needs and provide insights to decision-makers.
• Participate in the design, development, validation, and testing of BI, ETL, and other data processes.

Requirements

• At least 6-8 years' experience with BI, ETL, IT, project management, and managing teams.
• Strong experience with Extract, Transform, and Load (ETL) processes and principles; familiarity with multiple ETL tools is a bonus.
• Experience with data visualization tools such as Power BI, Tableau, or MicroStrategy.
• Strong experience utilizing Oracle and SQL Server data, APIs, data cleansing, and error handling.
• Effective written and verbal leadership, communication, and presentation skills.
• Detail-oriented, organized, and capable of completing data and BI projects.
• Flexibility, problem-solving, and conflict resolution skills; self-motivated.
• Minimum typing speed of 50 WPM.
• Master's degree in Information Systems, Business, or related field.

Nice-to-haves

• Alteryx, Power BI, and/or Tableau certifications.
• AWS or Azure data streaming and pipeline experience.
• GraphQL or other data API experience.
• Data warehousing architecture and data modeling expertise.
• Project management certification (PMP®).
• Experience with health insurance processes.

Benefits

• Wellness program
• 401(k) 8% Match
• Paid holidays
• Health insurance
• On-site gym
• Dental insurance
• Tuition reimbursement
• Employee assistance program
• Vision insurance
• 401(k) matching
• Gym membership
• Life insurance