BI & Analytics Engineer

This is a fully remote position, open to applicants in Kentucky.

📋 Description

• Take charge of the University's Power BI environment, overseeing workspaces, permissions, publishing, and the lifecycle management of existing reports.

• Develop and sustain accurate, accessible, and high-performance dashboards and reports tailored for both operational and leadership audiences.

• Assess existing reports and provide recommendations for rebuilding, consolidating, or retiring them.

• Construct and manage dbt models in Snowflake that transform source data into clean, well-documented, and thoroughly tested datasets.

• Implement business logic in dbt to ensure reports remain straightforward and consistent, with uniform metrics across the board.

• Define and document shared metrics, business definitions, and semantic models that support reporting and AI agents.

• Validate data and reports, investigating and clarifying any discrepancies.

• Engage directly with stakeholders to scope requests, addressing questions, metrics, definitions, and report usage.

• Provide constructive feedback on ambiguous requirements and assist stakeholders in formulating clearer inquiries.

• Clearly communicate report logic and data limitations in layman's terms.

• Facilitate adoption through effective training and documentation.

• Help establish best practices for data modeling, report design, documentation, version control, and data governance.

⛳️ Requirements

• Bachelor's degree in a relevant field, or an equivalent combination of education and experience.

• Over 4 years of experience in business intelligence, analytics, reporting, or a related data role.

• Proficient in SQL, including joins, aggregations, CTEs, and troubleshooting data issues.

• Experience in creating reports or dashboards using a BI tool such as Power BI, Tableau, Looker, Sigma, or Omni.

• Strong grasp of data modeling concepts, including fact and dimension tables and star schemas.

• Proven ability to gather requirements from non-technical stakeholders and convert them into actionable reports.

• Demonstrated history of working independently, managing priorities, and taking ownership from request to delivery.

• Keen attention to data accuracy and sound judgment regarding data privacy and access.

• Excellent written and verbal communication skills.

• Preferred: Experience with Power BI, including DAX, row-level security, and workspace administration.

• Preferred: Familiarity with dbt or a comparable SQL-based transformation tool.

• Preferred: Experience with Snowflake or another cloud data warehouse.

• Preferred: Knowledge of Git or other version control systems.

• Preferred: Experience in establishing semantic layers or metric definitions for self-service analytics or AI tools.

• Preferred: Background in higher education, or familiarity with systems like Workday Student, Slate, or Blackboard.

• Preferred: Exposure to data governance practices such as metric certification, data quality, documentation, or lineage.

🏝️ Benefits

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

• Genuine ownership of BI initiatives across the University.

• Be a founding member of a new Data Engineering team.

• Opportunity to influence how the University leverages data and AI for decision-making.