Senior Data Engineer

Arrive Logistics; Chicago, Northern (IL, KY); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Medical benefits

401(k) matching

Employee Resource Groups

Casual dress code

Downtown Chicago office

Relocation assistance

Paid holidays

Parental leave

Life insurance

Job summary

Arrive Logistics in Chicago is seeking a Senior Data Engineer to own the data ecosystem powering analytics, BI, and data science. You will design and manage pipelines, data warehouses, and governance, partnering with data scientists, analysts, and product managers.

You will lead with technical vision, mentor engineers, and drive scalable cloud infrastructure using Snowflake, Azure, and Python, shaping the company’s data-driven product roadmap.

Qualifications

• 5+ years experience in data engineering.
• Expert proficiency in SQL and strong programming in Python.
• Proven experience building and orchestrating data pipelines with dbt and Airflow.
• Hands-on experience with major cloud environments, preferably Microsoft Azure.
• Solid understanding of BI tooling integrations with a cloud data warehouse, preferably PowerBI.
• Solid understanding of event-driven architecture and Kafka for real-time data flow.
• Experience with modern cloud data warehouses like Snowflake, Databricks, BigQuery, or Redshift.
• Familiarity with CI/CD, microservice architecture, domain driven design, data contracts.
• Strong data security/privacy practices and RBAC knowledge.
• Experience with machine learning concepts, frameworks, and infrastructure.
• Excellent written and oral communication and presentation skills.

Responsibilities

• Design, build, and optimize robust data pipelines ingesting data from diverse sources.
• Develop and maintain data warehousing solutions (Snowflake) with RBAC governance.
• Ensure data quality with validation, monitoring, and anomaly detection.
• Architect and manage cloud-based data infrastructure.
• Orchestrate batch ML pipelines with data scientists for product requirements.
• Collaborate with stakeholders to deliver actionable data solutions.
• Improve performance, efficiency, and cost of data systems.
• Weigh build-vs-buy tradeoffs with leadership for roadmap.
• Define architectures and best practices for data ingestion to the warehouse.
• Interact with vendors to adopt new technology and infrastructure.
• Develop AI agent tools and reusable skill libraries for developer productivity.
• Govern secure integrations between AI tools and the data warehouse with access controls.
• Participate in on-call rotations, define SLAs, and manage incidents.
• Create and improve technical documentation and standards.
• Mentor and lead the data engineering team and stakeholders.

Skills

SQL

Python

dbt

Airflow

Azure

Power BI

Kafka

Machine learning concepts

CI/CD

Microservice architecture

Domain-driven design

Data contracts

Data security/privacy

Education

Bachelor's degree in CS/Engineering or equivalent

Tools

Snowflake

Databricks

BigQuery

Redshift

Job description

Arrive Logistics is a leading transportation and technology company in North America with plans to grow significantly year over year. Our success is a testament to our remarkable team and what we’re building together. We’re committed to providing employees with a meaningful work experience and have established an award-winning culture that supports personal and career development in a fun, casual, and collaborative environment.

Who We Want

As a Senior Data Engineer at Arrive Logistics, you will build and own the data ecosystem that powers our analytics, business intelligence, and data science initiatives. You’ll work alongside Data, Engineering, and IT specialists to define and deploy new data infrastructure and tooling as well as own the pipelines that ingest and transform data integral to our analytics, BI, and data science initiatives. This position is an experienced professional who provides technical leadership to the team of data engineers and will directly influence how Arrive leverages its most valuable asset, data.

What You’ll Do

