Description

The Data Engineer will support our efforts to integrate, validate, enrich, and aggregate healthcare data for use by our analysts and data scientists. You’ll help find new and useful sources of information and lead the charge to go get it and make sure we can keep this data up to date over time. You will also help ensure this data is translated to the rest of the analytics teams in a useable format. You will be expected to master the intricacies of efficiently acquiring large amounts of data from various sources, designing pipelines to move that data to and from our hosted and cloud environments, and push the evolution of these processes to accommodate new types of data.

Essential Duties and Responsibilities:

• Create and maintain processes to acquire, validate, and enrich data from various sources
• Build and maintain data pipelines and automate existing manual processes.
• Work with Data Integration to build and maintain efficient processes for loading acquired data into our relational, dimensional, and no-SQL databases
• Work with other teams to identify new sources of data, and estimate feasibility of acquiring specific data sources

Work Experience and Background:

• 2 years of work experience in a highly technical and hands-on data engineering role
• Experience working with the most common types of healthcare data (medical claims, eligibility, provider network rosters, Rx claims, etc.) from a variety of sources
• Strong organizational skills and time management capacity to balance multiple projects with limited supervision
• Ability to build and re-evaluate a process from the ground up
• Strong investigative skills with ability to search beyond the initial results
• Have a fanatical attention to detail, with overwhelming desire to test and double-check your own results
• Comfortable working with messy data and ambiguous results
• Education (Bachelor’s degree or greater, or equivalent practical experience) in a quantitative field such as statistics, mathematics, engineering, or computer science

Technical Proficiencies:

Our analytics infrastructure consists of a hybrid solution (traditional hosting cloud hosting) that uses the below technologies. Ideal candidates will have experience with several of these, especially SQL and Python. And while we use Azure for our cloud environment, experience with equivalent cloud services from AWS and/or Google is acceptable.

• Bash and PowerShell for command-line scripting and process automation
• SQL Server for storing our master relational database containing billions of rows of healthcare data
• Python and Jupyter Notebooks for exploratory data analysis, machine learning, and process automation
• PowerBI for reporting and visualization

Healthcare Bluebook Core Values:

As a member of the Bluebook team, it is expected that you will live and breathe our Core Values each and every day in everything they do – striving to help us achieve our purpose of “Protecting Patients by exposing the truth and empowering choice.”

• Substance – Create Value over splash. 
• Humility – Serve with Gratitude. 
• Accountability – Own it no matter what. 
• Resourcefulness – Always agile with change. 
• Integrity – Honor the truth.