Business Intelligence Engineer

Dahl Consulting; Cold Spring (MN); Presencial; USD 76.000 - 100.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

profit sharing

a 401(K) match

training

career growth opportunities

professional development

financial services

on-site coaching and wellness coaching

Descripción de la vacante

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

Formación

• 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.

Responsabilidades

• 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.

Conocimientos

3+ years BI/Analytics Engineering/Data

Advanced SQL

Dimensional data modeling

Dashboards & reporting

Tableau

Power BI

Data governance & quality

Effective communication

Requirements gathering

Collaboration

Educación

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

Equivalent experience may be considered

Herramientas

Tableau

Power BI

Python

JD Edwards ERP data

Descripción del empleo

Title: Business Intelligence Engineer

Location: Cold Spring, MN

Job Type: Permanent/Direct-Hire

Compensation: $76,000 - $100,000 annually

Industry: Construction

About the Role

Our client, a leading manufacturer and supplier in the natural stone industry, is seeking a Business Intelligence Engineer to help transform enterprise data into trusted, actionable insights. This organization has invested heavily in building a modern data foundation and is now seeking a data professional to lead the development of a business-facing analytics ecosystem. This is a unique opportunity to shape the organization's data strategy from the ground up. You will establish data modeling standards, own the transformation layer, develop certified data assets, and create the KPIs and reporting solutions that guide business decisions across operations, sales, production, logistics, and other key functions. Working within a collaborative Business Intelligence team, you will partner with technical and business stakeholders to deliver scalable analytics solutions that improve data accessibility, governance, and decision-making throughout the organization.

Job Description

As the Business Intelligence Engineer, you will be responsible for designing, building, and maintaining enterprise data models and reporting solutions within a modern medallion architecture. You will serve as the primary owner of the organization's transformation and semantic data layers, ensuring data is accurate, governed, and easily consumable by business users.

Responsibilities

• Configure, maintain, and optimize the dbt environment used for enterprise data transformation.
• Design and develop dbt models that transform data across bronze, silver, and gold layers, including testing, monitoring, and quality controls.
• Build and maintain curated, business-facing data models that support reporting and analytics initiatives.
• Develop certified data assets, including data dictionaries, metric definitions, refresh schedules, and governance standards.
• Establish and maintain best practices for data modeling, naming conventions, testing, documentation, and source control.
• Partner with business stakeholders to gather requirements, define metrics, and translate business needs into scalable data solutions.
• Centralize business logic and KPI calculations within the data layer to ensure consistency across reporting platforms.
• Create dashboards, reports, and performance metrics for business teams across the organization.
• Identify data quality issues and collaborate with system owners to improve data accuracy and completeness.
• Contribute to the ongoing enhancement of the enterprise data warehouse and analytics platform.
• Collaborate with project management and IT teams to estimate effort, define technical approaches, and deliver prioritized initiatives.
• Provide guidance and occasional training to business users on certified data sources and reporting capabilities.

Qualifications

• 3+ years of experience in Business Intelligence, Analytics Engineering, Data Engineering, or a related discipline.
• Advanced SQL skills, including development, optimization, and troubleshooting of complex queries.
• Strong understanding of dimensional data modeling principles, including facts, dimensions, and grain.
• Experience developing dashboards, reports, and visualizations using platforms such as Tableau or Power BI.
• Ability to effectively communicate technical concepts to non-technical stakeholders.
• Strong analytical, problem-solving, and organizational skills.
• Demonstrated ability to gather business requirements, manage priorities, and deliver projects through completion.
• Excellent collaboration and relationship-building skills.
• Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field; equivalent experience may be considered in lieu of a degree.
• Detail-oriented mindset with strong judgment and critical thinking abilities.

Preferred Experience

• Experience with Tableau, including certified data source management and governance.
• Experience working with ERP-sourced data; exposure to JD Edwards is a plus.
• Experience supporting medallion or layered data architectures.
• Knowledge of modern data transformation, testing, and data quality frameworks.
• Python or other scripting experience for data preparation and automation.
• Experience within manufacturing, production, industrial, supply chain, or distribution environments.
• Experience establishing data governance, certification standards, and enterprise reporting best practices.

Benefits

• profit sharing
• a 401(K) match
• training
• career growth opportunities
• professional development
• financial services
• on-site coaching and wellness counseling
• much more

Equal Opportunity Statement

As an equal opportunity employer, Dahl Consulting welcomes candidates of all backgrounds and experiences to apply. If this position sounds like the right opportunity for you, we encourage you to take the next step and connect with us. We look forward to meeting you!