Data Specialist

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 semi-automation 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
• 2-4 years of experience creating complex macros for data reconciliation
• Advanced Excel knowledge, including building complex macros, VBA, V-lookups and Index/Match, CSV extractions and imports
• Experience with Python
• 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)

Our centers are consistent with CDC guidelines and align with local government orders pertaining to all Company physical locations in relation to COVID-19.

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. If you need assistance or an accommodation due to a disability, please contact us to request accommodation at [email protected]