Junior Analytics Engineer: Data Modeling & BI

ielfreight; Cincinnati (OH); On-site; USD 70,000 - 100,000; Full time

Job summary

Integrity is seeking an Associate Analytics Engineer to support data model development, testing, and analytics solutions that empower BI and operational decisions. You will collaborate with data architects, engineers, analysts, and business partners to translate complex data into reliable insights.

The role covers data integration, transformation, modeling, validation, and reporting using Fivetran, Snowflake, dbt Cloud, Power BI, and Microsoft Fabric.

Qualifications

• Bachelor's degree or equivalent in a quantitative field.
• 1-3 years of analytics engineering or related experience.
• Strong SQL skills with complex queries across datasets.
• Understanding of data transformation, modeling, and warehousing concepts.
• Familiarity with cloud-based data platforms and BI tools.
• Basic knowledge of relational structures, dimensional modeling, and data validation.
• Understanding of data quality practices and testing.

Responsibilities

• Develop, maintain, test, and enhance data models and transformations for BI and analytics.
• Build dbt models across staging, intermediate, and mart layers with testing and data quality.
• Write and optimize SQL in Snowflake for reliable data processing.
• Assist in optimizing Snowflake queries and warehouse utilization.
• Support data integration with Fivetran and monitor synchronization.
• Develop and maintain Power BI semantic models, dashboards, and reports.
• Collaborate with stakeholders to translate requirements into reliable data models and metrics.
• Validate transformed data against sources and documentation data lineage.
• Participate in code reviews, GitHub workflows, and Agile development practices.

Skills

SQL

Data modeling

ETL/ELT

Cloud platforms

dbt Cloud

Snowflake

Power BI

Fivetran

GitHub

Dashboards

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Informatics

Tools

dbt Cloud

Snowflake

Power BI

Microsoft Fabric

Fivetran

GitHub

Job description

Integrity is seeking an Associate Analytics Engineer to support data model development, testing, and analytics solutions that empower BI and operational decisions. You will collaborate with data architects, engineers, analysts, and business partners to translate complex data into reliable insights.

The role covers data integration, transformation, modeling, validation, and reporting using Fivetran, Snowflake, dbt Cloud, Power BI, and Microsoft Fabric.