Financial Analyst II

Description: We're looking for someone that has system administration experience with Hyperion Planning and/or Oracle Enterprise Performance Management (EPM) applications. Not just someone who was an end user (not someone who uses Hyperion to refresh or create reports in excel), but someone who has 'behind the scenes' experience. For example, someone who helped managed security of Hyperion consolidation applications and/or implemented hierarchical metadata changes. This is ~50% of the role we're trying to fill and is the focus area for this candidate. Our ideal candidate is someone who has experience in that space.

Hybrid - in office Mon, Wed, Thurs (at 201 Isabella Street,Pittsburgh, PA 15212) and remote Tues, Fri

*Shift: 1st (Generally 8am-5pm Monday through Friday but some overtime required)

*Possible contract-to-hire

*Some overtime required

*Top (3) skills: 1) Hyperion Administration experience, 2) Detail / Process oriented, 3) Critical thinker that shows resourcefulness in gathering data / is a self-directed problem solver

*Hyperion Administration experience is preferred

*Interviews required; 1st round is virtual, 2nd round is in person

*** Aerospace, headquartered in Pittsburgh, Pennsylvania, is a leading global provider of advanced engineered solutions for the aerospace and transportation industries. Our primary businesses focus on jet engine components, aerospace fastening systems and titanium structural parts necessary for mission-critical performance and efficiency in aerospace and defense applications, as well as forged wheels for commercial transportation. Aerospace is transforming the next phase of more fuel-efficient, quieter aerospace engines and sustainable ground transportation.
Financial Planning and Analysis (FP&A) team leads company-wide financial planning, forecasting and analytics. To effectively complete our mission, we:
• Drive financial planning and forecasting processes including management reviews
• Consolidate and report performance for business segments including P&L, Balance Sheet, and Cash Flows
• Develop external financial presentations working closely with C-Suite and Investor Relations
• Create insights into ***'s businesses, markets, competitors, and customers through fact-based financial analysis
• Oversee capital investment budgeting and approval processes
• Control corporate resource unit's budgets and allocations

The Senior Manager, Financial Planning & Analysis (FP&A) supports company-wide consolidated financial reporting and supports critical financial forecasting systems to deliver accurate and timely financial planning, forecasting, and reporting. This position also derives business insights for assigned business segments by conducting financial and strategic analysis to help inform the decisions of executive management.
Major activities/Key challenges
• Own the Hyperion Planning environment administration by handling system maintenance tasks, ensuring data integrity, and conducting user training.
• Participate in strategic direction, ongoing management and administration of Hyperion Planning system.
• Manage critical source files and processes for efficient and accurate data collection and reporting including business driver models.
• Support FP&A process and system improvement projects to achieve world-class performance.
• Derive business insights from financial and strategic analysis and synthesize into high impact, targeted recommendations and presentations for senior management review and decision making.
• Gain in-depth understanding of segment operations and business drivers to recommend improvements.
• Review monthly actual, forecast and plan performance; understand deviations from both forecast, plan and prior year to provide insights to senior management.
• Prepare quarterly financial reports in support of the earnings release process as well as 10-Q and 10-K filings.
• Analyze markets, products and customer revenue and profitability to recommend actions that improve business results.
• Conduct business and competitor analysis as well as external benchmarking.
• Collaborate on ad hoc and ongoing financial analysis.
• Develop a network of contacts across Segment and Resource Units to facilitate efficient data gathering.

Essential Knowledge & Skills/Education
• Excellent financial analytics and quantitative skills
• Understanding of financial statements (income, balance sheet and cash flow statements)
• Developing financial models to connect underlying business drivers to financial outcomes
• Critical thinker that shows resourcefulness in gathering data, and is a self-directed problem solver
• Conducts high-quality, detailed, accurate and well-documented quantitative and qualitative analysis including an ability to flesh out detail and clarify understanding of assigned work
• Experienced in Microsoft Excel, PowerPoint, SharePoint, and Hyperion reporting applications
• Collaborates well with colleagues; Desire to build a strong understanding of the business
• Strong communication and presentation development skills
• Takes initiative to make process improvements and standardize processes

Basic Qualifications:
• Bachelor's degree business, economics, finance, accounting or a related major or equivalent professional experience is required
• Minimum of 7 years of experience in finance, strategy, consulting, or other quantitative function
• Minimum of 7 years of experience working with, or analyzing financial statements

Preferred Qualifications:
• Masters of Business Administration (MBA)
• Experience with financial modeling using Excel
• Experience with Hyperion Planning application
• Experience with SharePoint and Power BI systems
• Highly detail oriented
• Strong oral and written communication skills
• Strong interpersonal skills and team orientation

Hyperion Experience is the must have and Power BI / Sharepoint experience is nice to have.

Screening Requirements:

"SSN Verification
Education Verification (Highest Degree)
Employment Verification (a minimum of 2 employers)
National Criminal Search (7 year history)
Federal Criminal Search (7 year history)
Statewide Criminal Search (7 year history)
Criminal County Search (7 year history)
Office of Foreign Assets Control Check (OFAC)
*MVR searches as may be required for particular roles
MK Denial"
5 Panel (No THC)