Engineer, Business Intelligence - Hybrid

XPO

Charlotte (NC)

Presencial

USD 90.000 - 120.000

Jornada completa

hace 19 horas
Sé de los primeros/as/es en solicitar esta vacante

Una candidatura completa en un minuto

Currículum y carta de presentación personalizados, listos para enviar.

Supera los filtros ATS

Ventajas ofrecidas por este puesto de trabajo

Health insurance
Life and disability insurance
PTO 15 days in first year
9 company holidays
401(k) with company match
Education assistance
Opportunity to participate in company-

Descripción de la vacante

XPO is hiring an Analytics Engineer in Charlotte to transform raw data into reliable, analytics-ready datasets. You’ll write and optimize SQL, build dbt models, and maintain data definitions to support business decisions.

You’ll collaborate with analysts and data engineers, enhance data quality, and assist with dashboards in Looker, Tableau, Power BI, or Sigma while growing your Python and cloud data warehousing knowledge.

Formación

  • Bachelor’s degree in CS, Data Analytics, Information Systems, or equivalent with a strong SQL portfolio.
  • 1 year minimum experience in CS, Data Analytics, IS, or related field.
  • Solid understanding of relational database concepts, joins, aggregations, window functions, and subqueries/CTEs.
  • High attention to detail with the ability to investigate data issues and identify root causes.
  • Familiarity with Git workflows (commits, pushes, branches).

Responsabilidades

  • Write, debug, and optimize SQL queries using CTEs to transform raw data into structured dimensional models.
  • Build and run modular dbt models under senior engineers’ guidance.
  • Map and clean incoming raw schemas to align with global definitions.
  • Write automated dbt tests to verify data quality and integrity.
  • Troubleshoot daily data quality alerts and fix source data issues.
  • Participate in code reviews to learn coding standards and contribute PRs.
  • Maintain data catalogs and dbt metadata for business users.
  • Assist BI teams in pointing dashboards to new data warehouse tables.
  • Collaborate with analysts to identify new fields or metrics to add to datasets.
  • Grow skills in Python, CLIs, Snowflake/BigQuery, and data modeling theories.

Conocimientos

SQL
Git
Analytical thinking

Educación

Bachelor's degree in CS/Data Analytics/IS

Herramientas

dbt
Power BI
Tableau
Looker
Sigma
Python

Descripción del empleo

What you’ll need to succeed as a Analytics Engineer at XPO
  • 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 here.

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Senior Analyst, Financial Reporting - Hybrid
Senior Analyst, Financial Reporting - Hybrid

XPO • North Richland Hills (TX)

Presencial
USD 85.000 - 120.000
Health insurance (on day one)
Life and disability insurance
PTO 15 days first year
+4
Senior Analyst, Financial Reporting - Hybrid
Senior Analyst, Financial Reporting - Hybrid

XPO Logistics • North Richland Hills (TX)

Presencial
USD 85.000 - 120.000
Health insurance on day one
Life and disability insurance
PTO 15 days
+4
Senior Scientist, Data Science - Hybrid
Senior Scientist, Data Science - Hybrid

XPO • Boston (MA)

Híbrido
USD 140.000 - 190.000
Health insurance
Paid time off (PTO)
401(k) with company match
+1
Senior Linehaul Analytics & Ops Strategy
Senior Linehaul Analytics & Ops Strategy

XPO Logistics • Ann Arbor (MI)

Presencial
USD 70.000 - 100.000
Senior Analyst, Financial Reporting - Hybrid
Senior Analyst, Financial Reporting - Hybrid

XPO Logistics, Inc. • Charlotte (NC)

Presencial
USD 90.000 - 130.000
Health insurance on day one
Life and disability insurance
PTO 15 days first year
+4
Senior Scientist, Data Science - Hybrid
Senior Scientist, Data Science - Hybrid

XPO Logistics • Boston (MA)

Presencial
USD 150.000 - 210.000
Competitive compensation
Health insurance on day one
Life and disability insurance
+5
Senior Analyst, Linehaul Solutions - Hybrid at XPO Logistics Ann Arbor, MI
Senior Analyst, Linehaul Solutions - Hybrid at XPO Logistics Ann Arbor, MI

XPO Logistics • Ann Arbor (MI)

Híbrido
USD 70.000 - 100.000
Health insurance from day one
Life and disability insurance
15 days PTO first year
+4
Senior Scientist, Data Science - Hybrid
Senior Scientist, Data Science - Hybrid

XPO Logistics, Inc. • Ann Arbor (MI)

Presencial
USD 120.000 - 180.000
Health insurance on day one
Life and disability insurance
Paid time off: up to 15 days in first
+3
Senior Scientist, Data Science - Hybrid
Senior Scientist, Data Science - Hybrid

XPO • Ann Arbor (MI)

Presencial
USD 120.000 - 180.000
Competitive compensation package
Health insurance on day one
Life and disability insurance
+5
Senior Scientist, Data Science - Hybrid
Senior Scientist, Data Science - Hybrid

XPO Logistics, Inc. • Boston (MA)

Presencial
USD 140.000 - 180.000
Full health insurance on day one
Life and disability insurance
PTO up to 15 days in first year
+4