You’ll be embarking on a hands-on role, from ingestion up to making all data available in the warehouse layer, in standardized form, and ready to use. You’ll investigate and map the data, assess data quality, and QA the transformed results. You’ll reinforce data architecture standards, and data warehouse policies and procedures, ensuring that clients receive the highest quality data. You’ll use the best tools for the job, whether modern and revolutionary or time-tested and proven, to deliver elegant, scalable solutions that meet business and technical needs. Peer review of solutions and implementations is expected. You will play an integral part in building the foundation of everything to come. 

• Ensure high-quality design of dimensional models and data mapping

• Provide strategic guidance with respect to MDM best practices

• MDM data profiling and integration

• Explore, profile, and validate incoming healthcare data extensively, using SQL

• Map de-identified healthcare data to proprietary data structures

• Develop and improve QA test plans for incoming data

• Work closely with ETL developers to perform troubleshooting on all ETL processes and resolve issues effectively

• Expand and reinforce company standards in terms of nomenclature, storage, design and deployment

• Provide support to all data warehouse initiatives

You are...

• Capable of writing advanced SQL to standardize and enhance data assets

• Aware of healthcare IT standards and have worked with healthcare data

• A careful listener who absorbs information well

• Proactive and take the initiative to implement improvements

• Data driven, testing and measuring as much as you can

• Familiar with HIPAA rules and requirements

• 3+ years of mapping source data to target tables

• 3+ years of data modeling and/or building and modifying tables in an RDBMS environment

• 3+ years of experience with EHR, medical claims, pharmacy data, and/or lab data

• 3+ years of experience in data warehousing

• 2+ years of hands-on SQL

• Understanding of healthcare IT standards and data structures such as ANSI 837/835, NCPDP D.0, HL7, and optionally HL7 CCR/CCD or FHIR 

• Hive, Spark SQL

Pharmaceutical manufacturers, payers and government organizations have partnered with HealthVerity to solve some of their most complicated use cases through transformative technologies and real-world data infrastructure. The HealthVerity IPGE platform, based on the foundational elements of Identity, Privacy, Governance and Exchange, enables the discovery of RWD across the broadest healthcare data ecosystem, the building of more complete and accurate patient journeys and the ability to power best-in-class analytics and applications with flexibility and ease. Together with our partners, HealthVerity has built the modern way to data for the health insights economy. To learn more about the HealthVerity IPGE platform, visit www.healthverity.com.

• Empowering clients with highly rewarding data discovery and licensing tools

• Ingesting and managing billions of healthcare records from a wide variety of partners

• Standardizing on common data models across data types

• Orchestrating an industry-leading HIPAA privacy layer

• Innovating our proprietary de-identification and data science algorithms

• Building a culture that supports rapid iteration and new possibilities

The infrastructure and culture we are building will provide an environment that cultivates innovation. We want to move fast knowing we can fix anything we break along the way. If a new need arises, we want to turn around a solution quickly. We want to solve our challenges in ways that create even more possibilities. We’ve created a platform that will scale to support an ever-growing array of data providers and innovative products and services. You must be able to think big while still delivering on near-term requirements.

We pride ourselves on ensuring that each team member at HealthVerity feels connected, validated and heard. From Philadelphia to Manhattan Beach, our success is driven by recognizing that a team is made up of individuals. We offer a robust set of benefits and perks to everyone. View details on our careers page.

HealthVerity is an equal opportunity employer devoted to inclusion in the workplace. We believe incorporating different ideas, perspectives and backgrounds make us stronger and encourages an environment where ageism, racism, sexism, ableism, homophobia, transphobia or any other form of discrimination are not tolerated. At HealthVerity, we’re working towards an innovative and connected future for healthcare data and believe the future is better together. We can only do that if everyone has a seat at the table. Read our Equity Inclusion and Diversity Statement.

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to careers@healthverity.com

HealthVerity offers in-office and remote options, so you can work from anywhere within the US! #LI-Remote