Data Analyst – Insurance Industry

Jencap

. Perform data analysis and validation on insurance data, including policy, claims, customer, premium, and transaction data .

Posted 11/3/2026full-timeSummit • New Jersey • United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Data Analysis, ETL Development, and Data Warehousing, with a strong focus on using Azure Cloud Resources and Databricks. Proficient in SQL and Python for data validation and reconciliation, while effectively collaborating with cross-functional teams to enhance data quality and support decision-making.

Highest-signal resume keywords

Data AnalysisETL DevelopmentAzure Data FactoryDatabricks PlatformMaster Data Management

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonData WarehousingData LakehouseAPI IntegrationBI Reporting ToolsAd-Hoc ETL ProcessesData ValidationRoot Cause AnalysisTechnical Documentation

Soft Skills

Analytical SkillsProblem-SolvingCommunication SkillsCollaborationInterpersonal Skills

Tools & Technologies

Azure Cloud ResourcesSQL ServerProfiseePower BITableauSSRSGitHubAzure Blob Storage

Industry Keywords

Insurance IndustryData QualityMaster Data ManagementData ProcessesAnalytics Solutions

Tech Stack

Tools & technologies

AzureCloudETLPythonSQLTableau

About the role

Key responsibilities & impact

Perform data analysis and validation on insurance data, including policy, claims, customer, premium, and transaction data
Extract data from multiple sources and address data gaps across domains to improve data quality
Support and maintain data warehouse and production ETL pipelines using Databricks, Azure Data Factory, SQL Server, and Azure Blob Storage
Support Master Data Management initiatives on the Profisee platform
Use BI reporting tools such as Power BI, SSRS, or Tableau to validate data, perform source-to-target reconciliation, and support operational and business validation checks
Design and develop ad-hoc ETL processes using Azure Data Factory and Python for analytics, fixes, and enhancements
Monitor production jobs, troubleshoot failures, and perform root cause analysis
Create and maintain technical and functional documentation
Identify opportunities to improve data processes and analytics solutions
Deliver analytical outputs and visual storytelling to support management decision-making
Collaborate with senior engineers, analysts, and business stakeholders on enterprise data initiatives

Requirements

What you’ll need

Bachelor’s or Master’s degree in Computer Science, Information Technology, Finance, or a related field
5+ years of experience in the Insurance Industry highly preferred
5+ years of experience with Data Warehousing, Data Lakehouse, and Master Data Management (MDM)
5+ years of experience with Databricks platform
5+ years of experience with Azure Cloud Resources with SQL Server
2+ years of experience with MDM tool – Profisee preferred
Advanced proficiency in SQL (complex queries, joins, stored procedures, indexing) and Python
Experience using BI reporting tools for data validation and reconciliation or Tableau
Hands-on experience with API integration
Hands-on experience with version control systems - GitHub
Strong analytical, problem-solving, and communication skills
Excellent collaboration and interpersonal skills across cross-functional teams
Ability to manage multiple priorities and competing deadlines
Ability to work in a fast-paced, work-intensive organization and adapt to changing priorities while delivering with high accuracy
Work authorization that does not require employer visa sponsorship now or in the future

Benefits

Comp & perks

Discretionary incentive compensation may be awarded
Comprehensive health care coverage
401k plan
Tuition reimbursement