Senior Data Engineer

Rival; Chicago, Northern (IL, KY); Hybrid; USD 150,000 - 187,000; Full time

Benefits offered by this job

Medical benefits

Dental coverage

Vision coverage

Life insurance

Disability insurance

401(k) match

Relocation assistance

Casual dress

Downtown office

Gym access

Wellness days

Parental leave

Referral program

Job summary

Arrive Logistics, a leading transportation and technology company in North America, seeks a Senior Data Engineer to own the data ecosystem powering analytics, BI, and data science. You’ll design data pipelines, maintain data warehouses, ensure quality, and lead cloud infrastructure with a focus on governance and automation.

You will collaborate with data scientists, analysts, and product managers to deliver actionable insights while optimizing performance and costs.

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

Responsibilities

• 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.

Skills

SQL

Python

dbt

Airflow

Azure

Power BI

Kafka

Snowflake

Databricks

BigQuery

Redshift

Education

Bachelor’s degree in Computer Science, Engineering, or related field

Tools

Snowflake

Databricks

BigQuery

Redshift

CI/CD

Job description

Who We Are

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.

$150,000 - $187,000 a year

The base salary range for this position is $150,000 - $187,000, plus bonus and benefits. The range displayed on each job posting reflects the pay range for the position across all locations. Within the range, individual pay is determined based on work location, job‑related skills, experience, relevant education or training.

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‑founder resource groups create communities within Arrive’s walls, including Women in Logistics, Emerging Professionals, Prisms, Black Logistics Group, Salute and Unidos.

Notice:

To ensure a safe and transparent interview process, we want to note that Arrive Logistics adheres to strict recruitment practices. Candidates undergo an interview process, and Arrive Logistics does not provide unsolicited job offers. If you have concerns about receiving a fraudulent offer, please contact [e-mail] for verification.