Data Specialist
Healthplanone

Job Info

---

HealthPlanOne'smission 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)

Due to the unprecedented situation of COVID-19, HPOne has decided to protect our current and future employees by managing our business remotely. This is inclusive of interviewing, training, and day-to-day operations. We will be returning to an office setting once we are safe to do so following the guidance of local health authorities' and the CDC. Currently all employees are working remotely. 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 HPOne, where employment is based upon personal capabilities and qualifications. HPOne 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. HPOne 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 accommodations@hpone.com

This job has expired.