> Markdown version of [/jobs/ext/4784386-engineer-business-intelligence](https://www.wearedevelopers.com/jobs/ext/4784386-engineer-business-intelligence). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Engineer, Business Intelligence - **Company:** XPO Logistics, Inc. - **Location:** Ann Arbor, MI, United States - **Contract:** Permanent contract - **Skills:** BigQuery, Cloud Database, Code Review, Information Systems, Databases, Data Integrity, Data Visualization, Data Warehousing, Relational Databases, Software Debugging, Python (Programming Language), Raw Data, Power BI, SQL Databases, Tableau (Software), Snowflake, Data Build Tool (dbt), Git, Pandas, Information Technology, Data Analytics, Looker Analytics - **Published:** November 19, 2026 - **Apply:** https://jobs.xpo.com/talentcommunity/apply/1451986000/?locale=en_US ## About the Role * Bachelor's degree in Computer Science, Data Analytics, Information Systems, or equivalent experience/bootcamp completion accompanied by a strong portfolio of SQL projects. * 1 year mimum 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 with an intrinsic desire to understand "why" a number looks wrong and dig into raw data to find the root cause. * Familiarity with the concepts of Git (making commits, pulling, pushing, and branching)., * Familiarity with dbt: Any experience running a local dbt project, dbt Learn certification, or class projects using dbt. * Data Visualization Experience: Prior experience building simple dashboards in Looker, Tableau, Power BI, or Sigma. * Basic Python: Familiarity with Python basics (pandas, list manipulations, syntax). ## Description * Wryte Clean SQL: Write, Debug, and Optimize SQL queries using Common Table Expressions (CTES) to transform raw staging data into structured dimension and fact tables. * Dbt Development: Build and run modular models in dbt (Data Build Tool) under the guidance of senior engineers. * Schema & Format Alignment: Help map, cast, and clean incoming raw database schemas so they align with our global database definitions. * Implement Tests: Write automated dbt schema tests (such as unique, not_null, and referential integrity tests) to verify that raw data isn't breaking our downstream models. * Debug Failures: Troubleshoot daily data quality alerts and pipeline warning logs, collaborating with data engineers to fix source data bugs. * Code Review Participation: Submit pull requests (PRs) for your code and participate in reviews to learn company coding styles and design standards. * Maintain Data Catalog: Ensure our internal data catalogs, dbt descriptions, and schema documentation are up to date so business users can easily find the metrics they need. * Dashboard Maintenance: Assist data analysts in pointing BI tools (like Tableau, Power BI, or Looker) to newly deployed data warehouse tables. * Requirement Gathering: Partner with analysts to understand what new fields or business metrics need to be added to existing datasets. * Skill Growth: Dedicate time to learning Python, basic command-line utilities, cloud data warehousing structures (Snowflake, BigQuery), and modern data modeling theories.