Junior Analytics Engineer: Data Modeling & BI

Integrity Express Logistics, LLC; Cincinnati (OH); On-site; USD 85,000 - 110,000; Full time

Job summary

Integrity Express Logistics, LLC seeks an Associate Analytics Engineer to support the development, testing, and improvement of data models and analytics solutions that drive BI and operational decisions. You will work with data architects, engineers, analysts, and business partners, applying Fivetran, Snowflake, dbt Cloud, Power BI, and Microsoft Fabric to build scalable analytics.

Reports to the Data Analytics Manager.

Qualifications

• Bachelor’s degree in a quantitative field or equivalent experience.
• 1–3 years in analytics/data engineering or BI roles.
• Strong SQL and data modeling fundamentals.
• Understanding ETL/ELT, data warehousing, and data validation.
• Experience with cloud BI tools and collaboration across teams.

Responsibilities

• Develop, maintain, test, and enhance data models and transformations.
• Build dbt models across staging, intermediate, and core layers with testing.
• Write and optimize SQL in Snowflake for reliable data processing.
• Assist data integration using Fivetran and monitor pipelines.
• Develop Power BI reports and semantic models with security best practices.

Skills

SQL knowledge

Data modeling

Data validation

Analytical thinking

Cross-functional collaboration

Effective communication

Agile development

Cloud platforms familiarity

Education

Bachelor’s degree in CS/IS/Analytics

Tools

dbt Cloud

Snowflake

Fivetran

Power BI

Microsoft Fabric

GitHub

Python

PostgreSQL/NoSQL

Job description

Integrity Express Logistics, LLC seeks an Associate Analytics Engineer to support the development, testing, and improvement of data models and analytics solutions that drive BI and operational decisions. You will work with data architects, engineers, analysts, and business partners, applying Fivetran, Snowflake, dbt Cloud, Power BI, and Microsoft Fabric to build scalable analytics.

Reports to the Data Analytics Manager.