Data Architect jobs in United States
cer-icon
Apply on Employer Site
company-logo

Residex® · 9 hours ago

Data Architect

Residex® is focused on improving the quality of life for seniors and their caregivers. The Data Architect will design and implement enterprise data warehouse architecture, lead migration initiatives, and collaborate with cross-functional teams to optimize data models and analytics experiences.

Consumer SoftwareSoftware

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

Qualification

Snowflake architectureETL/ELT pipeline designPower BISQL ServerData governanceData quality frameworksMaster data managementPerformance optimizationHealthcare experienceReal-time data pipelinesCommunication

Required

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
Excellent communication skills with ability to explain technical concepts to non-technical stakeholders and build consensus across diverse teams

Preferred

Healthcare or senior living industry experience strongly preferred; familiarity with EHR systems, clinical workflows, regulatory compliance requirements, and PHI data handling
Experience with real-time data pipelines or streaming architectures (Kafka, event-driven patterns) is a plus

Company

Residex®

twittertwittertwitter
company-logo
Residex® delivers Intelligent Care through a secure, all-in-one assisted living software platform that empowers caregivers with data-driven tools for smarter, safer, and more efficient care.

Funding

Current Stage
Early Stage
Total Funding
unknown
2025-01-22Acquired
Company data provided by crunchbase