Data Integration Analyst I at Vertafore (Greater Denver Area, CO)

| Greater Denver Area
Sorry, this job was removed at 11:28 a.m. (MST) on Monday, January 31, 2022
Find out who's hiring in Greater Denver Area.
See all Data + Analytics jobs in Greater Denver Area
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Vertafore is a leading technology company whose innovative software solutions are advancing the insurance industry. Our suite of products provides solutions to our customers that help them better manage their businesses, 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.

 

Core Requirements and Responsibilities:

Lead and/or Support broker client data onboarding from disparate platforms, defining processes for data-extraction, reconciliation, and identification and development of automated mapping rules 

  • 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

Work with internal client facing teams on broker/carrier analytics and reporting 

  • 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 data gathering, checking, manipulation, analysis, reporting and 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, and 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 

 

Qualifications:

  • ETL and hands-on SQL experience. You must have written and executed complex multi-table joins and sub-queries in SQL.
  • Working knowledge of Excel. You must be able to manipulate data using Excel to troubleshoot data discrepancies.
  • Experience with interactive data visualization tool e.g. Tableau, a plus 
  • Strong communication and problem solving skills, a positive attitude and the ability to work with external clients as required 
  • Nice to have: experience with Groovy, or any other scripting language 
  • Nice to have: Property & Casualty Insurance experience 
  • Huge plus: experience working with Agency Management Systems such as Applied's EPIC/TAM, or Vertafore's Sagitta/AMS360 

 

Additional Requirements and Details: *US only, include travel requirement for all locations if applicable. 

  • Travel required up to 10% of the time. 

  • Located and working from an office location. 

  • Occasional lifting and/or moving up to 10 pounds.

  • Frequent repetitive hand and arm movements required to operate a computer.

  • Specific vision abilities required by this job include close vision (working on a computer, etc.). 

  • Frequent sitting and/or standing.

 

*We are currently working remotely due to COVID19.

 

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.

Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • SqlLanguages
    • ReactLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • AWS (Amazon Web Services)Frameworks

Location

Great location in the heart of downtown Denver just a block away from the RTD lightrail.

What are Vertafore Perks + Benefits

Culture
Volunteer in local community
Vertafore offers employees 1 paid day to volunteer at the non-profit of their choice.
Friends outside of work
Eat lunch together
Intracompany committees
Vertafore offers opportunities to join several committees, including Women of Vertafore, LGBTQ+, etc.
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Highly diverse management team
Unconscious bias training
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Vertafore employees can contribute up to $2750 annually to their FSA.
Disability Insurance
Disability insurance covers 100% of annual salary for up to 90 days of disability.
Dental Benefits
Our dental plan covers $1500 of expenses per person.
Vision Benefits
The vision benefits plan covers 100% for annual eye exams with $175 for glasses or contact lenses.
Health Insurance Benefits
Vertafore offers three different health plans to meet the needs of our employees.
Life Insurance
Pet Insurance
We offer a Pet Insurance plan through Nationwide.
Wellness Programs
Onsite Gym
Team workouts
Vertafore's team fitness initiatives include in-office yoga, a partnership with Planet Fitness, and other recreational team sports.
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Vertafore provides employees with a 401(k) matching plan managed by [provider]. We match up to 50% of contributions up to 3% of an employee's annual gross pay.
Employee Stock Purchase Plan
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Vertafore provides up to 6 weeks of parental leave for the primary caretaker. We also provide 6 weeks of leave for the secondary caretaker.
Family Medical Leave
Adoption Assistance
We reimburse up to $2,500 for eligible adoption expenses and 6 weeks of paid leave.
Company sponsored family events
Vertafore sponsors family oriented events semi-annually.
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Vertafore hosts company outings annually.
Game Room
Stocked Kitchen
In various areas of the office, Vertafore provides weekly fresh fruit services, bagels and donuts on specified days, as well as snacks and drinks.
Some Meals Provided
We provide free breakfast on Mondays and Fridays.
Happy Hours
Recreational Clubs
Vertafore sponsors recreational clubs that include sports, board games, video games, book clubs, etc.
Home Office Stipend for Remote Employees
Professional Development Benefits
Tuition Reimbursement
Our tuition reimbursement plan offers an annual max of $5,250.
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Vertafore's mentorship framework is an independently led experience between a mentee and a mentor. Resources are ongoingly provided to start this relationship and keep it successful & valuable.
Online course subscriptions available

Additional Perks + Benefits

We felt like the stretch of no three day weekends from Feb - May was too long, so we added our own holiday! We celebrate Vertafore Rest and Recharge day in April, and the whole company has a long weekend.

More Jobs at Vertafore

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Vertafore's full profileSee more Vertafore jobs