Supply Chain Analyst

Client: Collins Aerospace

Job ID: 21768-1

Job Title: Supply Chain Analyst

Duration: 12 Months

Location: NC-WINSTON SALEM-175 175 Oak Plaza Blvd BLDG 175

PLEASE NOTE:
Title: Supply Chain Analyst (will be dealing with a lot of databases)
**looking for someone who has intellect in adaptability cannot be shy can work in matrix model company if introvert this is not the company*
Education: Bachelors Required*
Experience: AT LEAST 2-3 years of in data analysis
Citizenship: MUST BE A US Citizen
Schedule: M-F 7am/9am - 3pm/5pm (flexible start/end time 8hrs/day)
Overtime: OT may not be likely at first if it were to come up it would be voluntary
FULLY ON SITE at first (must be local to Winston Salem*) then move to hybrid (will discuss with manager)
Possible temp to perm for the right person and dependent on business needs
Interviews will be virtual
-Supplier Limit 3

Job Description

Title: Supply Chain Analyst (will be dealing with a lot of databases)
POSITION SUMMARY
The Supply Chain Contract Analyst supports the Engineered Items commodity team by managing sourcing operations contract administration and supplier coordination activities. This role serves as a key operational resource for commodity managers and strategic project managers driving execution of the ACN process cost-reduction initiatives supplier transitions and data-driven reporting across SAP Power Steering Ariba Dossier and Tableau platforms.
Success in this role is measured by timely accurate execution of procurement workflows proactive stakeholder communication and tangible contributions to year-over-year cost reduction targets and supplier strategy alignment.

KEY RESPONSIBILITIES
1. ACN (Approval Change Notice) Process Support
Assist in the end-to-end ACN process from initiation through completion including required documentation and calculations.
Obtain and coordinate approvals from Contracts Finance and Compliance teams.
Coordinate with commodity managers buyers and cross-functional stakeholders to execute ACNs on schedule.
Implement and support the SAP workflow related to ACN execution and tracking.

2. Power Steering - Project Management & Reporting
Update project forecasts status notes and milestones in Power Steering on a regular cadence.
Enter new sourcing and cost-reduction projects into the system as required.
Pull data and generate reports to support commodity team reporting and decision-making.

3. Parts Sourcing Library (PSL) Administration
Update the PSL with parts and pricing information tied to Power Steering projects.
Pull reports from PSL as needed to support sourcing analysis and supplier evaluations.
Perform various data analyses leveraging PSL data sets.

4. Contract Database (CD) Management
Maintain and update the Contract Database with sourcing details spend data and Gate LEs.
Assist in assembling negotiation workbooks/sandbox
Follow up on contract approvals and ensure timely closure of open items.

5. Work Transition Projects
Assist in developing work transition documentation including risk profiles business cases and justification materials.
Support project scheduling and coordination of team meetings.
Assist in building project plans with defined milestones and stakeholder assignments.
Contribute to change management activities supporting cost savings or supply base realignment.

6. Ariba - Procurement Platform Support
Manage case files within Ariba including creating sourcing projects and issuing RFQs (Request for Quotation).
Ensure data integrity and timely progression of sourcing events within the platform.

7. SAP Data Extraction & Analysis
Pull data from multiple SAP instances to support commodity reporting and cost analysis.
Interpret and validate data to ensure accuracy of downstream reports and business cases.

8. Tableau Reporting
Access and extract reports and dashboards from Tableau to support commodity team analytics needs.
Present data clearly to support leadership visibility into project status and financial performance.

9. Blueprint (B/P) & Xclass Data Support
Assist in pulling blueprints and Xclass classification data as requested by the commodity team.
Organize and maintain documentation in a structured and accessible format.

10. Supplier Compliance & Trade Documentation
Follow up with suppliers to obtain required metals declarations tariff data and USMCA (formerly NAFTA) compliance forms.
Track open requests and escalate overdue items to commodity managers as appropriate.

11. General Contract Management
Assist in updating input sheet for contract data load into SAP
Assist in putting together case file documentation for Compliance
Assist in pulling data for assertions as well as navigate the assertion process workflow for execution

QUALIFICATIONS
Education & Experience
Bachelors degree in supply chain management Business Administration Engineering or a related field.
12 months or less of relevant professional work experience
US Citizenship required - see eligibility notice above.

Technical Skills
Strong proficiency in Microsoft Excel (pivot tables VLOOKUP data modeling) and PowerPoint.
Working knowledge of Microsoft Access database for data management and querying.
Familiarity with SAP - ability to navigate instances and extract data for analysis.
Strong analytical skills with the ability to interpret data and draw actionable conclusions.

Core Competencies
Analyze data to ensure supplier proposals are complete competitive and aligned to commodity strategy.
Support supplier negotiations to achieve cost reductions and improve agreement coverage.
Execute compliance packages and contract actions across the supply base.
Evaluate sourcing options to align with business unit needs and commodity strategies.
Manage and improve cross-functional tools and reporting processes.
Communicate clearly and professionally with leadership cross-functional teams and suppliers.
Self-starter with strong problem-solving skills and a willingness to learn.

WORKING CONDITIONS & EXPECTATIONS
Primarily office-based with potential for hybrid flexibility based on business needs.
Must be able to work effectively in a fast-paced environment with shifting priorities.
Occasional extended hours may be required to meet project deadlines.

Personal Details