Logo for Residex

Data Architect

Roles & Responsibilities

  • 8+ years of experience designing and implementing enterprise data warehouse solutions with Snowflake, dimensional modeling, and cloud data platforms
  • Proven track record leading data migration initiatives from legacy reporting systems (e.g., SSRS, Crystal Reports) to modern BI platforms
  • Strong Power BI expertise including semantic model design, DAX optimization, and enterprise deployment patterns
  • Hands-on experience with SQL Server data extraction, ETL/ELT tools (dbt strongly preferred), and modern data engineering practices

Requirements:

  • Design and implement enterprise data warehouse architecture on Snowflake, including dimensional models, data governance frameworks, and integration patterns to support analytics and business intelligence across 8,000+ healthcare communities
  • Lead migration of legacy reporting infrastructure to a modern cloud-based analytics platform, including ETL/ELT pipeline design, business logic extraction, and data quality validation
  • Architect semantic models and dashboard framework to consolidate reporting tools into interactive analytics experiences, including performance optimization and HIPAA/PHI data security controls
  • Collaborate across clinical, operations, finance, and compliance to translate business needs into scalable data models and transformations; mentor data engineers and BI developers, establish development standards, code reviews, and documentation; evaluate and select ETL/ELT tooling with HIPAA compliance in mind

Job description

Job Type
Full-time
Description

Key Responsibilities:

  • Design and implement enterprise data warehouse architecture on Snowflake, including dimensional models, data governance frameworks, and integration patterns that support analytics and business intelligence across 8,000+ healthcare communities
  • Lead the migration of legacy reporting infrastructure to modern cloud-based analytics platform, including ETL/ELT pipeline design, business logic extraction, and data quality validation
  • Architect semantic models and dashboard framework to replace existing fixed reporting tools and templates with consolidated, interactive analytics experiences
  • Own end-to-end program delivery including timeline management, risk mitigation, stakeholder coordination across clinical, operations, and compliance teams, and technical decision-making
  • Collaborate cross-functionally with clinical, operations, finance, and compliance stakeholders to translate business needs and embedded application logic into scalable data models and transformations
  • Mentor and provide technical direction to data engineers and BI developers, establishing development standards, code review practices, and documentation requirements
  • Evaluate and select ETL/ELT tooling, ensuring HIPAA compliance and PHI data security controls throughout the data platform
  • Establish data quality frameworks, data lineage documentation, and master data management practices to ensure accuracy and trustworthiness of analytics
  • Optimize query performance, indexing strategies, and data retrieval processes to ensure sub-second dashboard response times
Requirements

What We're Looking For:

  • 8+ years of experience designing and implementing enterprise data warehouse solutions, with deep expertise in Snowflake architecture, dimensional modeling, and cloud data platforms
  • Proven track record leading data migration initiatives at scale, particularly migrations from legacy reporting systems (SSRS, Crystal Reports, or similar) to modern BI platforms
  • Strong Power BI platform knowledge including semantic model design, DAX optimization, and enterprise deployment patterns
  • Hands-on experience with SQL Server data extraction, ETL/ELT tools (dbt strongly preferred), and modern data engineering practices
  • Demonstrated ability to own both technical architecture and program delivery—you've successfully managed timelines, dependencies, and stakeholder expectations on complex data initiatives with hard deadlines
  • Experience translating embedded business logic from application code into maintainable data layer transformations
  • Strong understanding of data governance, data quality frameworks, and master data management principles
  • Experience with performance optimization including query tuning, indexing strategies, and data retrieval optimization
  • Healthcare or senior living industry experience strongly preferred; familiarity with EHR systems, clinical workflows, regulatory compliance requirements, and PHI data handling
  • Excellent communication skills with ability to explain technical concepts to non-technical stakeholders and build consensus across diverse teams
  • Experience with real-time data pipelines or streaming architectures (Kafka, event-driven patterns) is a plus

Why Join Residex?

  • Purpose That Matters: Be part of a mission that directly impacts the quality of life for seniors and the caregivers who serve them.
  • Real Platform Ownership: Own the future of our data platform and help shape the technology stack, analytics experience, and innovation roadmap.
  • High-Trust Leadership: Work shoulder-to-shoulder with a CPO and executive team that values autonomy, vision, and results.
  • Rapid Growth, Real Impact: Join at a high-growth inflection point with the resources, customers, and market tailwinds to go big.
  • A Culture of Craft and Care: We take pride in what we build and care deeply about the people we build it for---and with.

Ready to Shape the Future of AI-Driven Healthcare Analytics?

If you're ready to lead not just a platform, but a movement---this is your call. Let's transform intelligent care together.




Data Architect Related jobs

Other jobs at Residex

We help you get seen. Not ignored.

We help you get seen faster — by the right people.

🚀

Auto-Apply

We apply for you — automatically and instantly.

Save time, skip forms, and stay on top of every opportunity. Because you can't get seen if you're not in the race.

✨

AI Match Feedback

Know your real match before you apply.

Get a detailed AI assessment of your profile against each job posting. Because getting seen starts with passing the filters.

Upgrade to Premium. Apply smarter and get noticed.

Upgrade to Premium

Join thousands of professionals who got noticed and hired faster.