What are we looking for?
Columbia Insurance Group is searching for an experienced Data Analyst who is a self-starter and thrives in a flexible work environment. You will be providing an advanced level of programming, analyzation, and mapping of data in our systems.
Who we are and what we do?
Here at Columbia Insurance Group, we believe that our employees are our greatest asset. Which is why our robust employee benefits and fun, family-like culture is something we pride ourselves on. Our commitment to our mission revolves around building and maintaining enduring relationships with our customers, and the only way to achieve that is by bringing together a team of skilled, passionate, and talented individuals.
Why us?
- Medical, Dental, and Vision coverage
- 401(k) and company match
- Generous paid time off (PTO), paid company holidays, paid maternity/paternity leave, and supplemental sick leave
- Family-like culture
- Year-round wellness initiatives
- Company sponsored events
- Opportunities for professional development with conferences, events, and continued education.
Company History
Our legacy has roots back to 1889 when we first became part of the mutual insurance movement in the Midwest. Today, our extensive heritage resonates nationwide, as we proudly serve customers in 14 states across the country.
ESSENTIAL FUNCTIONS
- Lead database design, data collection, data analysis/comparison and data conversion in applications to be utilized by CIG.
- Communicate with the appropriate internal and external personnel to understand their operational data needs and objectives; deliver actionable insights from the operational data
- Lead end-to-end data migration and reporting efforts between systems and in developing supporting documentation for data migration projects.
- Define and document data verification criteria and ensure quality of all data conversion work.
- Assist in the development and application of data architectural strategy.
- Identify and retrieve information from various data sources and organizes it to create meaningful data visualizations for understanding, operational reporting and decision making.
- Drive the development of processes supporting automation of the data extraction process, verification of data, data reconciliation and reporting.
- Manage and optimize database inquiries for optimal end-user experience.
- Analyze and advise management of workflow and data integrity issues; present resolution recommendations.
- Identify, manage, troubleshoot and resolve database and data structure issues.
- Support existing integrations and assist in development/setup of new integrations.
- Other duties as assigned.
Required Qualifications
- Three years of data analysis experience
- Excellent communication and customer service skills
- SQL programming and query expertise
- Experience in dashboarding, reporting, visualizations, data modeling and migration between enterprise systems
EDUCATION QUALIFICATIONS
- Bachelor's degree required in Applied Math, Statistics, Computer Science or other related technical field
EOE
If you are unable to complete the electronic application for any reason, please contact Mandi: mgiboney@colinsgrp.com