BI & Analytics Engineer

University of the Cumberlands; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

The University of the Cumberlands is building a new Data Engineering team within IT, and we're looking for a BI & Analytics Engineer to own business intelligence and reporting across the University. You'll work directly with stakeholders to understand decisions they need to make, build trusted data models in Snowflake using dbt, and deliver clear, focused reports in Power BI.

You'll also help define the shared metrics, definitions, and business context that allow AI tools and agents to answer

Qualifications

• Bachelor's degree in a related field or equivalent combination of education and experience.
• 4+ years in business intelligence, analytics, or related data role.
• Strong SQL skills including joins, aggregations, CTEs, and troubleshooting.
• Experience building reports or dashboards in a BI tool such as Power BI, Tableau, Looker, Sigma, or Omni.
• Solid understanding of data modeling concepts such as fact and dimension tables and star schemas.
• Demonstrated ability to gather requirements from non-technical stakeholders and turn them into useful reports.
• Track record of working independently: managing your own priorities and owning work from request to delivery.
• Strong attention to data accuracy and sound judgment around data privacy and access.
• Clear written and verbal communication.

Responsibilities

• Owner of the University's Power BI environment including workspaces, permissions, publishing, and reports lifecycle.
• Build and maintain dashboards for admissions, enrollment, retention, and finance.
• Review reports to decide which to rebuild, consolidate, or retire.
• Build dbt models in Snowflake to turn source data into clean, documented, and tested datasets.
• Define business logic in dbt to ensure metrics are consistent across reports.
• Document shared metrics, business definitions, and semantic models supporting reporting and AI queries.
• Validate data and reports and explain discrepancies.
• Collaborate with stakeholders to clarify questions, metrics and how the report will be used.
• Explain report logic and data limitations; support adoption with training.

Skills

SQL

Power BI

Data modeling

Stakeholder requirements

Independent delivery

Data privacy

Communication

Education

Bachelor's degree in a related field or equivalent combination of education and experience

Tools

Snowflake

dbt

Git

Job description

Get Set for Cumberlands! Join our team of student-focused individuals working together in order to encourage intellectual and spiritual growth, leadership and service.

The University of the Cumberlands is building a new Data Engineering team within IT, and we're looking for a BI & Analytics Engineer to own business intelligence and reporting across the University. You'll work directly with stakeholders to understand the decisions they need to make, build trusted data models in Snowflake using dbt, and deliver clear, focused reports in Power BI. You'll also help define the shared metrics, definitions, and business context that allow AI tools and agents to answer questions about University data accurately and safely. Our Power BI footprint is still small, so you'll have real influence: setting standards, taking ownership of existing reports, and building a foundation that grows with the platform. As the University's primary BI resource, working closely with the Lead Data Engineer, you'll manage your own priorities and move work forward independently.

Key Responsibilities

• Reporting & Power BI Ownership Own the University's Power BI environment, including workspaces, permissions, publishing, and the lifecycle of existing reports.
• Build and maintain accurate, accessible, and performant dashboards and reports for operational and leadership audiences in areas such as admissions, enrollment, retention, and finance.
• Review existing reports and recommend which to rebuild, consolidate, or retire.
• Data Modeling & Semantics Build and maintain dbt models in Snowflake that turn source data into clean, documented, and tested datasets.
• Build business logic in dbt so reports stay simple and consistent and metrics mean the same thing everywhere they appear.
• Define and document shared metrics, business definitions, and semantic models that support both reporting and AI agents querying University data.
• Validate data and reports, and investigate and clearly explain discrepancies.
• Stakeholder Partnership Scope requests directly with stakeholders by clarifying the underlying question, the metrics and definitions involved, and how the report will be used.
• Push back constructively on unclear requirements and help stakeholders get to a better question.
• Explain report logic and data limitations in plain language, and support adoption through training and documentation.
• Standards & Governance Help establish practices for data modeling, report design, documentation, and version control, and contribute to the University's emerging data governance standards.

Qualifications

• Bachelor's degree in a related field, or an equivalent combination of education and experience.
• 4+ years of experience in business intelligence, analytics, reporting, or a related data role.
• Strong SQL skills, including joins, aggregations, CTEs, and troubleshooting data issues.
• Experience building reports or dashboards in a BI tool such as Power BI, Tableau, Looker, Sigma, or Omni.
• Solid understanding of data modeling concepts such as fact and dimension tables and star schemas.
• Demonstrated ability to gather requirements from non-technical stakeholders and turn them into useful reports.
• Track record of working independently: managing your own priorities and owning work from request to delivery.
• Strong attention to data accuracy and sound judgment around data privacy and access.
• Clear written and verbal communication.

Preferred

• Preferred Power BI experience, including DAX, row-level security, and workspace administration.
• Candidates with strong experience in another BI tool and a willingness to learn Power BI quickly are encouraged to apply.
• Experience with dbt or a similar SQL-based transformation tool.
• Experience with Snowflake or another cloud data warehouse.
• Familiarity with Git or other version control.
• Experience building semantic layers or metric definitions for self-service analytics or AI tools (e.g., Snowflake semantic views, dbt Semantic Layer, LookML).
• Higher education experience, or familiarity with systems such as Workday Student, Slate, or Blackboard.
• Exposure to data governance practices such as metric certification, data quality, documentation, or lineage.

Why Join Us

Be a founding member of a new Data Engineering team, with real ownership of BI across the University.

Work remotely on a modern data stack: Snowflake, dbt, and Power BI.

Help shape how the University uses data and AI to make decisions Cumberlands is different by design.

Located in the heart of Appalachia, University of the Cumberlands (UC) is an institution of regional distinction that offers undergraduate degrees in more than 40 major fields of study, along with several pre-professional, graduate and doctoral programs.

With a total enrollment of more than 20,000 students, UC is one of the largest and fastest growing private universities in Kentucky and is devoted to preparing students for the future through hands-on, experiential learning and research.

The University of the Cumberlands does not illegally discriminate on the basis of race, color, national or ethnic origin, sex, disability, age, religion, genetic information, veteran status, because a person is a smoker or nonsmoker, or any other basis on which the University is prohibited from discrimination under local, state, or federal law, in its employment or in the provision of its services, including but not limited to its programs and activities, admissions, educational policies, scholarship and loan programs, and athletic and other University -administered programs.

In order to fulfill its purpose, the University may legally discriminate on the basis of religion in employment, and the University has sought and been granted exemption from certain regulations promulgated under Title IX of the Education Amendments of 1972 which conflict with the University's religious tenets.