Analytics Engineer, Associate

IEL Integrity Express Logistics; Cincinnati (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

Integrity Express Logistics (IEL) is seeking an Associate Analytics Engineer to support the development, validation, and enhancement of data models and analytics solutions. You will transform complex data into actionable insights, partnering with Finance, Operations, and Technology to drive BI and decision-support using dbt, Snowflake, Fivetran, Power BI, and Microsoft Fabric.

You will build and optimize data models, govern data quality, and deliver scalable analytics across load profitability,

Qualifications

• Bachelor's degree in a quantitative field or equivalent experience.
• 1-3 years of analytics engineering, data engineering, or related technical discipline.
• Strong SQL knowledge and data warehousing concepts.
• Familiarity with cloud data platforms and BI tools.
• Experience in Agile development and 3PL/logistics domain.

Responsibilities

• Develop, maintain, test, and enhance data models and transformations using dbt across staging, intermediate, and mart layers.
• Support data integration and pipeline performance, monitor synchronization, and troubleshoot data quality issues.
• Build Power BI semantic models, dashboards, and reports with secure data access.
• Validate transformed data against source systems and accounting records; document data lineage and troubleshooting steps.
• Collaborate with cross-functional teams, participate in code reviews and Agile processes.

Skills

SQL

Data modeling

ETL/ELT

Cloud platforms

BI tools

GitHub

Python

Agile

3PL domain

Data warehousing

Education

Bachelor's degree in a quantitative field

Tools

dbt Cloud

Snowflake

Fivetran

Power BI

Microsoft Fabric

PostgreSQL

NoSQL

GitHub

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

• 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, reconciliation, and documentation.
• Strong analytical and problem-solving skills, including the ability to investigate data discrepancies and identify potential solutions.
• Strong organizational skills with the ability to manage multiple priorities, meet deadlines, and maintain attention to detail.
• Ability to interpret business requirements and assist in translating them into technical data and analytics solutions.
• Effective written and verbal communication skills, including the ability to explain technical information to non-technical stakeholders.
• Ability to collaborate effectively with cross-functional teams in a dynamic environment.
• Ability to complete assigned tasks independently while recognizing when guidance or additional support is needed.
• Willingness and ability to learn new technologies, development practices, and analytics engineering methodologies.

Preferred Qualifications

• Experience with dbt or dbt Cloud, including layered data modeling, incremental models, Jinja, macros, automated testing, documentation, or scheduled jobs.
• Experience with Snowflake, including advanced SQL, window functions, QUALIFY, JSON or semi-structured data, query optimization, and warehouse management.
• Experience with Fivetran, including connector configuration, synchronization monitoring, troubleshooting, or historical re-synchronization.
• Experience with Power BI, including DAX, Power Query (M), star schemas, row-level security, incremental refresh, or troubleshooting refresh failures.
• Familiarity with Microsoft Fabric, including Data Factory pipelines, data orchestration, and capacity management.
• Experience with PostgreSQL, NoSQL, or other relational or application databases.
• Experience using GitHub or similar version control tools, including pull requests and code reviews.
• Experience with Python for data analysis, automation, or development of supporting tools.
• Familiarity with data structures, metadata management, data lineage, dependency management, and workload optimization.
• Exposure to machine learning concepts or applications.
• Familiarity with accounting or ERP data, including accounts payable, accounts receivable, general ledger, or Sage Intacct.
• Experience working in an Agile development environment.
• Experience in the third-party logistics (3PL), freight brokerage, transportation, or supply chain industry.
• Familiarity with transportation management systems (TMS) and logistics-related data.

Physical Requirements

• Ability to sit or stand at a desk for prolonged periods of time.
• Ability to lift up to 15 lbs.

We are committed to providing reasonable accommodations for qualified individuals with disabilities in our job application procedures.

If you need assistance or an accommodation due to a disability, you may contact us at [e-mail] or call 1-888-374-5138 ext. 4.

US Based Employees

At IEL, we are committed to providing equal employment opportunities for all persons, regardless of age, ancestry, color, religious creed (including religious dress or grooming practice), family and medical care leave status, disability (mental and physical) including HIV and AIDS, marital status, medical condition (including cancer and genetic characteristics), genetic information, military status, protected veteran status, status as a victim of domestic violence or stalking, familiar status, national origin, race, sex, pregnancy, childbirth, breastfeeding or related medical condition, gender identity or expression, sexual orientation and or any other category protected by law.

Founded in 2007, Integrity Express Logistics is a family-owned company with over 30 years of logistics experience. Our overall mission is to live up to our company name. We earn our customer’s trust through innovative technology and operational efficiency to customize logistics solutions. We focus on customer relations and hiring the best, most-driven and highly motivated employees. Together this formula has carried IEL to where we are today.

Integrity At IEL, integrity means always doing the right thing-even when it’s hard or when no one is watching. It’s about honesty, respect, open communication, and putting people first. We act with maturity, work hard, and stay reliable. We measure our actions by asking, ‘What if a customer saw you?’ Integrity means accountability and improvement. We continuously work to get things right, and when we cannot or do not, we use those situations as opportunities for improvement toward our greater purpose.

Customer First Customer First means putting our customers at the heart of every decision. We embrace the challenge of solving their most critical problems, act with urgency, and deliver consistent, exceptional service. We treat our customers’ freight as a privilege to move, going above and beyond to create true partnerships built on impact and trust.

Pursuit of Excellence Pursuit of Excellence means striving for the highest standards in all we do, with a positive attitude and relentless work ethic, even on tough days. It’s about raising the bar daily through exceptional operations, disciplined execution, and proactive problem-solving. We believe in actions over words, clear communication, dependability, and leading by example—showing up with purpose, mastering our craft, and earning trust through what we deliver.

Growth Culture Growth Culture at IEL means embracing a mindset of continuous improvement—day by day, year over year. We stay disciplined, work hard without seeking credit, and stay focused on shared goals. Growth takes many forms: personal development, character, leadership, financial, or operational. Whatever the measure, we never settle—we stay curious, motivated, and relentless in the pursuit of progress for ourselves, our teams, and our company.