Vice President Data Warehouse Engineering
Vice President Data Warehouse Engineering
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 180000 - 275000
1 Vacancy
Job Description
How you will help
The Vice President Data Warehouse Engineering will drive the design scalability and optimization of HealthVeritys healthcarefocused data warehouse ecosystemthe most extensive and diverse in the United States. This role is ideal for a strategic technical leader with deep expertise in healthcare data architecture including the design of secure scalable infrastructures capable of integrating and normalizing clinical transactional and operational data from thousands of healthcare providers and data partners. You will design and manage innovative standardscompliant architectures that support complex largescale analytics and product development shaping the future of healthcare data solutions.
What you will do
- Architect Scalable Data Solutions: Design and implement the enterprisewide healthcare data warehouse architecture integrating complex data sources such as EHR systems claims data lab results and patient registries into a unified data platform.
- HealthcareSpecific Data Modeling: Build and optimize data models to support healthcarespecific use cases including longitudinal patient analysis population health and clinical research. Leverage best practices in dimensional modeling data vault modeling and OLAP architectures.
- StandardsBased Integration: Ensure data interoperability by integrating data using standards like ANSI 837/835 HL7 FHIR and ontologies like ICD10 CPT NDC and LOINC. Architect solutions that facilitate smooth data exchange with external partners while ensuring data lineage and traceability.
- Data Governance and Quality: Establish robust data governance frameworks tailored to healthcare compliance requirements (HIPAA HITECH). Implement tools and processes to monitor cleanse and validate incoming data streams ensuring accuracy and consistency across all datasets.
- Data Pipeline Optimization: Architect highperformance ETL/ELT pipelines that efficiently ingest transform and load multiterabyte datasets in near real time. Leverage Databricks DLT and workflows Apache Airflow dbt or equivalent tools to automate data workflows while supporting both batch and streaming data ingestion.
- CloudNative Architecture: Design cloudnative solutions using AWS services like Redshift S3 Glue and Lambda and Databricks services like Unity catalog Autoloader and Delta Live Tables to manage highthroughput data ingestion and processing at scale. Explore hybrid models when onpremise integration is needed for sensitive healthcare data.
- Data Security & Privacy: Lead the implementation of security frameworks ensuring data confidentiality integrity and availability. Incorporate advanced security measures such as encryption (in transit and at rest) access controls and secure datasharing mechanisms.
- Master Data Management (MDM): Design and maintain master reference data systems establishing consistency across providers patients medications diagnoses and procedures. Implement entity resolution algorithms to deduplicate and merge patient records.
- Advanced Query Performance: Optimize query for analytical workloads on large datasets using indexing partitioning and materialized views. Architect efficient reporting layers that provide subsecond query responses for missioncritical applications.
- RealTime Data Integration: Design architectures to support realtime or near realtime data integration and streaming use cases using technologies like Apache Kafka AWS Kinesis or Google Pub/Sub.
- CrossFunctional Collaboration: Collaborate with data scientists analysts and product teams to design data marts and semantic layers that meet the needs of both operational and analytical workloads.
- Scalable Metadata Management: Implement metadata management and data cataloging tools (e.g. Apache Iceberg Delta Tables and Unity Catalog) to enhance data discovery lineage tracking and impact analysis.
Required skills and experience
- Extensive Data Architecture Expertise: 10 years of handson experience designing developing and scaling large healthcare data warehouse ecosystems with multipetabyte architectures.
- Healthcare Data Knowledge: Deep familiarity with healthcarespecific data sources (e.g. EHRs claims labs) and experience designing architectures compliant with healthcare regulations such as HIPAA and HITECH.
- CloudNative & Hybrid Solutions: Proven experience implementing cloudbased data platforms using AWS Azure or GCP. Experience with hybrid models that integrate onpremise data centers is a plus.
- Advanced Data Modeling: Strong knowledge of OLTP OLAP star schema and snowflake schema designs with an emphasis on healthcare data models. Experience with dimensional modeling and data vault approaches.
- ETL/ELT Pipeline Design: Expertise in building scalable and automated ETL/ELT pipelines using tools like Apache NiFi Airflow dbt or Informatica to manage diverse highvolume data sources. Experience migrating from EMR and Hive to Databricks or Snowflake is desirable.
- Interoperability Standards: Practical experience working with healthcare messaging and data exchange standards including ANSI x12 HL7 FHIR and CCD.
- Distributed Computing: Handson experience with distributed data processing frameworks like Apache Spark or Dask for largescale data transformations and analytics.
- Big Data Systems: Experience with big data ecosystems including Hive Presto and NoSQL databases to support complex analytical workloads. Additionally experience optimizing these systems with data systems like DuckDB is desirable.
- Data Quality & Governance: Expertise in implementing automated data quality checks and governance frameworks using tools like Great Expectations DataOps solutions or custombuilt frameworks. Experience with Data Observability frameworks such as Anomolo or Monte Carlo is a plus.
- Data Security & Privacy: Strong understanding of data encryption techniques rolebased access control (RBAC) and tokenization to protect sensitive healthcare information.
- Agile Development & DevOps: Experience integrating CI/CD pipelines automated testing and DevOps practices into data architecture projects to ensure reliability and scalability.
- Master Data Management: Expertise in designing and maintaining MDM solutions that ensure consistency across core healthcare domains including patient provider and diagnosis records.
- Scalable Data Storage: Familiarity with distributed storage systems optimized for healthcare data including columnar databases (e.g. Redshift BigQuery Casandra) and object storage solutions (e.g. S3 GCS).
Base salary for the role is commensurate with experience and can range between $annual bonus opportunity.
Hiring Locations
Our main office is located in Center City Philadelphia where we operate on a hybrid model with inoffice 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 locationsregions 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 teambuilding 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
- RaleighDurham 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 synchronizes transformational technologies with the nations 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 builtin 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.
Why youll 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 weve 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 fulltime employees with eligibility limited to those in permanent positions.
- Compensation: competitive base salary & annual bonus opportunity (for noncommissioned 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 inoffice 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 nonchildbearing 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 handson leadership that is goaland growthoriented 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 were 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 preemployment testing or otherwise participating in the employee selection process please direct your inquiries to
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.
Required Experience:
Chief
Employment Type
Full Time
