Business Intelligence Specialist

Dahl Consulting

Cold Spring (MN)

On-site

USD 88,000 - 106,000

Full time

14 days+

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Profit sharing
401(K) match
Training and career growth
Professional development

Job summary

Dahl Consulting is seeking a Business Intelligence Specialist in Cold Spring, MN to transform enterprise data into actionable insights. You’ll lead the development of a modern analytics ecosystem, establish data modeling standards, own the transformation layer, and create KPIs and reporting solutions for operations, sales, and logistics.

You will collaborate with stakeholders to deliver scalable data solutions, govern data assets, and ensure data quality across dashboards and enterprise

Qualifications

  • 3+ years in BI, analytics engineering, data engineering, or related roles.
  • Advanced SQL design, optimization, and troubleshooting skills.
  • Strong knowledge of dimensional modeling and data governance.
  • Experience building dashboards and reports with Tableau or Power BI.
  • Proven ability to translate business needs into scalable data solutions.
  • Bachelor's degree or equivalent experience in a related field.

Responsibilities

  • Configure, maintain, and optimize the dbt environment for data transformation.
  • Design dbt models across bronze, silver, and gold layers with quality controls.
  • Build curated data models to support reporting and analytics.
  • Develop certified data assets including dictionaries and metric definitions.
  • Establish data modeling best practices and source control standards.
  • Partner with stakeholders to translate requirements into scalable data solutions.
  • Centralize KPI calculations within the data layer for consistent reporting.
  • Create dashboards, reports, and performance metrics for business teams.
  • Identify data quality issues and coordinate improvements with owners.
  • Contribute to enterprise data warehouse and analytics platform enhancements.
  • Collaborate with PM and IT to estimate effort and deliver initiatives.

Skills

Advanced SQL
Dimensional data modeling
Data transformation
Communication with non-technical Stake
Analytical problem solving
Project delivery
Python scripting

Education

Bachelor's degree in CS/IS/BA or related field

Tools

Tableau
Power BI
JD Edwards (ERP exposure)

Job description

Title: Business Intelligence Specialist

Location: Cold Spring, MN

Job Type: Permanent/Direct-Hire

Compensation: $87,872 - $106,446 annually

Industry: Construction

About the Role

Our client, a leading manufacturer and supplier in the natural stone industry, is seeking a Business Intelligence Specialist 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.

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
  • Required 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 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
  • Our client's benefits include profit sharing, a 401(K) match, training and career growth opportunities, professional development, financial services, on-site coaching and wellness counseling, and 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!

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Intelligence Engineer
Business Intelligence Engineer

Intertech • Coldspring (TX)

Hybrid
USD 85,000 - 95,000
Business Intelligence Engineer
Business Intelligence Engineer

Intertech, Inc • Minnesota

Hybrid
USD 90,000 - 110,000
Business Intelligence Engineer
Business Intelligence Engineer

Coldspring • Cold Spring (MN)

On-site
USD 110,000 - 140,000
Health
Dental
Optical
+11
Business Intelligence Engineer
Business Intelligence Engineer

Coldspring • Minnesota

Hybrid
USD 90,000 - 140,000
Health insurance
Dental insurance
Vision insurance
+3
BI Data Analyst
BI Data Analyst

Eight Eleven Group • Birmingham (AL)

On-site
USD 70,000 - 75,000
Business Intelligence Engineer
Business Intelligence Engineer

Cold Spring Granite • Cold Spring (MN)

On-site
USD 100,000 - 150,000
Health
Dental
Optical
+11
BI Specialist: Enterprise Analytics & Data Strategy
BI Specialist: Enterprise Analytics & Data Strategy

Dahl Consulting • Cold Spring (MN)

On-site
USD 88,000 - 106,000
Profit sharing
401(K) match
Training and career growth
+1
Business Intelligence (BI) Manager
Business Intelligence (BI) Manager

Integer Holdings • Plano (TX)

On-site
USD 100,000 - 130,000
Comprehensive benefits package including medical, dental, and vision
401(k) plan with company matching
Paid time off and holidays
Senior Full-Stack BI Architect / Fabric Data Engineer
Senior Full-Stack BI Architect / Fabric Data Engineer

Proactive Technology Management • Ferndale (WA)

Remote
USD 140,000 - 190,000
Competitive compensation
Shape data strategy and lead BI/ data‑
Professional development and training
+4
Senior Business Intelligence Engineer
Senior Business Intelligence Engineer

Pacific West Site Services, Inc. • Sacramento (CA)

On-site
USD 120,000 - 180,000