Analytics Engineer: Build Data Models & BI Solutions

Intermedia; Northern (KY); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Intermedia is seeking an Analytics Engineer to partner with IT Business Systems & Security and business stakeholders. You will design data models, build Snowflake views, DBT marts, and Power BI datasets, and optimize semantic models for impactful dashboards.

You will work across Snowflake and SQL Server, deliver high quality data products, and contribute to governance and testing standards in an agile environment. A quantitative degree and 3–5 years in related roles are required.

Qualifications

• Bachelor's degree in a quantitative field is required.
• 3–5 years in analytics engineering, data analysis, BI engineering, or related roles.
• Strong SQL skills with complex queries, window functions, and performance tuning.

Responsibilities

• Collaborate with business stakeholders to translate questions into data solutions, delivering from exploration to production-ready data products.
• Design and build data models and implement them as Snowflake views, DBT marts, and Power BI datasets.
• Develop and optimize Power BI semantic models and surface effective reports.
• Write SQL across Snowflake and SQL Server for downstream analytics.
• Consolidate data solutions to reduce technical debt and improve consistency.
• Define metric definitions and data product specifications.
• Design and implement data quality tests and contribute to governance.
• Collaborate with Data Engineers through code reviews and PR workflows.

Skills

SQL

Data modeling

Power BI

Data visualization

Snowflake

Git workflows

Stakeholder communication

Agile

Education

Bachelor's degree in CS/Analytics/Stats/Math/Economics

Tools

DBT

Python

MicroStrategy

Job description

Intermedia is seeking an Analytics Engineer to partner with IT Business Systems & Security and business stakeholders. You will design data models, build Snowflake views, DBT marts, and Power BI datasets, and optimize semantic models for impactful dashboards.

You will work across Snowflake and SQL Server, deliver high quality data products, and contribute to governance and testing standards in an agile environment. A quantitative degree and 3–5 years in related roles are required.