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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Job Type
Full-time
Career Level
Entry Level