Please note: This is a hybrid role requiring 3 days in office at our Philadelphia HQ - 1818 Market Street.
How you will help
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. Your team will support you and you the same. Peer review of solutions and implementations is expected. You will play an integral part in building the foundation of everything to come.
What you will do
- Provide expertise on all healthcare data types: medical claims transactions (e.g. 837 and 835), pharmacy claims (NCPDP D.0), EMR/EHR, lab transactions, and other emerging data assets
- Ensure high-quality design of dimensional models and data mapping
- Sharing data content and industry knowledge to mentor team members
- Provide strategic guidance with respect to MDM best practices
- Data profiling and integration
- Explore, profile, and validate incoming healthcare data extensively, using SQL
- Map de-identified healthcare data to proprietary data structures
- Collaborate on the development of QA test plans for incoming data and data in our warehouse
- 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
How success will be defined
- Ability to write advanced SQL to standardize and enhance data assets
- Subject matter expert for medical claims, pharmacy data, and lab data
- Ability to master healthcare IT standards and healthcare data
- Proactive and take the initiative to implement improvements
- Data driven, testing and measuring when required
Required skills and experience
- 7+ years of experience with EHR, medical claims, pharmacy data
- 10+ years of experience in data warehousing
- 10+ years of hands-on SQL
- 7+ years of data modeling and/or building and modifying tables in an RDBMS environment
- 5+ years of mapping source data to target tables
Desired skills and experience
- Lab data, medical device data, genomic data
- 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, Python, GitHub (or Version Control)
Base salary for the role is commensurate with experience and can range between $70,000 - 130,000 + annual bonus opportunity.
Our main office is located in Center City, Philadelphia, where we operate on a hybrid model with in-office work required three days a week for local employees. We believe collaboration is most effective when teams come together, which is why we prioritize hiring in the Philadelphia area.
For certain roles, we also hire from hub locations—regions where we have an established presence with multiple team members working remotely. While these employees primarily work from home, we bring them together in person at lease once a year for team-building, collaboration, and strategic planning.
Due to tax and labor regulations, we can only hire from specific states. Remote work is supported in the following key hub locations and approved states:
Hub Locations:
- Philadelphia, Pennsylvania
- Boston, Massachusetts
- New York City, New York
- Baltimore, Maryland
- Washington, D.C.
- Charlotte, North Carolina
- Raleigh-Durham, North Carolina
- Atlanta, Georgia
- Chicago, Illinois
Approved States for Remote Work:
CT, DE, FL, GA, IL, IN, MA, MD, MI, NC, NJ, NY, OH, PA, TN, and VA.
About HealthVerity
HealthVerity is the leader in privacy-protected real-world data exchange, transforming how healthcare and life sciences organizations connect and analyze disparate healthcare and consumer data. We continue to innovate HealthVerity Marketplace, the nation's first and largest real-world data ecosystem comprising more than 75 leading data providers and over 340 million US patients. Combined with Identity Manager, the industry's most accurate and efficient solution for patient identity, privacy and governance, we support critical applications in clinical development, commercial strategy, regulatory decision-making, population health, underwriting and more. HealthVerity has raised more than $140 million to date and works closely with its data providers, partners and clients to Synchronize the Science. To learn more about HealthVerity, visit healthverity.com.
Why you'll love working here
We are making a difference – Our technology is at the forefront of some of the biggest healthcare challenges in the world.
We are one team – Our people define our culture and always will. We take time out to celebrate each other, and acknowledge the value that each of us adds towards our greater mission. Come share all you have to offer.
We are learners – Every team member is continually learning, no matter if we've been in a role for one year or much longer. We are committed to learning and implementing what is best for our clients, partners, and each other.
Benefits & Perks
Our benefits package is thoughtfully designed to support and enrich the experience of our full-time employees, with eligibility limited to those in permanent positions.
- Compensation: competitive base salary & annual bonus opportunity (for non-commissioned roles)
- Benefits: We offer a 401(k) plan and stock options. Health, dental, and vision coverage start on day 1, while 401(k) eligibility and stock options follow soon after.
- Flexible location: Remote workdays and 3 days a week of in-office collaboration for team members in the Philadelphia area. Check location requirements with the recruiting team.
- Generous PTO: Take time off as needed, targeted at 4 weeks per year, including vacation, personal and sick time, plus paid parental leave.
- Parental Leave: 12 weeks paid leave for childbearing, surrogacy, and adoption; 6 weeks for non-childbearing parents.
- Comprehensive and individualized onboarding: mentorship program, departmental talks, and a library of resources are available beginning day 1 for each new team member to minimize the stress of starting a new job
- Professional development: biweekly 1:1s, hands-on leadership that is goal-and growth-oriented for each team member, and an annual budget to support professional development pursuits
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. All qualified job applicants will be given consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or on the basis of disability. 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.
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 [email protected]
Remote opportunities are not available in all areas and require team members to work from a fixed location due to tax and labor law implications - specific questions about remote positions can be discussed during the interview process with your recruiter.
Similar Jobs
What We Do
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.
