Data Analyst-Insurance Industry-Hybrid

Jencap•Summit, NJ

1d•Onsite

About The Position

The Data Warehouse Data Analyst supports insurance data analytics, data warehouse operations, and Azure-Databricks-based production data pipelines. The role uses Azure Databricks, Azure Data Factory (ADF), SQL Server, Python, and BI reporting tools, alongside knowledge of data warehousing and Master Data Management (MDM) concepts in the insurance industry. The analyst supports production jobs, validates data, designs ad-hoc scripts, programs, and ETL pipelines, and implements small production fixes while maintaining data quality, reliability, and alignment with enterprise data standards. This role is based in Jencap’s Summit, New Jersey office and follows an in-office schedule. The analyst collaborates with engineers, analysts, and business stakeholders to support enterprise data initiatives and deliver analytical outputs for management decision-making.

Requirements

Bachelor’s or Master’s degree in Computer Science, Information Technology, Finance, or a related field.
Five or more years of experience in the insurance industry is highly preferred.
Five or more years of experience with data warehousing, data lakehouse, and MDM.
Five or more years of experience with the Databricks platform.
Five or more years of experience with Azure cloud resources and SQL Server.
Two or more years of experience with an MDM tool; Profisee is preferred.
Advanced proficiency in SQL, including complex queries, joins, stored procedures, and indexing, and in 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 such as 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 adapt to changing priorities in a fast-paced, work-intensive organization while delivering with high accuracy.
Work authorization that does not require employer visa sponsorship now or in the future.

Nice To Haves

Five or more years of experience in the insurance industry.
Experience with the Profisee MDM platform.
Experience with BI reporting tools such as Power BI, SSRS, or Tableau.

Responsibilities

Perform analysis and validation of insurance policy, claims, customer, premium, and transaction data.
Extract data from multiple sources to support analytics projects and address data gaps across domains to improve data quality.
Support and maintain data warehouse and production ETL pipelines built with Databricks, Azure Data Factory, SQL Server, and Azure Blob Storage.
Support MDM initiatives by ensuring data consistency, standardization, consolidation, and reference-data validation on the Profisee platform.
Use BI reporting tools to validate data accuracy and completeness, perform source-to-target reconciliation, and 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.
Monitor production jobs, troubleshoot failures, and perform root-cause analysis.
Create and maintain technical and functional documentation, including requirements, designs, and process flows.
Identify opportunities to improve data processes and analytics solutions using technology.
Deliver analytical outputs and visual storytelling to support management decision-making.
Collaborate with senior engineers, analysts, business stakeholders, and other cross-functional teams on enterprise data initiatives.