Business Intelligence Engineer

Intertech, Inc

Minnesota

Hybrid

USD 90,000 - 110,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Intertech, Inc. in Minnesota is seeking a Business Intelligence Engineer for a hybrid contract-to-hire role, local to Cold Spring, MN, able to come into the office. You will own the dbt environment, build gold-layer data models, and deliver KPIs and dashboards to business users.

You will collaborate with cross-functional BI teammates, ensure data quality, establish data standards, and translate complex data questions into actionable insights using SQL, dbt, Tableau, and Power BI.

Qualifications

  • Bachelor’s degree in CS, IS, Analytics or related field preferred
  • 5+ years in BI, analytics engineering or data engineering roles with SQL/dbt/Tableau/BI tooling
  • Experience with JD Edwards data sources and medallion architecture is a plus
  • Ability to explain technical data concepts to non-technical audiences
  • Strong collaboration and communication skills

Responsibilities

  • Set up, configure, and maintain the dbt environment used to transform data
  • Build and maintain dbt models from bronze to gold layers
  • Translate business questions into data requirements and deliver answers
  • Design and build the gold layer with curated business-facing data models
  • Establish naming, testing, documentation, and version control standards
  • Publish and certify data sources with descriptions, owners, and refresh schedules
  • Own the certification standard and lifecycle for data sources
  • Centralize calculations and metrics in the data layer
  • Build KPIs, dashboards, and recurring reports
  • Identify data quality gaps and work with source system owners to resolve them
  • Contribute to data warehouse development alongside the BI team
  • Embed within cross-functional BI team and participate in scoping with project manager
  • Provide guidance and occasional training on certified data sources

Skills

Advanced SQL
dbt
Dimensional modeling
Tableau
Power BI
Git / source control
Data visualization
Communication with non-technical users

Education

Bachelor's degree

Tools

dbt
Tableau
Power BI
Git

Job description

Business Intelligence Engineer
  • Hybrid contract to hire opportunity
  • Candidate must be local to Minnesota and willing to go into the office in Cold Spring, MN
JOB SUMMARY:

The Business Intelligence Engineer is responsible for making data usable by the business. Client is building a medallion data architecture — a bronze layer of raw source data, a silver layer in our SQL data warehouse, and a gold layer of curated, business‑facing data. This position is embedded in our cross‑functional BI team, where a project manager handles intake and prioritization, and is responsible for the technical design and delivery of the gold layer, the certified data sources the company relies on, and the KPIs, dashboards, and reporting used to make business decisions. This position also owns our dbt environment and the transformation logic that moves data from bronze, to silver, to gold. Key skills for this position include SQL, dbt, dimensional data modeling, Tableau, and the ability to communicate effectively with non‑technical business users.

Our client has spent the past two years building the foundation for this role — a working data warehouse sourced from JD Edwards, with a dedicated developer maintaining the integration. The gold layer is greenfield. This is the first position dedicated to making that data usable across the company, so you would be establishing the patterns, the standards, and the certification practice rather than inheriting someone else’s. You would be working with people who know the business well and want better access to their data.

WHAT YOU’LL BE DOING:
  • Set up, configure, and maintain the dbt environment used to transform data
  • Build and maintain the dbt models that move data from the bronze layer, to silver, to gold, including data quality tests and monitoring
  • Work with business users, alongside the BI team, to translate business questions into data requirements and deliver answers at the level each requester needs
  • Design and build the gold layer: curated, business‑facing data models, including conformed and pre‑joined data sets spanning sales, production, shipping, and other domains
  • Establish standards for naming, testing, documentation, and version control of transformation code
  • Publish, certify, and manage the company’s certified data sources, including their names, descriptions, owners, refresh schedules, and the data dictionary and metric definitions behind them
  • Own the certification standard: what qualifies as certified, how changes are handled, and when a source is retired
  • Centralize business calculations and metric definitions in the data layer, not in individual reports
  • Build KPIs, dashboards, and recurring reporting for teams that cannot build their own
  • Identify data quality and data capture gaps and help resolve them with source system owners
  • Contribute to the ongoing development of the underlying data warehouse alongside the BI developer
  • Work as an embedded member of the cross‑functional BI team, receiving prioritized work through IT and the team’s project manager, while owning the technical approach and design decisions
  • Partner with the project manager on scoping and effort estimates for incoming requests
  • Provide guidance to business users on the certified data sources, including occasional informal training
QUALIFICATIONS:
  • Bachelor’s degree in Computer Science, Information Systems, Business Analytics, or a related field preferred; an associate degree or demonstrated experience may be considered in place of a bachelor’s degree
  • 5+ years of combined experience in business intelligence, analytics engineering, or data engineering roles. Depth in the following matters more than years served: Advanced SQL, including writing, optimizing, and troubleshooting complex queries dbt, including standing up a project and owning model development, testing, and structure (2+ years hands‑on), Dimensional data modeling (facts, dimensions, and grain), Git / source control, and hands‑on front end visualization and dashboard development in a BI platform such as Tableau or Power BI
  • Experience with several of the following is preferred: Tableau specifically, including publishing and managing certified data sources, data sourced from a transactional ERP system (JD Edwards a plus), layered or medallion data architectures, modern data transformation and testing workflows, python or other scripting for data preparation
  • Ability to explain technical data concepts to a non‑technical audience
  • Strong collaboration, relationship management, and communication skills
  • Works with business users to understand the requirements behind a request, and asks questions when they are unclear
  • Good judgment, logical thinker and detail oriented
  • Ability to drive projects to completion and flag blockers early
  • Manufacturing, production, or distribution industry experience preferred

Target salary range is 90-110k, comparable contract rates for W2/1099/C2C. These are negotiable.

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 Specialist
Business Intelligence Specialist

Dahl Consulting • Cold Spring (MN)

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

Coldspring • Minnesota

Hybrid
USD 90,000 - 140,000
Health insurance
Dental insurance
Vision insurance
+3
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

Cold Spring Granite • Cold Spring (MN)

On-site
USD 100,000 - 150,000
Health
Dental
Optical
+11
BI Data Analyst
BI Data Analyst

Eight Eleven Group • Birmingham (AL)

On-site
USD 70,000 - 75,000
Gold-Layer BI Engineer: SQL/dbt & Dashboards
Gold-Layer BI Engineer: SQL/dbt & Dashboards

Coldspring • Minnesota

Hybrid
USD 90,000 - 140,000
Health insurance
Dental insurance
Vision insurance
+3
Business Intelligence Developer
Business Intelligence Developer

Standard Motor Products • Lewisville (TX)

On-site
USD 80,000 - 100,000
Business Intelligence (BI) Engineer
Business Intelligence (BI) Engineer

SiloSmashers, Inc. • Alexandria (VA)

On-site
USD 115,000 - 130,000
Senior Full-Stack BI Architect / Fabric Data Engineer
Senior Full-Stack BI Architect / Fabric Data Engineer

Proactive Technology Management • Ferndale (MI)

Remote
USD 140,000 - 180,000
Health insurance
401(k) retirement plan with company
Flexible remote work