Data Analyst-Insurance Industry-Hybrid

Jencap•Summit, NJ

1d•Hybrid

About The Position

Jencap is a leading wholesale insurance intermediary in the United States, specializing in wholesale brokerage, binding authority, and program management. The company prides itself on its collaborative and driven team, empowering employees to find solutions and fostering a passion for teamwork, collaboration, and individual growth. The Data Warehouse - Data Analyst role supports insurance data analytics, data warehouse operations, and Azure-Databricks based production data pipelines. This position requires strong analytical skills and hands-on experience with Azure Databricks, Azure Data Factory (ADF), SQL Server, Python, and BI reporting tools. A working knowledge of Data Warehousing and Master Data Management (MDM) concepts within the insurance industry is also necessary. The candidate will be responsible for supporting production jobs, performing data validation, designing ad-hoc scripts, programs, and ETL pipelines, and implementing small production fixes while ensuring data quality, reliability, and adherence to enterprise data standards. The role operates on a Hybrid Schedule in the Summit, NJ offices.

Requirements

Bachelor’s or Master’s degree in Computer Science, Information Technology, Finance, or a related field
5+ years of experience in the Insurance Industry preferred, not required
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 fast-paced, work-intensive organization and be able to adapt to changing priorities while delivering with high accuracy
Candidates must have work authorization that does not require employer visa sponsorship now or in the future.

Nice To Haves

Insurance Industry experience

Responsibilities

Perform data analysis and validation on insurance data including policy, claims, customer, premium, and transaction data
Extract data from multiple sources/systems to support larger analytics projects and initiatives, Address data gaps across various domains to enhance overall data quality.
Support and maintain data warehouse and production ETL pipelines built using Databricks, Azure Data Factory (ADF), SQL Server, and Azure Blob Storage
Support Master Data Management (MDM) initiatives by ensuring data consistency, standardization, consolidation, and reference data validation on Profisee platform
Use BI reporting tools (Power BI, SSRS, Tableau, or similar) to: Validate data accuracy and completeness, Perform source-to-target reconciliation, Support operational and business validation checks
Design and develop ad-hoc ETL processes using ADF and Python for analytics, fixes, and enhancements as part of production support activities
Monitor production jobs, troubleshoot failures, and perform root cause analysis
Create and maintain technical and functional documentation (requirements, design, process flows)
Identify opportunities to improve data processes and analytics solutions using technology
Deliver high-quality analytical outputs and visual storytelling to support management decision-making
Collaborate with cross-functional teams, including senior engineers, analysts, and business stakeholders, to support enterprise data initiatives