Business Analyst - Data Management Solutions

Company Description

We help the world visualize new prospects and stimulate change for enhanced futures. Our analytical answers act as a link between content, data, and analytics to aid businesses, individuals, and society to become stronger, more adaptable, and sustainable.

Job Description

If you have a passion for detail and a profound knowledge of Statistical Reporting in the P&C field, this is the opportunity for you. We are enlarging our team of business analysts in order to form effective partnerships with our clients to understand their policy and claims data and aid them in transforming their bureau reporting processes. We require people who can combine an understanding of data management, regulatory needs, and client engagement abilities to be part of our journey. The Business/Data Analyst will be responsible for providing requirements specification for new and adaptations to existing regulatory reporting. This includes new necessities 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 the P&C insurance industry.
• Collaborate closely with data reporting business units and understand clients’ Policy Admin and Claims datasets and be able to map this data to internal data warehouse/data model standards.
• Document client data sources and carry out gap analysis to identify data transformation and quality requirements.
• Maintain close interaction with the 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 carry out gap analysis and develop recommendations and solutions.
• Coordinate with data reporting teams to understand their requirements and represent 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 challenges for internal and external stakeholders.
• Work with business users and lead 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, document reviews execution, and data flow diagrams development.
• 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 fundamental 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 report. Strong Technical Writing skills.
• Experience in one of the Policy and Claims systems is preferable – Guidewire, Duck Creek, Majesco, etc.

We offer 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 the Great Place to Work® Certification for our excellent workplace culture for the sixth year in sequence 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 half a century and through innovation, interpretation, and professional insight, Verisk has replaced uncertainty with precision to unlock opportunities that deliver substantial and verifiable impact. From our historical roots in risk assessment, we've expanded to provide analytical insights that help transform industries focused on some of the world's most crucial areas. Today, the insurance industry relies on Verisk to be more productive, resilient, and sustainable.

Verisk collaborates with our customers and operates at the intersection of people, data, and advanced technologies. Through proprietary platform analytics, advanced modeling, and interpretation, we deliver immediate and enduring value to our customers, from the individuals and societies they represent, with increased speed, precision, and scale.

We’re a team of 9,000 individuals committed to transforming big data into big ideas. We aid others in visualizing new possibilities and empowering certainty into significant decisions that impact individuals and societies. We persistently and ethically follow innovation to assist our customers, and the world, in advancing toward better futures.

Every individual at Verisk—from our CEO to our newest employee—follows The Verisk Way, to Be Remarkable, Add Value, and Innovate.

At Verisk you can:
• Be Remarkable by enhancing your skills each day in service to our customers and each other
• Add Value by providing immediate and enduring results that generate positive outcomes
• Innovate by reinventing possibilities, welcoming challenges, and pushing boundaries

Verisk Businesses

Underwriting Solutions — offers underwriting and rating solutions for auto and property, general liability, and excess and surplus to evaluate and price risk with speed and precision

Claims Solutions — supports end-to-end claims handling with analytic and automation tools that streamline workflow, improve claims management, and enhance customer experiences

Property Estimating Solution