Overview
Remote
Depends on Experience
Full Time
No Travel Required
Skills
P&C
Property and Casulty
insurance
ETL
analyst
enterprise data warehouse
PowerBi
Tableau
SQL Server
entire career in insurance
Job Details
Insurance Company
REMOTE!
Needed ASAP
No C2C
Direct Hire- MUST WORK ON W2 without sponsorship
Entire career MUST BE in insurance- P&C Insurance
Functional Analyst- MUST HAVE P&C Insurance throughout career
About the Role:
We re seeking an experienced Insurance Data & Analytics Consultant to work directly with clients in the insurance sector to design, build, and deliver modern data solutions. In this role, you ll bridge the gap between legacy insurance systems and advanced analytics platforms. Leveraging your deep understanding of P&C insurance and strong technical acumen, you ll support enterprise reporting, analytics, and decision-making processes.
What You ll Do:
- Collaborate with insurance clients to define data and analytics requirements, translating business needs into scalable technical solutions.
- Lead end-to-end data mapping from core systems (Policy, Claims, Billing, Underwriting) to enterprise data warehouses.
- Develop detailed business requirement documents and technical data mapping specifications.
- Build and maintain robust ETL/ELT pipelines using tools such as Azure Data Factory, SSIS, Informatica, or Talend.
- Design and implement dashboards and visualizations in Power BI, Tableau, or other BI platforms to support underwriting, claims, and product teams.
- Validate data accuracy and transformation logic through SQL queries and automated QA frameworks.
- Serve as a subject matter expert on P&C insurance data, ensuring solutions reflect industry nuances and regulatory requirements.
- Facilitate stakeholder meetings and project collaboration using platforms such as Microsoft Teams, JIRA, and Confluence.
- Monitor project progress, proactively flagging data or delivery risks through Azure DevOps or similar project tracking tools.
What You ll Bring:
- 7+ years of experience in the P&C insurance industry, with a strong grasp of core operational domains.
- Proven experience in enterprise data mapping and insurance data integration projects.
- Hands-on expertise with ETL tools and cloud-based data environments (preferably Azure).
- Strong skills in BI/reporting platforms (e.g., Power BI, Tableau, Oracle BI).
- Experience with data profiling, cleansing, and validation practices.
- Proficiency in SQL and a strong understanding of insurance data models.
- Excellent communication and stakeholder management skills.
- Ability to manage projects in fast-paced, agile environments.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.