Data Integration Analyst I

70,000 - $90,000 Bonus

Vertafore is a leading technology company whose innovative software solution are advancing the insurance industry. Our suite of products provides solutions to our customers that help them better manage their business, boost their productivity and efficiencies, and lower costs while strengthening relationships.

Our mission is to move InsurTech forward by putting people at the heart of the industry. We are leading the way with product innovation, technology partnerships, and focusing on customer success.

Our fast-paced and collaborative environment inspires us to create, think, and challenge each other in ways that make our solutions and our teams better.

We are headquartered in Denver, Colorado, with offices across the U.S., Canada, and India.

JOB DESCRIPTION

We are looking for people who share our drive to achieve excellence in everything we do. In this role, you will be responsible for leading and supporting broker client data onboarding from disparate platforms. You will need to define processes for data-extraction, reconciliation, and identification as well as build automated mapping rules. As a data integration analyst, you will also work with internal client facing teams on broker / carrier analytics and reporting.

Core Requirements and Responsibilities :

Support data setup work for broker onboarding

Define and implement ETL rules for how to load complex insurance data from insurance brokers’ systems into RiskMatch platform

Work with insurance broker subject matter experts to understand their data to support data loading activities

Reconcile and validate loaded data against broker’s financial reports

Analyze broker feed data for exposure data collection

Using SQL and Groovy, migrate and standardize insurance exposure data from broker feed or external data sources into the RiskMatch ODS and Application platform. Validate exposure data against broker supplied Acord Forms where applicable

Perform Data QA on loaded data prior to roll-out, report and resolve findings

Document and troubleshoot data issues, identify possible solutions, communicate and discuss with internal RiskMatch teams for resolution

Maintain data issues log by brokers and track resolution of issues

Perform data analysis by means of data interpretation, and execution of advanced database queries using Tableau, MySQL, Amazon Redshift, Excel, R, Python and other database technologies or programming languages as appropriate. Identify, analyze, and interpret trends, patterns, or insights in result sets

Work independently, or in teams on complex level data gathering, checking, manipulation, analysis, reporting and data quality assurance tasks with minimal supervision

Develop analytical models for reporting and mining insights for business development activities using conventional or visualization tools

Educate broker clients about the functionality of the RiskMatch platform and the importance of data quality within their agency management system

Develop and document rules, integrity and consistency checks

Troubleshoot and recommend solutions to technical problems

As needed, support client reporting, or data extract work

Perform other duties as the company evolves

Knowledge, Skills and Abilities :

MySQL, Amazon Redshift SQL

Advanced Microsoft Excel

Familiarity with ETL processes

Strong communication and problem-solving skills

A positive attitude and the ability to work with external clients as required

Qualifications :

ETL and hands-on SQL experience required

Working knowledge of Excel required

Experience with interactive data visualization tool, e.g. Tableau, preferred

Experience with Groovy, or any other scripting language, preferred

Property & Casualty Insurance knowledge, preferred

Experience working with Agency Management Systems, preferred

Experience with Python, preferred

THE VERTAFORE STORY

Over the past 50 years, Vertafore has advanced the entire insurance distribution channel with the best software solutions in the industry. Today, we’re proud to say hundreds of thousands of Vertafore users rely on our solutions to write business faster, reduce costs, and fuel growth by increasing collaboration and streamlining processes. Vertafore leads the industry with secure, cloud-based mobile products that provide superior reporting and analytics, delivering actionable insight— right when customers need it most. We partner with other leading technology companies to deliver comprehensive solutions to improve the way our customers do business and serve their customers.

The Vertafore Way

Insurance is about relationships, and technology should make those relationships stronger. That’s why, at Vertafore, it’s our mission to transform the way the industry operates by putting people at the heart of insurance technology. By focusing on our customers, becoming better every day, and delivering results you can see, we provide the level of trust and security that insurance is all about.

• Bias to Action : We're united by an innate drive to take action and make a difference in the technology and insurance spaces.
• Win Together : We work together as one team, showing empathy and respect along the way.
• Show Up Curious : We work to challenge one another to push boundaries and think beyond the box.
• Say It, Do It : We honor every one of our commitments because integrity is important to us.
• Customer Success is Our Success : We cultivate authentic relationships and follow up by actively listening to their needs.
• We Love Insurance : We appreciate the impact insurance has on the world.

Is this role not an exact fit for you? Keep an eye on our Careers Page for other positions!

Vertafore is a drug free workplace and conducts preemployment drug and background screenings .

The selected candidate must be legally authorized to work in the United States.

The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all the job responsibilities, duties, skill, or working conditions. In addition, this document does not create an employment contract, implied or otherwise, other than an "at will" relationship.

Vertafore strongly supports equal employment opportunity for all applicants regardless of race, color, religion, sex, gender identity, pregnancy, national origin, ancestry, citizenship, age, marital status, physical disability, mental disability, medical condition, sexual orientation, genetic information, or any other characteristic protected by state or federal law.

We do not accept resumes from agencies, headhunters, or other suppliers who have not signed a formal agreement with us.

Vertafore is a Flexible First working environment which allows team members to work from home as often as you’d like, while using our offices as a place for collaboration, community, and teambuilding. There are times you may be asked to come into an office and / or travel for specific meetings for a specific business purpose and this varies by job responsibilities.

Salary : $70,000 - $90,000