<p>Location: Philadelphia, Pennsylvania</p><br/><p>Employment Type: Full-time</p><br/><p>Team: Data Architecture</p><br/><div><span style="font-size: 18px"><b>How you will help</b></span></div><div>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.&nbsp;</div><div><br></div><h3>What you will do </h3><br/><ul><li>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</li><li>Ensure high-quality design of dimensional models and data mapping</li><li>Sharing data content and industry knowledge to mentor team members</li><li>Provide strategic guidance with respect to MDM best practices</li><li>Data profiling and integration</li><li>Explore, profile, and validate incoming healthcare data extensively, using SQL</li><li>Map de-identified healthcare data to proprietary data structures</li><li>Collaborate on the development of QA test plans for incoming data and data in our warehouse</li><li>Perform troubleshooting on all ETL processes and resolve issues effectively</li><li>Expand and reinforce company standards in terms of nomenclature, storage, design and deployment</li><li>Provide support to all data warehouse initiatives</li><div><br></div></ul><br/><h3>How success will be defined</h3><br/><ul><li>Ability to write advanced SQL to standardize and enhance data assets</li><li>Subject matter expert for medical claims, pharmacy data, and lab data</li><li>Ability to master healthcare IT standards and healthcare data</li><li>Proactive and take the initiative to implement improvements</li><li>Data driven, testing and measuring when required</li><div><br></div></ul><br/><h3>Required skills and experience</h3><br/><ul><li>7+ years of experience with EHR, medical claims, pharmacy data</li><li>15+ years of experience in data warehousing</li><li>10+ years of hands-on SQL</li><li>7+ years of data modeling and/or building and modifying tables in an RDBMS environment</li><li>5+ years of mapping source data to target tables</li><div><br></div></ul><br/><h3>Desired skills and experience</h3><br/><ul><li>Understanding of healthcare IT standards and data structures such as ANSI 837/835, NCPDP D.0, HL7, and optionally HL7 CCR/CCD or FHIR&nbsp;</li><li>Hive, Spark SQL, Python</li><div><br></div></ul><br/><div><b style="font-size: 18px">Hiring Locations</b></div><div><span style="font-size: 11pt">Our strong preference is to hire team members in the Philadelphia area whenever possible. </span><span style="font-size: 14.6667px">Expansion beyond Philadelphia will occur when necessary with travel to our Philadelphia headquarters as required. Remote work is supported from our key hub locations listed</span><span style="font-size: 11pt"> below as well as approved states in the Eastern Time Zone.</span></div><div><br></div><div><span style="font-size: 16px">•&nbsp;</span><span style="font-size: 11pt">Boston, Massachusetts</span></div><div><span style="font-size: 16px">•&nbsp;</span><span style="font-size: 11pt">New York City, New York</span></div><div><span style="font-size: 16px">•&nbsp;</span><span style="font-size: 11pt">Baltimore, Maryland</span></div><div><span style="font-size: 16px">•&nbsp;</span><span style="font-size: 11pt">Washington D.C</span></div><div><span style="font-size: 16px">•&nbsp;</span><span style="font-size: 11pt">Charlotte, North Carolina</span></div><div><span style="font-size: 16px">•&nbsp;</span>Raleigh-Durham, North Carolina</div><div><span style="font-size: 16px">•&nbsp;</span><span style="font-size: 11pt">Atlanta, Georgia</span></div><div><br></div><div><span style="font-size: 11pt">Approved States in the Eastern Time Zone: CT, DE, FL, GA, IN, MA, MD, MI NC, NJ, NY, OH, PA, RI, TN, and VA.</span></div><div><br></div><div><b style="font-size: 18px">About HealthVerity</b></div><div><span style="font-size: 14.6667px">HealthVerity synchronizes transformational technologies with the nation’s largest healthcare and consumer data ecosystem to power previously unattainable outcomes and fundamentally advance the science. We offer a comprehensive, yet flexible approach, based on the foundational elements of Identity, Privacy, Governance and Exchange (IPGE), that synchronizes unparalleled Identity management with built-in Privacy compliance and Governance, providing the ability to discover and Exchange a near limitless combination of data at a record pace. Together with our partners in life sciences, government and insurance, we are Synchronizing the Science. To learn more about HealthVerity, visit </span><a href="http://healthverity.com/" style="font-size: 14.6667px" class="postings-link">healthverity.com</a><span style="font-size: 14.6667px">.</span></div><div><br></div><div><b style="font-size: 18px">Why you'll love working here</b></div><div><br></div><div><b>We are making a difference </b>– Our technology is at the forefront of some of the biggest healthcare challenges in the world.&nbsp;</div><div><b>We are one team</b> – Our people define our culture and always will. We take time out to celebrate each other at the end of every week through company-wide shout outs, and acknowledge the value that each of us adds towards our greater mission. Come share all you have to offer.</div><div><b>We are learners</b> – 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.</div><div><br></div><div><b style="font-size: 18px">Benefits &amp; Perks</b></div><div>•&nbsp;Compensation: competitive base salary &amp; annual bonus opportunity (for non-commissioned roles)</div><div>•&nbsp;Benefits: comprehensive benefits with coverage on Day 1, medical, dental, vision, 401k, stock options</div><div>•&nbsp;Flexible location: our HQ is in Philadelphia. We offer both hybrid roles and those with quarterly travel. </div><div>•&nbsp;Generous PTO: Take time off as needed, targeted at 4 weeks per year, including vacation, personal and sick time, plus paid maternity and paternity leave.</div><div>•&nbsp;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</div><div>•&nbsp;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</div><div><br></div><div>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. All qualified&nbsp;job&nbsp;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.&nbsp;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. <a href="https://info.healthverity.com/hubfs/EIDC%20statement%20(6_2021).pdf" class="postings-link">Read our Equity Inclusion and Diversity Statement</a>.</div><div><br></div><div>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 <a href="mailto:careers@healthverity.com" class="postings-link">careers@healthverity.com</a></div><div><br></div><div>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. </div>

