Senior Data Architect

Summary

Join Integra Partners as a Senior Data Architect to lead the design and governance of our data platform, supporting analytics, AI/ML, and operational excellence in healthcare. You will design and implement a robust and scalable data strategy, developing data pipelines, data models, and establishing data governance policies. Collaborate with stakeholders and engineering teams to define data domains, ensure data quality, and provide architectural guidance. The ideal candidate has expertise in data architecture principles, data modeling (Data Vault 2.0 and Medallion architectures), and cloud-native architecture using Snowflake, Azure, and DBT. This role requires strong leadership and communication skills to influence stakeholders and mentor teams. Integra Partners offers competitive compensation and a comprehensive benefits package.

Requirements

• 8+ years of experience in data architecture, data engineering, or related disciplines, with a strong focus on designing modern cloud-based data platforms
• Deep expertise in Snowflake, including advanced data modeling, performance optimization, and support for AI/ML workloads (e.g., Cortex AISQL, Cortex Agents, Cortex Analyst)
• Hands-on experience with data modeling methodologies, including Data Vault 2.0, Medallion Architecture, and dimensional modeling for analytical workloads
• Demonstrated ability to define and implement enterprise data strategies, including data domain design, master data management (MDM), and data governance policies
• Practical experience developing data pipelines and transformation logic using DBT, Python, and orchestration tools like Apache Airflow or Azure Data Factory
• Familiarity with designing AI/ML data foundations, including feature stores, training datasets, and data interfaces to Snowflake Cortex and Azure AI Studio
• Hands-on knowledge of CI/CD practices and infrastructure-as-code for data systems, promoting reusable, testable, and automated deployment patterns
• Experience designing and managing data quality frameworks, implementing lineage tracking, and ensuring observability across the data ecosystem
• Effective communication and leadership skills, with a proven ability to influence stakeholders, mentor technical teams, and align data architecture with business objectives
• Working knowledge of data security, compliance, and data modeling within the healthcare industry, including standards such as HIPAA; experience in the DME sector is a plus
• Familiarity with metadata management, data cataloging, and integration with enterprise data governance tools
• Experience participating in or leading Agile data engineering team

Responsibilities

• Design and develop information data models including conceptual, logical and physical data models
• Identify key data entities, create conceptual models, map them to value stages and business capabilities
• Develop high-level data flows for both current and future states
• Establish data architecture principles, data standards, best practices, and guidelines for the design of the data platform
• Design and deliver well-structured feature stores and training datasets to support AI/ML initiatives, with a focus on integration with Snowflake Cortex (including AISQL, Cortex Agents) and Azure AI Studio
• Provide architectural oversight and guidance on the use of Snowflake, Fivetran, Azure Data Services, DBT
• Collaborate with stakeholders, PO, and engineering team to understand data needs and translate them into designs
• Evaluate and recommend new technologies, tools, and practices to improve data platform capabilities
• Perform data quality analysis, identify, propose recommendations to resolve data quality issues
• Lead proof-of-concept efforts and guide product owners and engineering teams in designing and developing solutions using tools aligned with the selected architectural framework

Benefits

• Competitive compensation and annual bonus program
• 401(k) retirement program with company match
• Company-paid life insurance
• Company-paid short term disability coverage (location restrictions may apply)
• Medical, Vision, and Dental benefits
• Paid Time Off (PTO)
• Paid Parental Leave
• Sick Time
• Paid company holidays and floating holidays
• Quarterly company-sponsored events
• Health and wellness programs
• Career development opportunities
• Remote Opportunities