Description: Supply Chain Program Analytics Analyst (Contract)
Location: Phoenix, AZ (PHX Hub)
Work Arrangement: Onsite - 5 Days Per Week
Contract Duration: Ongoing need with potential for extension or conversion
Position Summary
*** Motors is seeking a highly analytical and technically skilled Supply Chain Program Analytics Analyst to support vehicle programs, engineering builds, and operational improvement initiatives. This role is approximately 70% analytics/reporting development and 30% program coordination.
The successful candidate will transform complex supply chain and build-related data into scalable reports, dashboards, databases, visualizations, and decision-ready insights while supporting program schedules, readiness reviews, risk management, and stakeholder coordination. This is a hands-on individual contributor role requiring strong analytical capabilities, autonomous execution, and excellent communication skills.
Key Responsibilities
Design, develop, and maintain recurring and ad hoc reports, dashboards, databases, and analytics solutions.
Create and automate reporting using advanced Excel, Python, and Tableau.
Develop dashboards and visualizations that communicate program health, readiness, risks, and delivery status.
Consolidate data from SAP, Coupa, Jira, Smartsheet, supplier reports, and internal systems into centralized reporting tools.
Perform data validation, reconciliation, and root-cause analysis.
Analyze build readiness, sourcing status, supplier commitments, inventory levels, and material availability.
Build trend analyses, exception reports, clear-to-build views, and scenario modeling tools.
Support program management activities including milestone tracking, risk registers, issue logs, action items, and status reporting.
Prepare reporting packages for leadership reviews and readiness meetings.
Coordinate with Supply Chain, Engineering, Manufacturing, Logistics, Finance, Program Management, and suppliers to resolve issues and drive deliverables.
Standardize reporting methodologies and develop scalable process improvements.
Required Qualifications
Bachelor's degree in Supply Chain Management, Business Analytics, Data Analytics, Engineering, Information Systems, Program Management, or a related field; equivalent experience will be considered.
5+ years of professional experience.
Expert-level Microsoft Excel skills including:
Pivot Tables
XLOOKUP/VLOOKUP
Power Query
Data Modeling
Complex formulas
Basic VBA/Macros
Hands-on Python experience focused on data analysis, automation, reporting, and data transformation.
Experience developing Tableau dashboards and visualizations.
Experience creating and maintaining reporting databases and data repositories.
Strong analytical, troubleshooting, and problem-solving capabilities.
Excellent verbal and written communication skills.
Ability to work independently and manage multiple priorities in a fast-paced environment.
Preferred Qualifications
SAP experience (required by hiring manager).
Experience with Coupa, Jira, and Smartsheet.
Supply chain, procurement, manufacturing, logistics, or operations analytics experience.
Supplier management experience.
Startup environment experience.
Mandarin language skills are a plus.
Top Required Skills
Advanced Excel (Highest Priority)
Dashboarding, Data Analytics & Coding (Tableau/Python)
SAP
Required Soft Skills
Strong executive-level communication skills.
Experience working with internal and external stakeholders.
Supplier management experience.
Ability to work autonomously with minimal direction.
Strong relationship-building skills.
Adaptable, collaborative, and culturally competent.
Candidate Screening Questions
Describe your experience using advanced Excel functions such as Power Query, Pivot Tables, XLOOKUP, and data modeling.
Tell us about a reporting or analytics solution you automated using Python.
What Tableau dashboards have you developed, and what business decisions did they support?
Describe your experience working with SAP and supply chain data.
Have you supported supply chain, procurement, manufacturing, logistics, or program management teams?
Provide an example of a complex stakeholder group you managed and how you influenced outcomes.
Describe your experience maintaining action logs, risks, milestones, and readiness reviews.
Are you available to work onsite in Phoenix, AZ five days per week?
Ideal Candidate Profile
Green Flags
Strong executive presence and communication skills.
Relationship builder who works effectively across organizations.
Self-starter with strong initiative.
Comfortable presenting data and insights to leadership.
Adaptable and able to navigate ambiguity.
Supplier management experience.
Demonstrated analytics, dashboarding, and automation expertise.
Mandarin language skills are a strong plus.
Red Flags
Disorganized work style.
Requires constant direction.
Limited stakeholder management experience.
Weak communication skills.
Unable to independently develop reporting and analytics solutions.
Reactive rather than proactive approach to problem solving.
Why This Role?
Support high-visibility vehicle programs and engineering builds.
Build scalable analytics and automation solutions that directly influence business decisions.
Partner with Supply Chain, Engineering, Manufacturing, Logistics, Finance, and other cross-functional teams.
Develop reporting tools and dashboards from the ground up.
Contribute to ***'s mission of advancing sustainable transportation.
Exposure to multiple functions across the organization with strong potential for long-term growth.
Custom Fields:
Name: Office Location
Value: USA_USAZ_PhoenixHub
Name: Country
Value: United States
Name: Previously Worked At ***?
Value: No
Name: Sub-Department
Value: DEFAULT-DEFAULT-Default
Name: Employee Class
Value: Contractor
Name: Division
Value: GSC-Supply Chain
Name: Line
Value: DEFAULT-Default
Name: Business Unit
Value: Manufacturing & Operations
Name: Department
Value: SUPPRO-Supply Chain Programs
Name: Onsite / Remote Work Capability
Value: Onsite
Name: Region
Value: North America