Previous Job
Previous
BI Engineer 5
Ref No.: 17-03832
Location: Riverton, Utah
Data Warehouse Engineer
Riverton, Utah
12-24 month contract

Job Description

The Business Intelligence team of the Church works with multiple departments to take their data and transform it into information that will allow them to make better decisions. We work with departments such as Temple, Publishing Services, Missionary, Finance, and Family History in hastening the work of the Lord.

"This individual works with divine guidance to provide or support technology that furthers the mission of the Church and reflects the eternal impact of the gospel.”

The data warehouse engineer is responsible for gathering requirements, design, creation and support of the data warehouse. Engineers have the opportunity help the departments of the Church have the information they need to move the Lord's work forward.

Required Skills

· Gather and document requirement for the data warehouse.
· Design dimensional Star Schema data models to support front-end BI tools including ad-hoc reporting.
· Create and support all ETL jobs pulling data from various source systems and loading into the data warehouse.
· Design and create a semantic layer to support end-user self-service.
· Create reports using SQL Server Reporting Services (SSRS).
· Create dashboards using Microsoft Power BI or Tableau.
· Quickly and accurately respond to Ad-Hoc information requests.
· Forecast, analyze data and trends and create reports that highlight areas in need of performance improvement.
· Work with all levels of end users, including executive staff.
· Interact with customers as a technical resource to troubleshoot problems with the delivered BI solutions.



· Requires a Bachelor's degree in computer science or related field
· Must be a member of the Church of Jesus Christ of Latter-day Saints, currently temple worthy
· Typically 10+ years of data warehouse experience
· Expert SQL skills
· Expert dimensional data modeling skills
· Extensive professional experience in data analysis and report design/development
· Experience in presentation/interface creation
· Ability to quickly learn new tools and technology
· Strong problem solving, analytical and diagnostic skills
· Ability to interact well in a team environment
· Excellent documentation and communication skills