Sales Analytics & IT Specialist, Mopar eCommerce
Stellantis, Auburn, AL, United States
Be the analytics and systems backbone for Mopar eCommerce. Build robust data pipelines and Power BI models, integrate Adobe/GA4 and internal Stellantis systems (PIM, CRM, OMS, ERP/cloud), and publish daily/weekly/monthly/annual insights that drive decisions—and outcomes.
What You’ll Do (Key Responsibilities)
Design data models and interactive dashboards in Power BI (DAX/Power Query) for executive and operational audiences. Integrate GA4 and Adobe Analytics data with CRM/CDP, PIM/MDM, OMS/ERP, and marketplace feeds; standardize tracking taxonomy and UTM governance. Build and maintain ETL/ELT pipelines; implement data quality monitoring, anomaly detection, and alerting for daily checks. Own tag management and event schema (Adobe Launch/Tealium/GTM); ensure privacy compliance and consent management alignment. Diagnose data and systems issues (schema drift, API failures, latency) and coordinate resolution with ICT and vendor teams. Deliver insights and recommendations on traffic, conversion funnels, attach rate, AOV, pricing, inventory fill rate, and marketplace performance (e.g., Buy Box). Publish weekly and monthly business reviews with clear narratives, scorecards, and prioritized actions. What You’ll Bring (Qualifications)
Bachelor's Degree in Data Analytics, Information Systems or related field Minimum of 5 years in analytics/BI/marketing science with enterprise eCommerce; expert in Power BI (DAX, Power Query) and SQL. Proficient with Adobe Analytics and GA4; experience with tag management and server‑side/event streaming preferred. Hands‑on with ETL/ELT and modern data stacks (e.g., Azure Data Factory/Synapse, Databricks, or similar). Familiarity with PIM/MDM, CRM/CDP, OMS/ERP, and product fitment standards; ability to model complex hierarchical product data. Strong problem solver with excellent communication; able to translate analysis into decisions and direct ICT teams to action. Nice to Have
Python/R for advanced analysis, forecasting, and causal inference. Experience with marketplace data (Amazon SP‑API, eBay, Walmart APIs) and retail media measurement. Role Details
Location: Auburn Hills, MI (100% onsite) Travel: 0–3% expected Employment: Full‑time; individual contributor with matrixed engineering and ICT support.
#J-18808-Ljbffr
Design data models and interactive dashboards in Power BI (DAX/Power Query) for executive and operational audiences. Integrate GA4 and Adobe Analytics data with CRM/CDP, PIM/MDM, OMS/ERP, and marketplace feeds; standardize tracking taxonomy and UTM governance. Build and maintain ETL/ELT pipelines; implement data quality monitoring, anomaly detection, and alerting for daily checks. Own tag management and event schema (Adobe Launch/Tealium/GTM); ensure privacy compliance and consent management alignment. Diagnose data and systems issues (schema drift, API failures, latency) and coordinate resolution with ICT and vendor teams. Deliver insights and recommendations on traffic, conversion funnels, attach rate, AOV, pricing, inventory fill rate, and marketplace performance (e.g., Buy Box). Publish weekly and monthly business reviews with clear narratives, scorecards, and prioritized actions. What You’ll Bring (Qualifications)
Bachelor's Degree in Data Analytics, Information Systems or related field Minimum of 5 years in analytics/BI/marketing science with enterprise eCommerce; expert in Power BI (DAX, Power Query) and SQL. Proficient with Adobe Analytics and GA4; experience with tag management and server‑side/event streaming preferred. Hands‑on with ETL/ELT and modern data stacks (e.g., Azure Data Factory/Synapse, Databricks, or similar). Familiarity with PIM/MDM, CRM/CDP, OMS/ERP, and product fitment standards; ability to model complex hierarchical product data. Strong problem solver with excellent communication; able to translate analysis into decisions and direct ICT teams to action. Nice to Have
Python/R for advanced analysis, forecasting, and causal inference. Experience with marketplace data (Amazon SP‑API, eBay, Walmart APIs) and retail media measurement. Role Details
Location: Auburn Hills, MI (100% onsite) Travel: 0–3% expected Employment: Full‑time; individual contributor with matrixed engineering and ICT support.
#J-18808-Ljbffr