Arconic is currently in search of a Data Analyst to join our Arconic Aluminum Extrusions Finance team in Lafayette IN.
At Arconic, we take pride in our work and our innovative products and technologies that advance sustainable solutions for a better world. We strive to create a safe, inclusive and collaborative workplace with competitive benefits, development opportunities and a culture that values and rewards employees on all levels of the organization.
The Data Analyst is responsible for developing, maintaining, and analyzing spreadsheet-based reports that support business decision making, with focus on Finance and Human Resources. This role will work extensively with Microsoft Excel to organize, validate, and analyze data using lookup functions, formulas and structured reporting to ensure accuracy, consistency, and timely delivery of insights.
The ideal candidate is highly detail-oriented, comfortable working with large datasets, and translating raw data into clear, actionable reports for finance and HR stakeholders.
Finance Support
- Create and maintain Excel-based financial reports using formulas, including VLookup, HLookup, XLookup, IFstatements, and pivot tables
- Consolidate data from multiple sources into standardized reporting templates.
- Perform data validation and reconciliation to ensure accuracy of financial information.
- Support budgeting, forecasting, cost tracking, and variance analysis reporting.
- Respond to ad-hoc data and reporting requests from Finance leadership.
Human Resources Support
Develop and maintain HR-related reports (e.g., headcount, turnover, attendance, labor metrics).
Support data analysis related to compensation, benefits, and workforce planning.
Ensure data integrity and consistency between datasets.
Assist with periodic HR reporting needs for leadership or compliance purposes.
Genera Data & Reporting Responsibilities
- Design, improve and automate spreadsheet reports for efficiency and clarity.
- Identify trends, discrepancies, and insights within data and communicate findings clearly.
- Document report logic, formulas and data sources
- Collaborate with Finance and HR stakeholders to understand reporting needs and timelines.
- Maintain confidentiality of sensitive financial and employee data.
Notes
Required
- Bachelor’s degree in Finance, Accounting, Economics, Data Analytics, Business, Human Resources or a related field (or equivalent experience)
- Strong proficiency in Microsoft Excel including:
- VLookup/HLookup/XLookup
- Nested formulas
- Pivot tables and charts
- Experience creating structured spreadsheet reports for business or financial use
- Strong attention to detail and data accuracy
- Ability to manage multiple requests and meet deadlines.
- 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.
Preferred
Experience supporting Finance and/or Human Resource functions.
Familiarity with HRIS or financial systems (e.g., Oracle, SAP, Workday)
Basic experience with data visualization or reporting tools (Power BI, Tableau etc.)
Understanding of financial or workforce metrics
Strong communication skills and ability to explain data clearly to non-technical users.
Key Competencies
Analytical Thinking
Data accuracy and integrity
Organization and time management
Confidentiality and professionalism
Collaboration and customer-service mindset
Arconic Corporation is a leading provider of aluminum sheet, plate and extrusions, as well as innovative architectural products, that advance the automotive, aerospace, commercial transportation, industrial and building and construction spanets. Building on more than a century of innovation, Arconic helps to transform the way we fly, drive, and build.
We live our core values and commit to delivering sustainable value to our customers, our employees, our communities and our stakeholders.
At Arconic, we:
Act With Integrity : We lead with respect, honesty, transparency and accountability.
Safeguard our Future : We protect and improve the health and safety of our employees, communities and environment.
Grow Stronger Together : We cultivate an inclusive and diverse culture that advocates for equity.
Earn Customer Loyalty : We build customer partnerships through best-in-class products and service.
Drive Operational Excellence : We pursue continuous improvement through innovation, agility, people development and collaboration.
Create Value : We achieve success by generating and growing value for our stakeholders.
This position is subject to Export Control Law: This position requires access to 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). Authorizations from the relevant government agency may be required to meet export control compliance requirements.
United States EEO Statement: Arconic Corporation is an equal opportunity employer. We take action to ensure equal opportunity for all applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, Veteran status, or other legally protected characteristics.
Lafayette Operations in Lafayette, IN is located approximately 60 miles from the states capital, Indianapolis and is the home to Purdue University. Our Lafayette location has been continuously running in Lafayette community since 1938. We are an Aluminum Extrusions plant for Aerospace, Automotive, Industrial and Defense facility.