Our Client is one of the United States’ largest insurers, providing a wide range of insurance and financial services products with gross written premiums well over US$25 Billion (P&C). They proudly serve more than 10 million U.S. households with more than 19 million individual policies across all 50 states through the efforts of over 48,000 exclusive and independent agents and nearly 18,500 employees. Finally, our Client is part of one the largest Insurance Groups in the world.
Role Description:
The primary focus of this role will be to build and maintain reports and dashboards in PowerBI to support the FWS sales and marketing stakeholders. The Marketing Data Analyst will work closely with sales, brand and performance media teams, the Farmers.com team, the FFQ online quote platform team, the Direct Sales team, and the Customer Experience team. This position is key to ensuring that data-driven insights are effectively communicated to support marketing strategies and decision-making.
- Responsible for supporting Marketing's objectives for acquisition, retention, cross-selling, and profitability by identifying, designing and implementing advanced analytic projects.
- Leads market analytics team projects. Implements local market planning and analysis.
- Leverages customer information such as transactional and behavioral data, demographic and attitudinal overlays, and primary and secondary research to make business decisions regarding product development, marketing investments, competitive intelligence and other functional areas.
- Assists with and/or leads a multitude of diverse projects ranging from Local Market Planning, Agency and Customer Segmentation to deriving actionable rules for trigger based marketing campaigns.
- Serves as a key subject matter expert in marketing analytics.
- Leads key marketing analytics projects.
- Provides feedback and insight on assignments while assisting with material analysis. Leads and assists with implementing local market planning development, analysis and execution. Performs competitive intelligence research and analysis leveraging internal and external data.
- Partners with marketing and planning to support strategic initiatives and its impact of customer marketing.
- Understands and ensures collaboration with use of database analysis for devising business strategy.
- Delivers actionable program measurement and drives marketing tactics and strategy through data analytics.
- Understands and prioritizes analytical needs to deliver solutions and drive implementation.
- Builds and enhances processes that provide systematic measurement of Marketing initiatives.
- Develops actionable measurement of marketing programs that drive follow- up strategy and tactics.
- Provides quantitative analyses and statistical modeling that impact strategic decision-making.
- Utilizes the database to surface relevant analysis and opportunities to support client's key business objectives.
- Provides tactical marketing and analysis support to internal customers including: extensive customer profiling, segmentation, customer lifetime value analysis, response and attrition models, holistic customer business views, in-depth campaign assessment and local market opportunity, planning and analysis.
- Serves as a team member on complex, strategic analysis projects ensuring high quality deliverables and relevant recommendations.
- Identifies opportunities to generate revenue and cut costs by identifying potential new markets, monitoring customer shifts, purchasing patterns, etc.
- Outlines and defines analytic approach for client needs including pre and post-campaign analysis, measuring and analyzing response to marketing offers and making recommendations for enhancements to campaign strategy.
- Summarizes analytical data into user-friendly reports translating highly technical, detailed data into recommendations for marketing execution. Performs other functions as assigned.
Requirements
Other Critical Skills
Data Analysis - Intermediate
Reporting - Intermediate
Collaborating with Stakeholders - Intermediate
Critical Thinking - Entry Level
Data Visualization - Intermediate
Presentation Skills - Entry Level
Software / Tool Skills
SQL - Intermediate (4-6 Years)
Power BI - Intermediate (4-6 Years)
dbt - Entry Level (1-3 Years)
Python / R - Entry Level (1-3 Years)
English Proficiency
- Minimum Required: Fluent
Required Education
- Minimum Required: Bachelor
Benefits
This position comes with competitive compensation and benefits package:
- Competitive salary and performance-based bonuses
- Comprehensive benefits package
- Career development and training opportunities
- Dynamic and inclusive work culture within a globally renowned group
- Private Health and Dental Insurance
- Pension Plan
- Meals tickets
- Life Insurance
About Capgemini
Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of over 340,000 team members in more than 50 countries. With its strong 55-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group €22.5 billion in revenues in 2023.
https://www.capgemini.com/us-en/about-us/who-we-are/
