Find & Apply For Data Warehousing Specialist Jobs in Kansas City, Missouri

Company DescriptionAs a leader in Medicare health insurance distribution, Spring Venture Group guides people through one of their most important life decisions — finding the right insurance coverage. We are on a mission to be the most trusted partner for our customers and our people, enabling empowered decisions along the journey to health and financial well-being. Spring Venture Group offers incredible culture, benefits, and fantastic income potential in a stable and successful work environment at a Medicare agency. This starts with a workplace that empowers people to do their best work. Come build a rewarding career and make a meaningful impact on peoples' lives in an environment that values your determination. Join our diverse, inclusive team and get ready to crush your goals!

Job Description

OVERVIEW

The Data Integrity Specialist Intern is a vital force behind our financial accuracy, working as an integral

member of the team to ensure the completeness and precision of data that drives company revenue. This role demands a keen eye for detail as you maintain the integrity of our CRM system by designing and executing robust quality check routines, performing comprehensive data scrubbing and cleansing operations, and conducting precise manual data inputs.

Furthermore, you will be responsible for actively engaging with insurance carriers to investigate and resolve any discrepancies in payment receipts, a crucial function you'll perform collaboratively within our team to safeguard our revenue calculations and financial reporting. The intern needs to be in the Kansas City area currently and be able to work 40 hours a week.

REPORTS TO

The Data Integrity Specialist reports to the Manager, Data Integrity in the Finance & Accounting

department.

ESSENTIAL DUTIES

As an integral member of the team, the Data Integrity Specialist's core responsibilities include,

but are not limited to:

Managing Multiple Priorities:

Simultaneously oversee and execute various projects and responsibilities, consistently meeting deadlines with keen attention to detail and a proactive approach.

Ensuring Data Security & Compliance:

Diligently perform data management tasks, ensuring all data handling aligns strictly with the company's robust technology security policies and procedures, safeguarding sensitive information.

Daily CRM System Management:

Work actively within the company's CRM system, meticulously updating client records and maintaining data accuracy, often handling focused sets of information.

Generating Critical Reports:

Produce a range of insightful reports for Data Integrity Analysts, utilizing the company's CRM system, various cloud platforms, and external carrier partner websites to identify and highlight known data issues.

Data Issue Resolution:

Actively contribute to the identification, in-depth understanding, and precise correction of complex data discrepancies, ensuring data reliability.

CRM System Expertise & Best Practices:

Develop and maintain a strong, working knowledge of the company's CRM system and its intricate update practices across diverse products, serving as a resource for best practices.

Supporting Audits & Compliance:

Provide essential support for internal document procurement and rate sample testing, critical for both internal and external audit requirements, ensuring regulatory compliance.

Discrepancy Resolution with

Carriers:

Proactively engage with insurance carriers to investigate and resolve any discrepancies in payment receipts, ensuring accurate revenue recognition and maintaining strong partner relationships.

Contributing to

Team Success:

Perform additional duties and responsibilities as assigned, contributing actively to the overall success and efficiency of the data integrity team.

BEHAVIORSThe SVG behaviors are listed below:

Be Aware (Emotional Intelligence)Be Open & Honest (Communication)Be a Team Player (Teamwork and Collaboration)Be Accomplished (Drive for Results)Be the Example (Develop Self & Empower People)Be Forward Thinking (Strategic Thinking)Be a Problem Solver (Continuous Improvement)

QualificationsEducation Requirements:

Currently pursuing or recently completed a Bachelor's degree in Data Analytics, Business Administration, Information Technology, or a related field.

Currently in the Kansas City area and willing to work hybrid in our downtown office on Tuesdays and Thursdays.

Preferred but not required: Experience with Snowflake or Claude in Excel.

Additional InformationCompetitive compensation Medical, Dental and Vision benefits after a short waiting period401k matching programGenerous paid time off program with an additional company break during the holidaysAnnual Volunteer Time Off (VTO) and a donation matching programLife Insurance Employee Assistance Program (health & well-being on and off the job) Rewards and RecognitionMaternity and Parental Leave Training program and ongoing support throughout your entire Spring Venture Group careerDiverse, inclusive & welcoming cultureOptional enrollment options include HSA/FSA, AD&D, Spousal/Dependent life insurance, Short Term/Long Term Disability, Travel Assist, and Legal plansSpring Venture Group is an Equal Opportunity EmployerSpring Venture Group is an Equal Opportunity Employer