Data Specialist - Trumbull, United States - Health Plan One

Health Plan One

Verified Company

Trumbull, United States

2 weeks ago

Posted by:

Mark Lane

beBee recruiter

Description

HealthPlanOne's mission is to help people find the right health insurance at the right price, so they live healthier lives. We are committed to making the shopping process simpler. Our mission has never been more important than it is today.

The Data Specialist will work with a variety of data sources, building and running complex macros to extract reports and information from internal and external platforms for reconciliation.

This role also has responsibility for updating reconciliation results via import templates into internal platforms and working with operations to automate processes that are currently manual.

Duties/Responsibilities:

Create and use complex macros using Excel VBA to identify and update information on internal platform
Perform regular reconciliations and comparisons between internal and external data sets
Assist in evaluating manual processes and locating areas where semiautomation solutions via macros can be created
Collaborate with colleagues to ensure any internal records requiring research and manual updates are completed
Document macro builds and instructions for running macros
Ad hoc reporting

Required Skills/Abilities:

Bachelor's Degree in Computer Science, Information Systems, Applications, or similar degree
24 years of experience creating complex macros for data reconciliation
Advanced Excel knowledge, including building complex macros, VBA, Vlookups and Index/Match, CSV extractions and imports
Experience with Python
Experience with Alteryx
Strong Analytical and communication skills
Dedicated problem solver who proactively identifies issues and offers suggestions towards solutions
Ability to manage priorities and meet deadlines in a dynamic environment
Strong communication and interpersonal skills
Strong organizational skills and meticulous attention to detail

Preferred Skills/Abilities:

Experience working with QuickBase

Physical Requirements:

Prolonged periods of sitting at a desk and working on a computer, typically in a cubicle environment (constant noise, fluorescent overhead lighting)

Equal Employment Opportunity (EEO) is a fundamental principle at HealthPlanOne, where employment is based upon personal capabilities and qualifications. HealthPlanOne does not discriminate because of actual or perceived sex, sexual orientation or preference, gender identity, gender, transgender, race, color, religion, national origin, creed, citizenship status, ancestry, age, marital status, pregnancy, childbirth or related medical conditions, medical conditions including genetic characteristics, mental or physical disability, military and veteran status, or any other protected characteristic as established by law. HealthPlanOne requires the necessary drug testing and background checks as part of our pre-employment practices.

Benefits: