Engineer, Business Intelligence - Hybrid

XPO•Charlotte, NC
•Hybrid

About The Position

XPO is hiring an Engineer, Business Intelligence (described in the posting as an Analytics Engineer) to help build and maintain analytics data models and support business intelligence users. The role transforms raw staging data into structured dimension and fact tables, aligns incoming database schemas with global definitions, and uses automated tests and data-quality troubleshooting to protect downstream models. The engineer works with senior engineers and analysts, contributes through pull requests and code reviews, and maintains documentation and data catalogs. The position also offers opportunities to develop skills in Python, command-line utilities, cloud data warehousing, and modern data modeling. XPO is a global transportation services provider with an integrated network of people, technology, and physical assets. The company describes this role as a growth opportunity and states that qualified applicants are considered without regard to protected status. Applicants who receive a conditional offer may be required to pass a pre-employment drug test.

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/CTEs.
  • High attention to detail and a desire to investigate unexpected numbers by examining raw data and identifying root causes.
  • Familiarity with Git concepts, including making commits, pulling, pushing, and branching.

Nice To Haves

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

Responsibilities

  • Write, debug, and optimize SQL queries, including Common Table Expressions, to transform raw staging data into 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 with global database definitions.
  • Write automated dbt schema tests, including uniqueness, non-null, and referential-integrity tests.
  • Troubleshoot daily data-quality alerts and pipeline warning logs, collaborating with data engineers to resolve source-data bugs.
  • Submit pull requests and participate in code reviews to learn and follow company coding styles and design standards.
  • Keep internal data catalogs, dbt descriptions, and schema documentation up to date.
  • Assist data analysts with connecting BI tools to newly deployed data warehouse tables.
  • Work with analysts to identify new fields or business metrics to add to existing datasets.
  • Develop skills in Python, command-line utilities, cloud data warehousing structures, and modern data modeling theories.

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