Senior BI Engineer: Data Strategy & Dashboards

Dahl Consulting; Cold Spring (MN); On-site; USD 76,000 - 100,000; Full time

Benefits offered by this job

profit sharing

a 401(K) match

training

career growth opportunities

professional development

financial services

on-site coaching and wellness coaching

Job summary

Dahl Consulting in Cold Spring, MN is seeking a Business Intelligence Engineer to build and govern enterprise data models and reporting solutions within a modern medallion architecture. You will own the transformation and semantic data layers, ensuring accuracy and accessibility for business users.

Collaborating with stakeholders across operations, sales, production, and logistics, you will design scalable analytics, deliver dashboards, and establish data governance, metrics, and documentation

Qualifications

• 3+ years in BI, analytics engineering, or data engineering.
• Advanced SQL skills and complex query optimization.
• Strong dimensional modeling knowledge (facts, dimensions, grain).
• Experience building dashboards in Tableau or Power BI.
• Able to communicate technical concepts to non-technical stakeholders.
• Excellent analytical and problem-solving abilities.
• Capable of gathering requirements and delivering projects.
• Bachelor's degree in CS, IS, Analytics or related field.
• Detail-oriented with strong judgment.

Responsibilities

• Configure, maintain, and optimize dbt for enterprise data transformation.
• Design and develop dbt models across data layers with testing & quality controls.
• Build and maintain curated data models for reporting and analytics.
• Develop certified data assets, data dictionaries, and governance standards.
• Establish best practices for data modeling, naming, testing, and source control.
• Partner with stakeholders to define metrics and translate needs into scalable data solutions.
• Centralize business logic and KPI calculations in the data layer.
• Create dashboards, reports, and performance metrics for business teams.
• Identify data quality issues and collaborate to improve accuracy.
• Contribute to the enhancement of the data warehouse and analytics platform.
• Collaborate with PM and IT to estimate effort and deliver prioritized initiatives.
• Provide guidance and training on certified data sources and reporting.

Skills

3+ years BI/Analytics Engineering/Data

Advanced SQL

Dimensional data modeling

Dashboards & reporting

Tableau

Power BI

Data governance & quality

Effective communication

Requirements gathering

Collaboration

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Equivalent experience may be considered

Tools

Tableau

Power BI

Python

JD Edwards ERP data

Job description

Dahl Consulting in Cold Spring, MN is seeking a Business Intelligence Engineer to build and govern enterprise data models and reporting solutions within a modern medallion architecture. You will own the transformation and semantic data layers, ensuring accuracy and accessibility for business users.

Collaborating with stakeholders across operations, sales, production, and logistics, you will design scalable analytics, deliver dashboards, and establish data governance, metrics, and documentation