Gold-Layer BI Engineer: SQL/dbt & Dashboards

Coldspring; Northern (KY); Hybrid; USD 90,000 - 140,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401K with company match

Profit sharing

PTO

Job summary

Coldspring is hiring a Business Intelligence Engineer to make data usable across the organization. You will own the dbt environment, develop the gold layer, certify data sources, and deliver KPIs and dashboards for business decision-making.

You will collaborate with a cross-functional BI team, translating business questions into data requirements and shaping the data warehouse with robust governance and standards.

Qualifications

• Bachelor’s degree preferred in CS/IS/Analytics or related field.
• 5+ years in BI/analytics/data engineering roles with strong SQL and dbt experience.
• Experience with Tableau or Power BI for dashboard development.
• Ability to translate business questions into data requirements and deliver insights.

Responsibilities

• Set up, configure, and maintain the dbt environment for transforming data.
• Build and maintain dbt models across bronze/ silver/ gold layers with quality tests.
• Collaborate with business users to translate requirements into data solutions and answers.
• Design and build gold-layer data models spanning multiple domains (sales, production, shipping).
• Establish naming, testing, documentation, and version-control standards for transformation code.
• Publish and certify data sources with descriptions, owners, refresh schedules, and data dictionaries.
• Own the certification standard and lifecycle for data sources.
• Centralize business calculations in the data layer and publish KPI dashboards and reports.
• Identify data gaps and work with source owners to resolve them.

Skills

Advanced SQL

dbt

Dimensional modeling

Git / version control

BI visualization (Tableau/Power BI)

Strong communication

Collaboration

Data quality

Education

Bachelor’s degree in CS/IS/Analytics or related field

Associates degree or equivalent experience considered

Tools

Tableau

Power BI

JD Edwards

dbt

Git

Job description

Coldspring is hiring a Business Intelligence Engineer to make data usable across the organization. You will own the dbt environment, develop the gold layer, certify data sources, and deliver KPIs and dashboards for business decision-making.

You will collaborate with a cross-functional BI team, translating business questions into data requirements and shaping the data warehouse with robust governance and standards.