FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in financial planning, performance analysis, and data preparation, with strong capabilities in using Python, SQL, and advanced Excel for data manipulation and reporting. Proficient in creating executive reports and managing portfolio governance routines while ensuring data consistency and accuracy.
Highest-signal resume keywords
Financial PlanningPerformance AnalysisAdvanced Excel SkillsPython ProgrammingSQL Data Manipulation
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Financial PlanningPerformance AnalysisData PreparationAdvanced ExcelPythonSQLPower QueryData ExtractionData ManipulationScenario Modeling
Tools & Technologies
Power BIVisualization ToolsDashboardsSimulators
Industry Keywords
Insurance MarketAuto InsuranceMass-Market InsurancePortfolio Governance
Tech Stack
Tools & technologiesPythonSQL
About the role
Key responsibilities & impact- Update projections and forecasts and support the preparation of the annual budget by portfolio, distribution channel, and region
- Consolidate monthly portfolio performance close results, analyzing variances, identifying root causes, explanatory hypotheses, and areas requiring attention
- Model scenarios and sensitivities based on agreed assumptions, analyzing impacts and flagging inconsistencies or risks
- Identify areas requiring attention and opportunities to improve efficiency in managing business line items
- Prepare inputs, charts, and tables for committee materials and executive reports
- Manage the delivery calendar, meeting minutes, and action plans for portfolio governance routines
- Keep documentation of assumptions, data sources, and methodologies up to date
- Extract portfolio data and correlate it with internal and external information, ensuring consistency with official sources
- Use and recommend improvements to internally developed dashboards and simulators
- Automate recurring consolidation and reporting routines using Python, SQL, and/or Power Query
- Collaborate with tariff monitoring, FP&A, pricing, claims, and product teams to collect information, reconcile figures, and clarify assumptions
- Support analyses requested by portfolio leadership
Requirements
What you’ll need- Bachelor’s degree in Actuarial Science, Statistics, Economics, Engineering, Business Administration, Mathematics, or a related field (required)
- Experience in financial planning, controllership, performance analysis, and data preparation (required)
- Experience in the insurance market, especially auto and/or mass-market insurance (a plus)
- Advanced Excel skills—including pivot tables, complex formulas, and Power Query (required)
- Knowledge of Python, SQL, and/or SAS for data extraction and manipulation (preferred)
- Knowledge of Power BI and/or a similar visualization tool (a plus)
- Intermediate English proficiency (preferred)
Benefits
Comp & perks- Flexible working hours
- Medical and dental insurance
- Wellhub
- Transportation allowance or company shuttle
- Meal and food allowance
- Private pension plan
- Profit-sharing bonus
- Birthday day off
- Discounts on HDI Group products
- Nanny or daycare allowance
- Life insurance