Quick overview
Job description
Minimum qualifications:
- 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).
Preferred qualifications:
- 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).
About the Analytics Engineer job
Pay, benefits and more:
- Competitive compensation package
- Full health insurance benefits are available on day one
- Life and disability insurance
- Earn up to 15 days of PTO over your first year
- 9 paid company holidays
- 401(k) option with company match
- Education assistance
- Opportunity to participate in a company incentive plan
What you'll do on a typical day:
- 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.
About XPO
XPO is a top ten global provider of transportation services, with a highly integrated network of people, technology and physical assets. At XPO, we look for employees who like a challenge and can communicate effectively in all situations. We want to leverage your skills and years of experience to drive positive results while ensuring a bright future for yourself and XPO. If you're looking for a growth opportunity, join us at XPO.
We are proud to be an Equal Opportunity employer. Qualified applicants will receive consideration for employment without regard to race, sex, disability, veteran or other protected status.
All applicants who receive a conditional offer of employment may be required to take and pass a pre-employment drug test.
The above statements are not an exhaustive list of all required responsibilities, duties and skills for this job classification.
Review XPO\'s candidate privacy statement .
PandoLogic. Keywords: Data Engineer, Location: Ann Arbor, MI - 48105
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- CO

Business Systems ManagerRecently posted Auto Apply
City of Greeley - · Greeley · Hybrid · Posted 19 Nov 2026 🇺🇸
Stakeholder ManagementOracleProject ManagementTechnology$107.7k - $144.2k/yr - IA
Principal Embedded Software EngineerRecently posted Auto Apply
II-VI Aerospace & Defense | Coherent · Santa Clara · On-site · Posted 19 Nov 2026 🇺🇸
ShellEmbedded SystemsC+++5TechnologySalary not listed - PH

Staff Platform & Security EngineerRecently posted Auto Apply
Project Healthy Minds · New York · On-site · Posted 19 Nov 2026 🇺🇸
SQLSpringGit+10Technology$220k - $260k/yr - CR

Electro-Optical Systems Engineer IIRecently posted Auto Apply
CFD Research Corporation · Huntsville · Hybrid · Posted 19 Nov 2026 🇺🇸
Embedded SystemsOpenCVAssembly+6TechnologySalary not listed - PI

Deployment EngineerRecently posted Auto Apply
Picklerobot · Greenville · On-site · Posted 19 Nov 2026 🇺🇸
GitRoboticsPython+2TechnologySalary not listed - AH

Senior Security EngineerRecently posted Auto Apply
August Health · United States · Remote · Posted 19 Nov 2026 🇺🇸
ScalaSpringAWS+13TechnologySalary not listed - NE

Software Engineer II (Remote in United States) Auto Apply
Nextech · United States · Remote · Posted 23 Oct 2026 🇺🇸
GCPMicroservicesSQL+7TechnologySalary not listed - OP

Business Intelligence Data Analyst Auto Apply
Openx · US - Remote · Remote 🇺🇸
SQLMicrosoft OfficeBigQuery+1Technology$93.5k - $110k/yr - OP

Business Intelligence Data Analyst Auto Apply
Openx · US - Remote · Remote 🇺🇸
SQLMicrosoft OfficeBigQuery+2Technology$93.5k - $110k/yr - HO

Clinical Apps Technical Support SpecialistRecently posted Auto Apply
Hologic · Marlborough · Hybrid · Posted 19 Nov 2026 🇺🇸
CRMCase ManagementCompliance+4Technology$62.3k - $97.4k/yr - CA

Intern, Crew Operations BI Report DeveloperRecently posted Auto Apply
Carnival Corporation · Seattle · Hybrid · Posted 19 Nov 2026 🇺🇸
OracleSQLGit+10TechnologySalary not listed - FW

Senior Information Technology System AdminRecently posted Auto Apply
Fwgsolutions · Baltimore · On-site · Posted 19 Nov 2026 🇺🇸
Microsoft ExcelMicrosoft OfficeMicrosoft PowerPoint+5TechnologySalary not listed