Business Analyst - Data Management Solutions

Company Description

We help the world see new possibilities and inspire change for better tomorrows. Our analytic solutions bridge content, data, and analytics to help business, people, and society become stronger, more resilient, and sustainable.

Job Description

If you have a passion for detail and a deep understanding of Statistical Reporting in the P&C industry, this is the opportunity for you. We are expanding our team of business analysts so that we can effectively partner with our clients to understand their policy and claims data and help them transform their bureau reporting processes. We need people who can combine an understanding of data management, regulatory requirements, and client engagement skills to be part of our journey. The Business/Data Analyst will be responsible for providing requirements specification for new and changes to existing regulatory reporting. This includes new requirements from the bureaus and coordinating with the regulatory reporting business unit, application and reporting teams. 

 Responsibilities: 

• Develop a deep understanding of policy, premium, claim and loss data for P&C insurance industry. 
• Work closely with data reporting business units and understand client’s Policy Admin and Claims datasets and able to map this data to internal data warehouse/data model standards. 
• Document client data sources and perform gap analysis to identify data transformation and quality requirements. 
• Work closely with ETL team for implementing data transformation rules, data validations into the data warehouse. 
• Document business requirements, gathering user stories, functional specs, data mapping, wireframe/prototyping, including data migration rules, business rules, wireframes, or other detailed deliverables. 
• Document data sources for client projects and perform gap analysis and develop recommendations and solutions. 
• Coordinate with data reporting teams to understand their requirements and representing them to the data warehousing team 
• Development of test cases, SQL scripts for Unit testing, performance testing  
• Develop industry best practices and solutions for business problems for internal and external stakeholders. 
• Work with business users and leading all testing efforts for Unit, QA and User acceptance testing phase. 

Qualifications

• 5+ years of experience in data architecture and data analysis practice in the P&C Insurance industry 
• 3+ hands-on experience in developing business design specifications, technical design specifications, and developing data validation test cases. 
• 2+ years of hands-on experience in Insurance Data model and able to create/maintain/coordinate business glossaries with project stakeholders. 
• Data Mapping hands-on expertise, able to understand business requirements and derive data dictionary and data requirements. 
• Experience in functional requirement documentation preparation, performing document reviews, and developing data flow diagrams. 
• Experience with any of the tools preferably any two of CA ERWIN, JIRA, Quality Center Test Director, etc. 
• Understanding of ETL tools, able to interact with ETL development team and create source-to-target mapping and technical specifications. 
• Strong SQL is a must and previous experience in any of the databases Oracle, SQL Server, DB2, and Postgres. 
• Experience working both independently and, in a team-oriented, collaborative environment is essential. 
• Excellent communication, both written and verbal, and interpersonal skills and involvement in project scoping, effort estimations, and status reporting. Strong Technical Writing skills 
• Experience in one of the Policy and Claims systems is preferable – Guidewire, Duck Creek, Majesco, etc.  

We are offering an excellent compensation package. Our competitive benefits package includes full health care options, a 401(k) plan, and generous Paid-Time-Off. 

#LI-ZP1

Additional Information

In 2022, Verisk received Great Place to Work® Certification for our outstanding workplace culture for the sixth year in a row and second-time certification in the UK, Spain, and India. We’re also one of the 38 companies on the UK’s Best Workplaces™ list and one of 18 companies on Spain’s Best Workplaces™ list.

For over fifty years and through innovation, interpretation, and professional insight, Verisk has replaced uncertainty with precision to unlock opportunities that deliver significant and demonstrable impact. From our historic roots in risk assessment, we’ve grown to provide analytic insights that help transform industries focused on some of the world’s most critical areas. Today, the insurance industry relies on Verisk to be, and to make the world, more productive, resilient, and sustainable.

Ve