Job Details

BI Engineer III
Go to our website »

Position Number: 5968292
Location: Orem, UT
Position Type: Computing - Database Administration

BI Engineer III

Salary: Depends on Qualifications
Job Type: FT Exempt Salaried Staff
Job Number: FY2503862
Closing: 2/11/2025 11:59 PM Mountain
Location: DX Building
Division: VP Digital Transformation/CIO

Position Announcement

Elevate data-driven decision-making at Utah Valley University as a BI Engineer III! In this dynamic role, you'll design, develop, and support cutting-edge business intelligence applications, including ETL workflows, data warehouses, and data marts. By analyzing database design requirements and collaborating with stakeholders, you'll create impactful solutions that turn complex data into clear, actionable insights. Your expertise will simplify technical environments, making information more accessible through effective and timely visual communication. If you're passionate about using data to drive meaningful change and want to be part of an innovative, forward-thinking team, this is your opportunity to make a real impact at UVU!

Summary of Responsibilities

Data Model Development, Validation, & Troubleshooting - Supports moving data from Ingestion layers into the defined, documented domains/data marts and/or warehouses
Data Process Documentation & Design - ERD Diagrams, Definition Verification - working with UVU's established Data Governance processes and Data Intelligence Platform, Data Mappings
Data Model Design: Evaluate existing data systems; working with the development team to create conceptual data models and data flows; develop bespoke databases/warehouses/marts utilizing a mixture of conceptual, physical and logical models as appropriate.
Support Business Processes to bring Data Models to UVU's Data Intelligence Platform.
Professional Development -spends time keeping up with current trends in the BI Engineering space and help UVU (Utah Valley University) prepare to adjust and lead in those trends
Other duties as assigned.

Qualifications / Licenses / Certifications

Bachelor's degree plus 5-10 years of related experience, or equivalent combination of education and related experience.
At least 2 industry certifications related to the tools used in the job are required or required to receive within the first 90 days of employment.

Knowledge / Skills / Abilities

Knowledge

Knowledge in Agile Data Modeling methods
Knowledge in Kimball Warehousing
Knowledge in Collibra (Data Intelligence Platform)
Understands Visual Collaboration Tools (Lucid, Visio, etc.)
Experience with work management / ticketing systems
Experience in data visualization / presentation tools
Experience with at least one scripting language (Perl, Python, Ruby, PHP)

Skills

Experience with SQL (Oracle, T-SQL, etc.)
Experience with Jupiter Notebooks
Experience with Azure Synapse
Direct experience using business intelligence reporting tools (Tableau, Power BI, Business Objects, Cognos, etc.)
Direct experience using ETL Tools (SQL, Informatica, Synapse, Oracle Data Integrator, etc.)
Relational database modeling, design, and management (PostgreSQL, Oracle, MySQL, MS SQL Server)
Data warehouse and data mart modeling and design

Abilities

Ability to summarize complexity.
Ability to simplify technical concepts.
Demonstrates effective visual communication (drawing, slides, diagrams, etc.)
Communicates technical concepts and analysis implications clearly to a wide audience, including senior executives

EEO Statement:

UVU employment decisions are made on the basis of an applicant's qualifications and ability to perform the job without regard to race, color, religion, national origin, sex, sexual orientation, gender identity, gender expression, age (40 and over), disability, veteran status, pregnancy, childbirth, or pregnancy-related conditions, genetic information, or other bases protected by applicable federal, state, or local law.

To apply, please visit https://www.schooljobs.com/careers/uvu/jobs/4811872/bi-engineer-iii

jeid-fd23d81832981348aa173745c232cf1d