• Design, build, and optimize robust, scalable, and reliable data pipelines to ingest and process data from a wide variety of sources.
• Develop and maintain our data warehousing solutions (e.g. Snowflake), including maintenance of an advanced RBAC model to ensure data governance throughout all data tooling.
• Ensure data quality and integrity by implementing data validation frameworks, monitoring systems, and anomaly detection protocols.
• Architect and manage cloud-based data infrastructure.
• Orchestrate batch machine learning pipelines. Work closely with data scientists to orchestrate code based on data science and product requirements, getting alignment on optimizations when necessary.
• Collaborate with stakeholders, including data scientists, analysts, and product managers to understand data requirements and deliver actionable solutions.
• Improve performance, efficiency and optimize cost of existing data systems and processes.
• Work alongside Data and Engineering leadership to weigh tradeoffs in build vs buy decisions and tradeoffs in product roadmap vs technical initiatives.
• Work with internal software engineering teams to define architectures and best practices for ingesting data into the data warehouse and making aggregated data and metrics from the data warehouse available to our production applications.
• Interact with vendors to craft the adoption of new technology and infrastructure for the team.
• Designs, develops, and evaluates AI agents and reusable skill libraries to drive developer productivity and automate team workflows — including prompt engineering, tool integration, and performance evaluation using platforms such as Snowflake Cortex AI and LangGraph.
• Architects and governs secure integrations between enterprise AI tools (Claude, Cursor, Gemini, Slack, etc.) and the data warehouse, ensuring data access controls, auditability, and compliance standards are maintained across the AI toolchain.
• Take part in an on-call rotation. Work with Engineering leadership to define SLAs and alerting policies for our systems.
• Lead and participate in incident management, ensuring clear and timely communication with stakeholders.
• Write new and enhance existing technical and functional documentation on Data Engineering-owned systems and standards. Proactively address gaps in existing team standards, SLAs, operating principles, and documentation and work with leadership to scope and implement improvements in these areas.
• Be a leader, mentor, and subject matter expert for the team, stakeholders, and peers. Foster a collaborative environment that drives solutions forward at a larger scope.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, or a related field or equivalent professional experience.
• 5+ years experience in data engineering.
• Expert proficiency in SQL and strong programming skills in Python.
• Proven experience building and orchestrating data pipelines using dbt and Airflow
• Hands-on experience developing data solutions in a major cloud environment, with a strong preference for Microsoft Azure.
• Solid understanding of BI-tooling integrations with a cloud data warehouse, with a strong preference for PowerBI
• Solid understanding of event-driven architecture and the use of messaging systems like Kafka to enable real-time data flow.
• Experience with a modern cloud data warehouse like Snowflake, Databricks, BigQuery, or Redshift.
• Familiarity with CI/CD, microservice architecture, domain driven design, data contracts
• Solid understanding with best practices around data security/privacy, role-based access control
• Experience with machine learning concepts, frameworks, and infrastructure
• Excellent written and oral communication and presentation skills

The Perks of Working With Us

• Take advantage of excellent benefits, including medical, dental, vision, life, and disability coverage.
• Invest in your future with our matching 401(k) program.
• Build relationships and take part in learning opportunities through our Employee Resource Groups.
• Enjoy office wide engagement activities, team events, happy hours and more!
• Leave the suit and tie at home; our dress code is casual.
• Work in the heart of downtown Chicago, IL!
• There are CTA and L train stops walking distance from the office and you can store your bike safely inside of the building.
• Sweat it out at the LifeStart gym in our office building that includes brand new Peloton bikes, top-of-the-line equipment and personal training options.
• Maximize your wellness with free counseling sessions through our Employee Assistance Program
• Get paid to work with your friends through our Referral Program!
• Take time to manage your physical and mental health – we offer company paid holidays, paid vacation time and wellness days.
• Receive 100% paid parental leave when you become a new parent.
• Get relocation assistance! If you are not local to the area, we offer relocation packages.

Your Arrive Experience

When we say “award-winning culture,” we mean it. We’ve been recognized as a top workplace by Inc. Fast Company, Fortune, and earned Top Workplaces and Great Place to Work, to name a few. We intend on topping many more of those lists in the years to come, but we’re not in it for the trophies. We’re committed to culture because it keeps us connected to each other and invested in our shared success while having a blast along the way. Our employee-founded resource groups create communities within Arrive’s walls, including Women in Logistics, Emerging Professionals, Prisms, Black Logistics Group, Salute and Unidos.