Previous Job
Previous
BI Engineer 4
Ref No.: 17-03831
Location: Riverton, Utah
Job Title: Database Engineer 4 (Business Intelligence)
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.

· 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 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 BusinessObjects Web Intelligence.
· Create dashboards using various tools such as Microsoft Power BI and Tableau.
· Quickly and accurately respond to Ad-Hoc information requests.
· 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.
The database engineer i4 s 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.
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 7-9 years of data warehouse experience
· Expert SQL skills
· Proficiency with ETL tools & methodologies
· Proficiency with dimensional data modeling
· 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