Analytics Engineer, Associate

ielfreight

Cincinnati (OH)

On-site

USD 75,000 - 110,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Integrity is seeking an Associate Analytics Engineer to support the development, testing, and improvement of data models and analytics solutions that drive business intelligence and operational decisions. You will work with data architects, engineers, analysts, and business partners to translate complex data into reliable insights, leveraging Fivetran, Snowflake, dbt Cloud, Power BI, and Microsoft Fabric.

This role reports to the Data Analytics Manager.

Qualifications

  • Bachelor's degree in a quantitative field or equivalent experience.
  • 1-3 years in analytics engineering or BI-related roles.
  • Strong SQL + data modeling and warehousing concepts.
  • Experience with cloud BI tools and data integration platforms.

Responsibilities

  • Develop, test, and optimize data models and transformations.
  • Build dbt models across layers with quality testing.
  • Write and optimize SQL in Snowflake for data processing.
  • Assist data integration via Fivetran and monitor pipelines.
  • Create Power BI dashboards and semantic models.
  • Validate data against source systems and docs.

Skills

SQL
Data Modeling
Data Warehousing
ETL/ELT
Analytics Engineering
Cloud data platforms

Education

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

Tools

Fivetran
Snowflake
dbt Cloud
Power BI
Microsoft Fabric

Job description

As the Associate Analytics Engineer at Integrity, you are responsible for supporting the development, maintenance, testing, and improvement of data models and analytics solutions that drive business intelligence and operational decision-making. Working with data architects, engineers, analysts, and business partners, this role transforms complex data into reliable, actionable insights.

The position supports data integration, transformation, modeling, validation, and reporting using tools such as Fivetran, Snowflake, dbt Cloud, Power BI, and Microsoft Fabric. It partners with Finance, Accounting, Sales, Operations, and Technology to develop scalable analytics solutions, resolve data issues, and improve processes.

This position reports to the Data Analytics Manager.

Core Responsibilities
Data Modeling & Transformation
  • Develop, maintain, test, and enhance data models and transformation processes to support business intelligence, analytics, and reporting needs.
  • Build and maintain dbt models across staging, intermediate, and mart layers, incorporating appropriate testing, documentation, and data quality standards.
  • Write, optimize, and maintain SQL queries and data transformations within Snowflake to support accurate, reliable, and efficient data processing.
  • Assist in optimizing Snowflake queries, incremental models, and warehouse utilization to improve performance and manage costs.
Data Integration & Pipeline Support
  • Support data integration processes using Fivetran, including monitoring synchronization, configuring tables and columns, troubleshooting missing data, and assisting with historical re-synchronization.
  • Monitor data transformation processes and pipeline performance, troubleshoot failures, and assist in resolving synchronization, performance, and data quality issues.
  • Support data refresh processes and orchestration using Power BI, Microsoft Fabric, and other applicable technologies.
Business Intelligence & Analytics
  • Assist in developing and maintaining Power BI semantic models, dashboards, and reports using dimensional modeling, DAX measures, and appropriate data security practices.
  • Support the development and maintenance of trusted business metrics related to load profitability, accounts receivable, accounts payable, commissions, carrier payments, and other operational and financial activities.
  • Collaborate with business stakeholders to understand reporting and analytics requirements and translate those needs into reliable data models, standardized metrics, and analytics solutions.
Data Quality & Validation
  • Validate transformed data against source systems and accounting records to identify discrepancies, investigate root causes, and assist with implementing appropriate corrections.
  • Perform data quality testing and reconciliation to support the accuracy, completeness, and consistency of business information.
  • Create and maintain technical documentation for data models, transformation logic, metric definitions, data lineage, and troubleshooting procedures.
Collaboration & Development Practices
  • Collaborate with data architects, engineers, analysts, and cross-functional business partners to support consistent, scalable, and maintainable analytics solutions.
  • Participate in code reviews, version control, and collaborative development processes using GitHub and established development standards.
  • Participate in Agile development activities, project planning, testing, and implementation of new analytics solutions.
Process Improvement & Professional Development
  • Identify opportunities to automate manual processes, improve data reliability, enhance reporting consistency, and increase overall data accessibility.
  • Recommend improvements to existing data models, transformation processes, and analytics workflows to support operational efficiency.
  • Develop technical expertise across IEL's analytics engineering platforms and progressively assume responsibility for more complex assignments.
  • Perform other duties as assigned.
Knowledge, Skills, & Experience
Required Qualifications
  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Informatics, or a related quantitative field, or an equivalent combination of education and relevant experience.
  • 1-3 years of relevant experience in analytics engineering, data engineering, data analytics, business intelligence, or a related technical discipline. Relevant internships, academic projects, or equivalent practical experience will be considered.
  • Strong foundational SQL knowledge, including experience querying relational databases, developing queries, and working with complex datasets.
  • Understanding of data transformation, data modeling, and data warehousing concepts, including ETL/ELT processes.
  • Familiarity with cloud-based data platforms and business intelligence tools.
  • Basic understanding of relational database structures, dimensional modeling, and data validation principles.
  • Understanding of data quality practices, including testing, re
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Analytics Engineer, Associate
Analytics Engineer, Associate

Integrity Express Logistics, LLC • Cincinnati (OH)

On-site
USD 85,000 - 110,000
Associate Analytics Engineer - Data Modeling & BI
Associate Analytics Engineer - Data Modeling & BI

ielfreight • Cincinnati (OH)

On-site
USD 75,000 - 110,000
Junior Analytics Engineer: Data Modeling & BI
Junior Analytics Engineer: Data Modeling & BI

Integrity Express Logistics, LLC • Cincinnati (OH)

On-site
USD 85,000 - 110,000
Analytics Engineer
Analytics Engineer

The Hagen Ricci Group • New York (NY)

On-site
USD 80,000 - 120,000
Senior Analytics Engineer
Senior Analytics Engineer

Agoro • United States

Remote
USD 120,000 - 190,000
Data and Analytics Engineer
Data and Analytics Engineer

Arcadian Infracom • St. Louis (MO)

On-site
USD 80,000 - 110,000
Analytics Engineer
Analytics Engineer

Aptino, Inc. • Houston (TX)

Hybrid
USD 90,000 - 120,000
Senior BI and Analytics Engineer
Senior BI and Analytics Engineer

Prosum • Los Angeles (CA)

On-site
USD 100,000 - 130,000
Business Intelligence Engineer
Business Intelligence Engineer

Azenta • Plainfield (IN)

On-site
USD 85,000 - 110,000
Senior Data Engineer: Tableau & ETL Analytics
Senior Data Engineer: Tableau & ETL Analytics

Compunnel Inc. • Texas

Hybrid
USD 90,000 - 120,000