Previous Job
Data Warehouse Engineer 2
Ref No.: 17-03317
Location: Riverton, Utah
Data Warehouse Engineer 2-Contingent
Riverton, UT
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 to help the departments of the Church have the information they need to move the Lord's work forward.

Must be a member of The Church of Jesus Christ of Latter-day Saints and currently temple worthy.

Required skills:
· 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 2-4 years of data warehouse experience
· Experience with SQL
· Understanding of ETL tools & methodologies
· Understanding of dimensional data modeling
· Experience with data analysis and report design/development
· 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
· Gather and document requirement for the data warehouse.
· Assist in the design of dimensional Star Schema data models to support front-end BI tools including ad-hoc reporting.
· Assist in the creation and support 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 various reporting tools such as SQL Server Reporting Services (SSRS) and Business Objects Web Intelligence. Create dashboards using various tools such as Microsoft Power B.
· Quickly and accurately respond to Ad-Hoc information requests.
· 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.