Data and BI Engineer

Why Work at BYU   

As the flagship higher education institution of The Church of Jesus Christ of Latter-day Saints, Brigham Young University (BYU) strives to be among the exceptional universities in the world. At BYU, we are devoted to our faith and to our students. We take an active role in the University's Mission: "To assist individuals in their quest for perfection and eternal life.” 

Our unique mission, deeply rooted in the Gospel of Jesus Christ, provides countless ways to serve and make an impact. This, along with our remarkable culture of belonging, weekly devotionals, and endless opportunities for learning and growth—all situated within a beautiful and historic campus—make it hard to imagine a more inspiring place to work. 

Brigham Young University strongly prefers to hire faithful members of The Church of Jesus Christ of Latter-day Saints.

Data and Business Intelligence Engineer

We are looking for a data and business intelligence (BI) engineer to help us modernize data access and data-driven decision-making. In this position, you will design, develop, and support data and business intelligence applications. These applications include: extract, transform, and load (ETL) workflows; data warehouses and data marts; and interactive reports and dashboards. Additional duties include database design, requirements analysis, and customer consultation. Required technical skills include

What you will be doing in this position

Report & Dashboard Development

• Provide technical support to campus report developers.
• Query and modify multiple types of database systems: relational, key-value, graph, data warehouse, etc. 

Data and Business Modeling

• Data modeling: analyze and define database structures based on business models.

Data Movement and Integration

• Optimize ETL workflows

Database Analysis, Documentation, & Problem Resolution

• Identify, analyze, and resolve technical problems.
• Ensure that all proposed system changes have been adequately planned and reviewed eliminating the possibility of unplanned service outages.

BI/Data Standards

• Recommend/lead in creating standards for Data and BI Engineers to follow.
• Ensure compliance with technical and architectural standards.

What qualifies you for this role

Education and Experience

This position provides an opportunity for people of varying levels of skill. If you have a lot of education, experience, and skill, we’ll compensate you accordingly. If you are early in your career, this could be a great opportunity for you, too. Different levels of pay are assigned by the hiring department depending on experience/education/skills and business needs.

• Level 53: Bachelor’s degree or four years of a combination of education and Data & BI experience. ($73,000-$95,000)

• Level 54T: Bachelor’s degree and two years of Data & BI experience, or an equivalent combination of relevant education and Data & BI experience required. ($88,000-$114,000)

• Level 55T: Bachelor’s degree and five years of Data & BI experience, or master’s degree and 3 years Data & BI experience, or an equivalent combination of relevant education and Data & BI experience is required. ($102,000-$132,500)

Skills, abilities, or knowledge

Desired experience with:

• PostgreSQL
• Oracle
• SQL
• Linux
• AWS
• Bash
• Python
• Data Build Tool (dbt)
• Informatica
• JavaScript/TypeScript
• APIs ​
• Go
• Terraform
• Docker

What we offer in return:

In addition to our competitive pay structure, this position comes with fantastic benefits, including:

• 401k. BYU automatically contributes 8% at no cost to you. Additionally, if you contribute 5%, BYU adds an additional 4% (Rehires may qualify for different retirement plans)

• Excellent work-life balance: 13 paid holidays + 22 days paid vacation + 12 sick days, accrued annually

• Employee assistance program, available to the employee and all members of their household

• Tuition benefits for