Data Analyst

Jencap•New York, NY

1d•Hybrid

About The Position

Jencap is one of the largest wholesale insurance intermediaries in the United States, specializing in wholesale brokerage, binding authority, and program management. The company prides itself on a collaborative and driven team that is empowered to find solutions. Jencap Partners, comprising corporate operations and service teams, supports staff in achieving excellence and exceeding agency partner expectations by providing essential infrastructure, expertise, and services that enable the business to thrive and contribute to the organization's overall success, efficiency, and sustainability. Jencap is seeking a Data Analyst to support insurance data analytics, data warehouse operations, and Azure-based production data pipelines. This role demands strong analytical skills and hands-on experience with Azure Data Factory (ADF), SQL Server, Python, and BI reporting tools, coupled with working knowledge of Data Warehousing and Master Data Management (MDM) concepts within the insurance domain. The successful candidate will be responsible for supporting production jobs, performing data validation, designing ad-hoc scripts, programs, and ETL pipelines, and implementing small production fixes, all while ensuring data quality, reliability, and adherence to enterprise data standards. The Data Analyst will work on a hybrid schedule from Jencap's New York office.

Requirements

Bachelor’s or Master’s degree in Computer Science, Information Technology, Finance, or a related field
5+ years of experience in the Insurance domain, preferably within Brokerage or P&C
Strong understanding of Data Warehousing, Data Lakehouse, and Master Data Management (MDM)
Hands-on experience supporting production environments on Azure Cloud with SQL Server
Apply data warehouse principles, including fact/dimension modeling, historical data management, reconciliations, and data conversions as part of Jenap DWH
Advanced proficiency in SQL (complex queries, joins, stored procedures, indexing)
Strong hands-on experience with Python
Experience with ETL tools such as ADF, SSIS, Informatica, or DataStage
Proficient in MS Excel for data analysis and validation (Pivot Tables, Power Pivot)
Experience using BI reporting tools for data validation and reconciliation
Ability to work independently and deliver results in a fast-paced environment
Hands on experience with API integration
Hands-on experience with version control systems - GitHub

Nice To Haves

Nice to have experience for any Master Data Management tool - Profisee

Responsibilities

The Data Warehouse Data Analyst is a hands-on position with a focus on supporting the data accuracy and completeness within the enterprise data warehouse
The position will work within IT to help Jencap DWH team to maintain the enterprise data warehouse architecture
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 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
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 daily basis
Ability to apply statistical techniques and exploration data analysis using tools such as Python, SQL, or Excel
Track scheduled processes (monthly/daily), coordinate with business divisions on data anomalies or missing data, and support production activities
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
Experience implementing production fixes based on data analysis