Location: Philadelphia, Pennsylvania

  

Employment Type: Full-time

  

Team: Data Architecture

  

 **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
  * 15+ 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

  

  * 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

  

  

 **Hiring Locations**

Our strong preference is to hire team members in the Philadelphia area
whenever possible. Expansion beyond Philadelphia will occur when necessary
with travel to our Philadelphia headquarters as required. Remote work is
supported from our key hub locations listed below as well as approved states
in the Eastern Time Zone.

  

• Boston, Massachusetts

• New York City, New York

• Baltimore, Maryland

• Washington D.C

• Charlotte, North Carolina

• Raleigh-Durham, North Carolina

• Atlanta, Georgia

  

Approved States in the Eastern Time Zone: CT, DE, FL, GA, IN, MA, MD, MI NC,
NJ, NY, OH, PA, RI, TN, and VA.

  

 **About HealthVerity**

HealthVerity synchronizes transformational technologies with the nation’s
largest healthcare and consumer data ecosystem to power previously
unattainable outcomes and fundamentally advance the science. We offer a
comprehensive, yet flexible approach, based on the foundational elements of
Identity, Privacy, Governance and Exchange (IPGE), that synchronizes
unparalleled Identity management with built-in Privacy compliance and
Governance, providing the ability to discover and Exchange a near limitless
combination of data at a record pace. Together with our partners in life
sciences, government and insurance, we are Synchronizing the Science. To learn
more about HealthVerity, visit [healthverity.com](http://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 at the end of every week through company-wide
shout outs, 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**

• Compensation: competitive base salary & annual bonus opportunity (for non-
commissioned roles)

• Benefits: comprehensive benefits with coverage on Day 1, medical, dental,
vision, 401k, stock options

• Flexible location: our HQ is in Philadelphia. We offer both hybrid roles and
those with quarterly travel.

• Generous PTO: Take time off as needed, targeted at 4 weeks per year,
including vacation, personal and sick time, plus paid maternity and paternity
leave.

• 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

  

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. 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.
[Read our Equity Inclusion and Diversity
Statement](https://info.healthverity.com/hubfs/EIDC%20statement%20\(6_2021\).pdf).

  

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](mailto:careers@healthverity.com)

  

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.

