Data Vault Developer (hybrid)
Tandigm Health, a transformational leader in population health management, is looking for a Data Vault Developer in the greater Philadelphia area. We offer a competitive compensation and benefits package and are proud to share a culture where every person feels valued and empowered.
Tandigm’s Data Vault Developer is responsible for designing, building, and maintaining enterprise data warehouse solutions using the Data Vault 2.0/2.1 methodology. This role works closely with data architects, engineers, and business analysts to ensure that enterprise data is modeled, integrated, and managed in a way that supports scalability, auditability, and alignment with business needs.
You will contribute hands-on expertise in SQL, Data Vault modeling, and automation tools such as VaultSpeed, WhereScape, dbtvault/AutomateDV, or DataVault Builder, with experience on modern cloud data platforms such as Snowflake, Azure Synapse, or Azure Data Fabric. This position offers the opportunity to shape and scale a Data Vault platform, gain exposure to leading automation tools, and grow your expertise through training and certification support.
- Design and implement Data Vault 2.0/2.1 models (Hubs, Links, Satellites) to support enterprise data integration.
- Develop and maintain ELT/ETL pipelines to populate the Data Vault from multiple source systems.
- Develop and maintain business-facing data products that source from the Data Vault and transform data into consumption-friendly structures like dimensional data models.
- Collaborate with architects and analysts to capture business keys, context, and lineage.
- Translate business requirements into scalable data models and pipelines.
- Ensure data quality, integrity, and consistency through testing and validation.
- Apply governance and compliance standards (e.g., HIPAA, GDPR, financial regulations) where applicable.
- Optimize SQL queries and processes for performance and maintainability.
- Document data models, flows, and technical processes.
- Work collaboratively across IT and business teams in a matrixed environment.
- Consistently exhibits behavior and communication skills that demonstrate Tandigm Health’s commitment to superior customer service, including quality, care and concern with each and every internal and external customer.
- Uses, protects, and discloses Tandigm’s patients’ protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards and protects Tandigm assets from unauthorized access, disclosure, modification, destruction or interference.
- Adheres to and responsible to abide by all information security policies, processes, and/or activities.
- Reports security events or potential events or other security risks to the organization to management.
- Performs additional duties as assigned.
Required Qualifications:
Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent work experience).
Experience:
- 3+ years in data warehouse development.
- Hands-on Data Vault 2.0/2.1 experience (minimum 1 year).
- Data Vault 2.0/2.1 certification preferred (or willingness to obtain, with support provided).
- Strong SQL skills (Snowflake, SQL Server, or equivalent).
- Experience with data warehouse automation tools such as VaultSpeed, WhereScape, dbtvault/AutomateDV, or DataVault Builder, or equivalent frameworks or custom tools.
- Familiarity with dimensional modeling (Kimball) and enterprise data warehouse concepts.
- Experience with Snowflake, Azure Synapse, or Azure Data Fabric.
- Hands-on experience with data modeling tools, including: Erwin Data Modeler, SAP PowerDesigner, ER/Studio Data Architect, Sparx Enterprise Architect, Oracle SQL Developer Data Modeler.
- Experience with business intelligence tools like PowerBI, Tableau, Looker, Domo, or Qlik
- Knowledge of data governance and security practices.
- Industry experience in healthcare, insurance, or finance preferred; experience in other large-scale enterprise data environments will be considered.
Knowledge, Skills, Abilities:
- Strong understanding of Data Vault 2.0/2.1 methodology.
- Ability to design, document, and implement data models and integration processes.
- Proficiency in SQL development and query optimization.
- Strong collaboration and communication skills with both technical and business stakeholders.
- Ability to work independently while contributing to a team-oriented environment.
- Detail-oriented with strong problem-solving skills.
Applicants must be authorized to work in the US; work visa sponsorship will not be provided.
Equal Employment Opportunities (EEO):
Tandigm provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics.
Search Firm Representatives Please Read Carefully:
Tandigm Health, LLC does not accept unsolicited assistance from search firms for employment opportunities. All CVs/resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails.