Job Information
Colorado State Job Bank Principal Financial Analyst in Lafayette, Colorado
Principal Financial Analyst for Medtronic, Inc., located in Lafayette, CO. Responsible for monthly and quarterly financial forecasting for the Neurosurgery/Enabling Technologies (ET) business. Responsible for collaborating with functional leaders to develop and communicate financial forecast risks and opportunities and ensure forecast and targets are understood. Responsible for financial mgmt. & modeling of business initiatives, developing annual operating plan, cost control, monthly forecasting, financial planning, and investment analysis. Conduct financial audit of internal financial reports across multiple financial sources to ensure data integrity. Conduct headcount analysis and projections to ensure alignment with business goals, project requirements and budgetary constraints. Collaborate with senior leadership to provide actionable insights and drive financial performance. Develop and maintain advanced financial models to evaluate business initiatives, track performance, and project outcomes by leveraging formulas including Power Query, Dynamic Array Formulas, Advanced Data Analysis, and Logical/Conditional Formulas. Create Excel dashboards with graphs and Key Performance Indicators (KPIs) and using Power BI, Enterprise Resource Planning (ERP) Systems onboarding, implementation and ongoing usage. Follow GAAP (Generally Accepted Accounting Principles). Deliver financial analytics and projections of revenue, Profit & Loss (P&L) and KPIs using advanced modeling and Return On Investment (ROI) calculations on new initiatives to support business growth and inform leadership of investment decisions. Leverage financial knowledge from experience in the Medical Technology industry with surgical robotics. *Position works a hybrid model and will be onsite in Lafayette, CO -- 4 days per week.
Minimum Requirements:
Masters' Degree or foreign equivalent in Economics, Accounting, Math, Statistics or related financial field and five (5) years of experience as a Financial Analyst or related occupation. Must possess at least five (5) years' experience with each of the following:
1- Financial mgmt. and modeling for large-scale technology projects, including cost control, financial forecasting, financial planning, and investment analysis.
2- Reviewing and verifying internal financial reports from multiple sources
3- Conducting headcount analyses to align business need with financial targets.
4- Presenting financial insights to executive leadership and cross-functional teams.
5- Financial modeling in Microsoft Excel using advanced formulas including Power Query, Dynamic Array Formulas, Advanced Data Analysis, and Logical/Conditional Formulas.
6- Creating Excel dashboards with graphs and KPIs and using Power BI, ERP Systems onboarding, implementation and ongoing usage.
7- GAAP
8- Conducting financial analytics through projections of revenue, P&L and KPIs using advanced modeling and ROI calculations.
Must possess at least two (2) years' experience with Financial Medical Technology industry with surgical robotics.The position is located at Medtronic, Inc., 250 Medtronic Dr., Bldg. 1, Lafayette, CO 80026.