Analyst, Modeling and Analytics
Johnson & Johnson, Inc.
About the Role
This role is a member of the Modeling & Analytics team, structured as a shared service. It involves performing catastrophe modeling, building net-new predictive/statistical modeling capabilities, and owning the ongoing build-out and maintenance of the group's Qlik/BI reporting technology. The ideal candidate is analytically strong, comfortable learning across disciplines, and motivated to grow the team's modeling and data-platform capabilities.
Key Responsibilities
CAT Modeling
- Utilize catastrophe modeling software (e.g., RMS, AIR) to conduct analyses of catastrophe risks impacting the property portfolio.
- Contribute to the evaluation and quantification of catastrophe risk, supporting underwriting strategy and decision-making.
- Validate and refine catastrophe models and data cleansing processes.
- Contribute to building out J&J's view of risk.
- Analyze claims data to identify trends that improve underwriting and modeling accuracy.
- Stay informed on emerging trends and advancements in catastrophe modeling.
Predictive Modeling & Statistical Analysis
- Develop and grow predictive modeling capability for the team.
- Maintain and enhance risk-based pricing predictive models for Personal Lines.
- Apply statistical techniques to analyze portfolio performance, rate adequacy, and aggregate utilization.
- Build models that support underwriting and pricing decisions across Personal Lines and Commercial Lines.
- Partner to identify use cases where predictive/statistical modeling can improve decision-making and portfolio strategy.
- Stay current on predictive modeling methods and tools.
BI / Data Platform (Qlik)
- Own the ongoing build-out, maintenance, and enhancement of the team's Qlik/BI environment, including sourcing and structuring data.
- Build and maintain Qlik/BI applications, dashboards, and reports.
- Partner with stakeholders to ensure BI tools remain valuable and relevant, and translate new reporting needs into BI solutions.
- Maintain data integrity across the platform and refine the data pipeline.
Requirements & Tech Stack
Education and Work Experience
- 0-5 years of experience in insurance, data analysis, or a related analytical field; insurance experience preferred but not required.
- Bachelor's degree in Statistics, Mathematics, Risk Management, Data Science, Actuarial Science, or a related field.
- Proficiency in statistical analysis and data manipulation, with advanced Excel skills.
- Experience with SQL, VBA, R, or other data/programming languages preferred.
- Experience with BI technology such as Qlik, Tableau, or Power BI strongly preferred.
- Exposure to catastrophe modeling software (e.g., RMS, AIR) a plus.
- Excellent communication skills and the ability to collaborate effectively with cross-functional teams.
- Legal authorization to work in the United States.
Knowledge, Skills & Abilities
- Strong analytical skills and attention to detail.
- Ability to learn quickly across multiple disciplines, including CAT modeling, predictive/statistical modeling, and BI platform development.
- Comfort working on ambiguous, developing initiatives.
- Exceptional time management skills and ability to prioritize tasks effectively.
- Strong interpersonal skills and ability to communicate complex findings.
- Adaptability to changing priorities.