

Residexยฎ
Data Architect
โญ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Architect with an 8+ year background in enterprise data warehouse solutions, particularly on Snowflake. Contract length is "unknown," pay rate is "unknown," and work location is "unknown." Key skills include ETL/ELT, Power BI, and healthcare experience.
๐ - Country
United States
๐ฑ - Currency
$ USD
-
๐ฐ - Day rate
Unknown
-
๐๏ธ - Date
January 16, 2026
๐ - Duration
Unknown
-
๐๏ธ - Location
Unknown
-
๐ - Contract
Unknown
-
๐ - Security
Unknown
-
๐ - Location detailed
Englewood, CO
-
๐ง - Skills detailed
#Microsoft Power BI #Data Governance #Compliance #Data Quality #Migration #AI (Artificial Intelligence) #dbt (data build tool) #DAX #Data Pipeline #Security #Data Extraction #Data Architecture #Data Security #Documentation #MDM (Master Data Management) #Kafka (Apache Kafka) #Data Engineering #Data Warehouse #"ETL (Extract #Transform #Load)" #Deployment #Scala #Indexing #BI (Business Intelligence) #Data Lineage #SSRS (SQL Server Reporting Services) #SQL (Structured Query Language) #SQL Server #Semantic Models #MS SSRS (Microsoft SQL Server Reporting Services) #EDW (Enterprise Data Warehouse) #Leadership #Cloud #Data Management #Snowflake #Data Migration
Role description
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.
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.






