Procurement - Data Reporting & Solutions Analyst

Arconic Corporation; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

Arconic is seeking a Procurement – Data Reporting and Solutions Analyst to join our RPNA business unit. This role can be based at our Global Headquarters in Pittsburgh, PA or one of our three production facilities in RPNA (Davenport, IA; Alcoa, TN; Lancaster, PA).

The data analyst will design, develop, and maintain global BI and reporting solutions, collaborate with procurement teams, and drive KPI development for strategic procurement initiatives.

Qualifications

• Bachelor’s degree in Business, Management, Supply Chain, Logistics, Finance, Accounting, Data Science/Analytics, Marketing/Communications, Economics, Mathematics, or Engineering from an accredited institution.
• 3 years of experience in data analytics, purchasing and/or supply chain management.
• Employees must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire. Visa sponsorship is not available for this position.
• U.S. Only – This position may require access to export‑controlled technology, as defined in the Export Administration Regulations (15 C.F.R. §730, et seq.) and/or the International Traffic in Arms Regulations (ITAR). Qualified candidate must be a U.S. citizen, lawful permanent resident of the U.S., protected individual as defined by 8 U.S.C. 1324b(a)(3) or be eligible to obtain the required authorizations from the relevant government agency. Business demands may require employer to proceed with candidates who are immediately eligible to access controlled technology.

Responsibilities

• The data analyst works with procurement personnel globally to understand the data requirements for their business intelligence needs and specific projects, acquires the necessary data, and performs data transformation and analytics.
• Responsible for maintaining the Global Spend reporting/analytics solution to ensure that the business intelligence reporting maintains data integrity for decision‑making purposes (which can include senior management at Arconic). The analyst will establish mappings and work with global IT resources to resolve data and interface issues.
• Responsible to design, develop and maintain complex global Power BI and SharePoint solutions to track Spend, QBRs, Strategic Commercial Owner, Commodity accuracy and Market Intelligence for key global commodity areas to support critical business forecasts and “go‑to‑market” strategies.
• Consults with global cross‑departmental and cross‑functional team members to evaluate and specify interfaces between various systems to ensure synchronization of functionality and optimized operation and performance.
• Fully understands the various global procurement business processes and how these relate to the requirements for building reports, data, business intelligence and global KPIs.
• Program and solution owner for strategic global Procurement tools supporting Sourcing (RFP, RFI, Auctions), Working Capital and Contract Management. Drive adoption of tools within Global Procurement, provide training and central support to optimize use and deliver value to the company.
• Create the monthly Program Management Office (PMO) deck with KPI’s and backup detail to be reviewed with the VP Procurement, Directors and their direct reports. On occasion, present the PMO deck and related material.
• Backup the team global compliance, contracts/repository team member in case of absences by monitoring the general mailbox and taking action.

Skills

Data analytics

Procurement

Supply chain management

Education

Bachelor's degree in Business, Management, Supply Chain, Logistics, Finance, Accounting, Data Science/Analytics, Marketing/Communications, Economics, Mathematics, or Engineering

Tools

Excel

Power BI

SharePoint

Oracle database structures

SQL

Job description

Arconic is currently in search of a Procurement – Data Reporting and Solutions Analyst to join our Rolled Products North America (RPNA) business unit.

This role can be based at our Global Headquarters in Pittsburgh, PA or one of our three production facilities in RPNA (Davenport, IA; Alcoa, TN; Lancaster, PA).

At Arconic, we are looking for people who share our values of integrity, inclusion, and diversity, and who demonstrate agility, results commitment, and the capability to grow themselves and others. In return, we offer the opportunity to grow together with ongoing opportunities for professional growth provided by a constantly changing environment, working alongside employees who value the people they work with just as much as the work they do.

Primary Responsibilities

• The data analyst works with procurement personnel globally to understand the data requirements for their business intelligence needs and specific projects, acquires the necessary data, and performs data transformation and analytics.
• Responsible for maintaining the Global Spend reporting/analytics solution to ensure that the business intelligence reporting maintains data integrity for decision‑making purposes (which can include senior management at Arconic). The analyst will establish mappings and work with global IT resources to resolve data and interface issues.
• Responsible to design, develop and maintain complex global Power BI and SharePoint solutions to track Spend, QBRs, Strategic Commercial Owner, Commodity accuracy and Market Intelligence for key global commodity areas to support critical business forecasts and “go‑to‑market” strategies.
• Consults with global cross‑departmental and cross‑functional team members to evaluate and specify interfaces between various systems to ensure synchronization of functionality and optimized operation and performance.
• Fully understands the various global procurement business processes and how these relate to the requirements for building reports, data, business intelligence and global KPIs.
• Program and solution owner for strategic global Procurement tools supporting Sourcing (RFP, RFI, Auctions), Working Capital and Contract Management. Drive adoption of tools within Global Procurement, provide training and central support to optimize use and deliver value to the company.
• Create the monthly Program Management Office (PMO) deck with KPI’s and backup detail to be reviewed with the VP Procurement, Directors and their direct reports. On occasion, present the PMO deck and related material.
• Backup the team global compliance, contracts/repository team member in case of absences by monitoring the general mailbox and taking action.

Key Objectives

• Assist in achieving global Procurement targets inclusive of cost, innovation, quality, and supplier performance by providing business intelligence data for leadership decision‑making.
• Establish and maintain key organizational KPI’s to track the Global Procurement team key business objectives.
• Use Market Intelligence data to provide future cost projections of key commodities and recommendations of buying strategies to maximize value to shareholders of the company.
• Lead cross‑functional teams to identify, define and deliver new global procurement tools and processes to lower the cost structure of the company and achieve world‑class cost benchmarks.
• Support preparation for global commercial / non‑commercial events to meet objectives, including, but not limited to RFP/RFI’s, Kaizen workshops and Working Capital/Inventory Workshops.
• Interface with Procurement Operations Managers at each manufacturing site in the U.S. to develop in‑depth understanding of purchasing processes, critical material sourcing and savings initiatives.

Qualifications

• Bachelor’s degree in Business, Management, Supply Chain, Logistics, Finance, Accounting, Data Science/Analytics, Marketing/Communications, Economics, Mathematics, or Engineering from an accredited institution.
• 3 years of experience in data analytics, purchasing and/or supply chain management.
• Employees must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire. Visa sponsorship is not available for this position.
• U.S. Only – This position may require access to export‑controlled technology, as defined in the Export Administration Regulations (15 C.F.R. §730, et seq.) and/or the International Traffic in Arms Regulations (ITAR). Qualified candidate must be a U.S. citizen, lawful permanent resident of the U.S., protected individual as defined by 8 U.S.C. 1324b(a)(3) or be eligible to obtain the required authorizations from the relevant government agency. Business demands may require employer to proceed with candidates who are immediately eligible to access controlled technology.

Preferred Qualifications

• 5 years' experience in data analytics, purchasing and/or supply chain management.
• MBA in Business Administration/Economics or similar.
• Expertise in Excel, Power Point, SharePoint and Power BI.
• Familiarity with Oracle database structures and SQL for troubleshooting with IT.
• Decision‑making.
• Strong Communication skills.
• Innovative, Strategic thinker.
• Customer‑oriented.