We are hiring a Financial Analyst for our client, a global animal health pharmaceutical company. They offer innovative solutions to veterinarians, farmers, and animal owners in over 100 countries worldwide.
The Financial Analyst is finance-savyy with strong modeling skills to drive data-backed decision-making and support planning, forecasting, and performance management across the North America region.
This role reports to the Head of Business Planning and works closely with FP&A, Sales, and Marketing.
Key Responsibilities:
1. Financial Modeling & Analysis
- Build and maintain automated, dynamic models (3-statement, ROI, scenario) in Excel.
- Analyze promotions, rebates, and sales initiatives; deliver post-mortem and forward-looking insights.
- Extract and process data via SQL; automate reports with PivotTables, PowerQuery, VBA.
- Develop PowerBI dashboards using Data Models and DAX for real-time performance insights.
2. Planning Cycle Management
- Support all phases of the budget and forecast process.
- Partner with contributors to develop expense and sales projections.
- Lead revenue modeling by SKU and pricing assumptions.
- Ensure timely, accurate data inputs in planning systems.
3. Monthly Business Reviews & OPEX Tracking
- Conduct monthly financial reviews with corporate functions.
- Monitor trends, identify risks, and align spend with strategic goals.
- Maintain OPEX reports and system uploads (EPIMS).
4. Financial Systems & Reporting
- Oversee PowerBI and IBA reporting tools and master data integrity.
- Validate ERP data integration with IT.
- Deliver standard and ad hoc reports; support and train users.
Key Qualifications:
- Bachelor’s in Finance or Business
- +4 years of experience in general ledger, financial analysis, financial planning and budgeting.
- Excel proficiency – PivotTables, PowerQuery, VBA, fully automated and dynamic modeling
- Advanced Excel modeling (VBA, PowerQuery, 3-statement models)
- PowerBI and DAX proficiency
- SQL and financial systems experience
- Track record in budgeting, forecasting, and cross-functional collaboration
- Strong communication and data presentation skills