200+ applicants
Jencap · 6 days ago
Business Intelligence & Analytics Associate
New York, NY
Full-time
Hybrid
Entry, Mid Level
$95K/yr - $105K/yr
5+ years exp
Wonder how qualified you are to the job?
Maximize your interview chancesFinancial ServicesInsurance
Insider Connection @Jencap
Responsibilities
The Business Intelligence & Analytics role will require a person who has proficiency in analytical approach for insurance data, thoughtful analyses & reporting initiatives that translate into solutions that support the corporate strategy and manage BI solutions
Analyze wide variety of Insurance data for multiple divisions and consolidate data as single source of truth – Master Data Management
Create and maintain documentation, including requirements, design and functional documentation
Identify opportunities to improve processes and strategies with technology solutions
Prep, ingest, cleanse, scrub, maintain and validate data in the data warehouses
Helps to keep track of monthly process execution, coordinate with respective divisions to data anomaly or missing data
Lead cross-functional analytical efforts to help shape the Jencap Enterprise Data Warehouse
Create high quality deliverables based on in depth analytics that provide visual storytelling with supporting details for management at various levels
Capable of creating Ad Hoc ETL process or programs for in-house projects using SSIS, Azure Data Factory is plus
Meet with stakeholders to gather requirements and make recommendations on reporting/BI solutions
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
College Degree (Masters/BA/BS) in Computer Science, Information Technology, Finance or similar area
5+ years overall experience in Insurance domain - knowledge preferably Brokerage, P&C
Experience on Data Conversion and Migration technologies
Proficient in MS Excel – Data Analysis, Data Validation and Visualization tools/functions – Pivot table, Power Pivot etc
Proficient for BI Reporting tool - Power BI, DAX
Strong hands-on SQL Experience – SQL Server
Expert in Python programming
Expert in ETL tool (ADF, SSIS, Informatica, DataStage)
Working knowledge of data lake, data warehouse, big data concepts and terminology
Working knowledge of cloud environment - Azure Cloud environments preferred
Experience of any ETL tool (ADF, SSIS, Informatica, DataStage)
Ability to work independently and proactively deliver business results in a timely fashion
Self-motivated and able to work independently
Quick learner and ability to accept rapid changes
Excellent analytical, problem-solving skills and communication/presentation skills with proficiency in Excel and PowerPoint
Strong interpersonal collaboration, written/verbal communication and team skills working with cross-functional teams
Ability to multi-task and manage competing deadlines
Preferred
Capable of creating Ad Hoc ETL process or programs for in-house projects using SSIS, Azure Data Factory is plus
Benefits
Comprehensive health care coverage
Tuition reimbursement
Company
Jencap
Jencap comprises ten industry-leading insurance brands that provide unique specialization, unparalleled market access, and nationwide influence.
501-1,000 employees
Funding
Current Stage
Late StageLeadership Team
David L. Nielsen
CFO
Maria Hurley
Senior Vice President of Human Resources
Recent News
Insurance Journal
2024-01-28
Company data provided by crunchbase
