Senior Data Architect
Integra Partners
- Troy, MI
- $167,000 per year
- Permanent
- Full-time
- 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.
- 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.
- 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