Analytics Engineer

Loop; Chicago (IL); On-site; USD 80,000 - 100,000; Full time

Job summary

Loop is looking for an Analytics Engineer to play a pivotal role in enhancing the data organization. You will design, build, and maintain core data models and ETL processes, ensuring reliable data accuracy across teams. Collaboration with various business units is crucial for automating data requests and creating data-driven solutions.

Applicants should have a minimum of 2 years of experience in building analytical products, along with strong SQL and Python skills. Familiarity with data stack tools like Snowflake and dbt will be advantageous.

Qualifications

• 2+ years experience building analytical products.
• Strong proficiency in SQL and Python for data transformations.
• Hands-on experience with modern data stack tools.

Responsibilities

• Design, build, and own core infrastructure and data models.
• Establish and govern key business metrics for consistency.
• Ensure data accuracy and reliability with strong SLAs.
• Convert ad-hoc data requests into scalable pipelines.
• Manage and optimize data infrastructure for performance.

Skills

SQL

Python

Data visualization tools

Data dashboarding

Data infrastructure management

Business communication

Tools

Snowflake

dbt

Dagster

Airflow

Looker

Tableau

Superset

Mode

Job description

Requirements

• 2+ years experience building analytical products (system, dashboard, models)
• Strong proficiency in SQL and Python for data transformations and automation
• Hands‑on experience with modern data stack tools (e.g., Snowflake, dbt, Dagster, Airflow, Looker)
• Excellent business communication skills to translate data insights into actionable business strategies
• Experience with data dashboarding and visualization tools (e.g., Tableau, Looker, Superset, Mode)
• Ability to manage, optimize, and scale data infrastructure
• (Desirable) Global supply chain experience in transportation and logistics
• (Desirable) Previous experience setting up a data stack in a startup from scratch
• (Desirable) Interest or experience in working with cutting‑edge open‑source data tool
• (Desirable) Proven ability to convert ad‑hoc data requests into scalable, automated pipelines
• (Desirable) Experience working in the logistics domain

What the job involves

• As an Analytics Engineer at Loop, you will play a pivotal role in maturing the data organization. You’ll work cross‑functionally to design, build, and own the core infrastructure and data models. These systems will enable both internal and client facing analytics, accelerating data‑driven decision‑making throughout the company and our clients.
• Own Core Data Models and ETL Pipelines: Design, build, and maintain Loop’s core data models and ETL processes.
• Define Metrics and Governance: Establish and govern key business metrics for consistency across teams.
• Maintain Data Quality and Uptime: Ensure data accuracy and reliability with strong SLAs.
• Automate Data Requests: Convert ad‑hoc data requests into scalable re‑usable pipelines.
• Optimize Data Infrastructure: Manage and optimize data infrastructure for performance, cost, and compliance.
• Develop Data Products: Create data‑driven solutions and embedded analytics to support business and product teams.