Engineer, Business Intelligence

XPO•Ann Arbor, MI

About The Position

The Analytics Engineer at XPO writes, debugs, and optimizes SQL to transform raw staging data into structured dimension and fact tables. The role develops modular dbt models with guidance from senior engineers, aligns incoming schemas with global database definitions, and creates automated tests to validate data quality. It also involves troubleshooting data quality alerts and pipeline warnings, participating in code reviews, and maintaining data catalog and schema documentation. The engineer works with analysts to gather requirements for dataset fields and business metrics, and helps analysts connect BI tools to newly deployed warehouse tables. The position provides opportunities to develop skills in Python, command-line utilities, cloud data warehouses such as Snowflake and BigQuery, and modern data modeling. XPO describes this as a growth opportunity within its global transportation services business.

Requirements

  • Bachelor’s degree in Computer Science, Data Analytics, Information Systems, or equivalent experience/bootcamp completion accompanied by a strong portfolio of SQL projects.
  • At least 1 year of experience in Computer Science, Data Analytics, Information Systems, or a related field.
  • Solid understanding of relational database concepts, JOIN types, aggregations, window functions, and subqueries or CTEs.
  • High attention to detail and a desire to investigate unexpected numbers by examining raw data and finding root causes.
  • Familiarity with Git concepts, including making commits, pulling, pushing, and branching.

Nice To Haves

  • Familiarity with dbt, such as experience running a local dbt project, dbt Learn certification, or class projects using dbt.
  • Prior experience building simple dashboards in Looker, Tableau, Power BI, or Sigma.
  • Familiarity with basic Python, including pandas, list manipulations, and syntax.

Responsibilities

  • Write, debug, and optimize SQL queries using common table expressions to transform raw staging data into structured dimension and fact tables.
  • Build and run modular dbt models under the guidance of senior engineers.
  • Map, cast, and clean incoming raw database schemas to align them with global database definitions.
  • Write automated dbt schema tests, including uniqueness, not-null, and referential-integrity tests.
  • Troubleshoot daily data quality alerts and pipeline warning logs, collaborating with data engineers to fix source data bugs.
  • Submit pull requests and participate in code reviews.
  • Keep internal data catalogs, dbt descriptions, and schema documentation up to date.
  • Assist data analysts in connecting BI tools to newly deployed data warehouse tables.
  • Partner with analysts to identify new fields or business metrics needed in existing datasets.
  • Develop skills in Python, command-line utilities, cloud data warehousing, and modern data modeling.

Benefits

  • Competitive compensation package
  • Full health insurance benefits available on day one
  • Life and disability insurance
  • Earn up to 15 days of PTO over the first year
  • Nine paid company holidays
  • 401(k) option with company match
  • Education assistance
  • Opportunity to participate in a company incentive plan
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service