Data Integrations Analyst

HealthVerity

HealthVerity, a leader in integrating advanced technologies with healthcare data, is seeking a Data Integrations Analyst. This hands-on role involves crucialing data ingestion, ensuring quality, and delivering scalable solutions. The team values collaboration and expert-driven initiatives.

In this role you can expect to have the responsibilities:

• Provide expertise on healthcare data types including medical claims, pharmacy claims, and EMR/EHR.
• Ensure high-quality dimensional model design and data mapping.
• Mentor team members by sharing data content and industry knowledge.
• Provide strategic guidance on MDM best practices.
• Perform data profiling, integration, and validation using SQL.
• Map de-identified healthcare data to proprietary structures.
• Collaborate on developing QA test plans for data.
• Troubleshoot and resolve issues in ETL processes.
• Enforce standards in data warehouse nomenclature, storage, and design.

This role comes with the following benefits:

• Competitive salary and annual bonus opportunities.
• 401(k) plan and stock options starting shortly after day 1.
• Health, dental, and vision coverage beginning on day 1.
• Flexible location with 3 in-office days per week for Philadelphia area team members.
• Generous PTO, including 4 weeks per year and paid parental leave.
• Comprehensive onboarding with mentorship and departmental talks.
• Professional development support with biweekly 1:1s and growth-oriented leadership.

This role requires you to have:

• 7+ years with EHR, medical claims, pharmacy data.
• 10+ years in data warehousing.
• 10+ years hands-on SQL experience.
• 7+ years in data modeling or RDBMS table building.
• 5+ years mapping source data to target tables.

You would benefit from having:

• Experience with lab data, medical device, and genomic data.
• Understanding of healthcare IT standards like ANSI 837/835, NCPDP D.0, HL7.
• Knowledge of Hive, Spark SQL, Python, and Version Control.

HealthVerity is committed to diversity and fostering an inclusive environment. They ensure employment consideration without discrimination and offer reasonable accommodation for application and employment processes. Remote work is structured based on tax and labor laws.