Data and BI 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., * PostgreSQL
• Oracle
• SQL
• Linux
• AWS
• Bash
• Python
• Data Build Tool (dbt)
• Informatica
• JavaScript/TypeScript
• APIs
• Go
• Terraform
• Docker

Do you have experience in Graph databases?, Do you have a Master's degree?, 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)

4.54.5 out of 5 stars Provo, UT $73,000 - $132,500 a year - Full-time, Pulled from the full job description

• Tuition reimbursement

• Paid parental leave

• Parental leave

• 401(k)

• Health insurance

• Dental insurance

• Employee assistance program, 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 employees and eligible family members

• Access to athletic facilities

• Excellent medical/dental benefits

• Short/long-term disability benefits

• Paid parental and maternity leave

• Wellness Program

• Free on-campus parking

• Free UTA passes for employees, spouses, and qualified dependents

• Discounts at the BYU Store and for many events 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., Brigham Young University (BYU) is widely recognized not just for its world-class education, but for its deep commitment to inspired religious values. Gathered together in a Christ-centered atmosphere, BYU employees are a vital part of a community of belonging, where we value the experiences, perspectives, and talents of each individual. If you share in our devotion to faith and to excellence, we have a place for you here at BYU!