Senior Data Architect

SOUTH COAST COMMUNITY SERVICES•Mission Viejo, CA

15h

About The Position

The Senior Data Architect is responsible for enterprise data architecture, analytics, business intelligence, and data platform modernization across clinical, operational, financial, and regulatory domains. The role designs, develops, and maintains scalable data warehouses, data marts, lakehouses, integration pipelines, and reporting solutions that turn complex healthcare data into trusted, actionable insights for strategic decision-making. The Senior Data Architect bridges business stakeholders and technical teams, partnering with clinical, operational, finance, quality, research, and executive leadership to deliver enterprise analytics, data governance frameworks, and modern reporting solutions. The role supports data quality, compliance, and usability while enabling data-driven decision-making across the organization. The position modernizes legacy data platforms using cloud-based analytics technologies such as Microsoft Fabric or Snowflake and develops enterprise Power BI solutions to support organizational growth, regulatory requirements, operational excellence, and measurable business outcomes. It also leads cross-functional initiatives, advises stakeholders, and mentors data professionals.

Requirements

Bachelor’s degree in computer science, Information Systems, Engineering, Healthcare Informatics, Data Analytics, or a related field.
10+ years of progressive experience in data architecture, data engineering, business intelligence, analytics, or enterprise reporting.
Significant experience designing and supporting enterprise data warehouses and analytics platforms.
Experience working with healthcare, behavioral healthcare, clinical, financial, or regulated data environments.
Demonstrated success delivering enterprise reporting and analytics solutions that support executive decision-making.
Expertise in enterprise data architecture, data warehousing, data modeling, data marts, lakehouse architecture, ETL/ELT development, and data integration.
Knowledge of metadata management, data governance, database technologies, stored procedures, and SQL performance tuning.
Experience with Microsoft SQL Server, Oracle, PostgreSQL, and InterSystems Cache/IRIS.
Knowledge of Microsoft Fabric, Snowflake, Azure Data Services, cloud data platforms, and enterprise analytics architectures.
Experience with Power BI, Qlik Sense, SSRS, Crystal Reports, dashboard development, KPI design, and data visualization.
Knowledge of electronic health records (EHR), clinical data management, quality measures reporting, regulatory reporting, research data platforms, and healthcare analytics.

Nice To Haves

Master’s degree.
Experience architecting Microsoft Fabric or Snowflake data platforms.
Experience implementing enterprise Power BI governance and self-service analytics strategies.
Knowledge of healthcare quality measures, value-based care, CCBHC reporting, and clinical outcomes analytics.
Experience with advanced analytics, statistical analysis, or data science initiatives.
Familiarity with AI-enabled analytics and modern data platform capabilities.

Responsibilities

Design, develop, and maintain enterprise data architecture for clinical, financial, operational, quality, research, and regulatory reporting.
Architect and manage enterprise data warehouses, lakehouses, operational data stores, and subject-area data marts.
Define enterprise data standards, data models, metadata frameworks, and data governance practices; develop long-term architecture roadmaps aligned with business goals.
Evaluate emerging technologies and recommend platforms that improve scalability, performance, and analytics capabilities.
Architect and develop scalable ETL/ELT solutions and data pipelines integrating enterprise systems and supporting healthcare, financial, operational, research, and external reporting.
Integrate and transform data from EHR systems, ERP applications, survey platforms, quality management systems, research databases, and third-party applications.
Optimize database performance, stored procedures, data models, and data processing workflows; ensure enterprise data is standardized, validated, and analytics-ready.
Lead migration of legacy data warehouse environments to modern cloud analytics platforms and evaluate migration strategies for legacy ETL, reporting environments, and data marts.
Design and implement solutions using modern analytics technologies, including Microsoft Fabric, OneLake, Data Factory, Lakehouse, Data Warehouse, Power BI, and Snowflake.
Establish best practices for cloud data management, governance, security, and performance, and develop architectures supporting real-time analytics, self-service reporting, advanced analytics, and future AI initiatives.
Design, develop, and maintain enterprise Power BI dashboards, reports, scorecards, semantic models, reusable datasets, KPIs, and executive analytics solutions.
Implement Power BI governance standards, security models, deployment processes, and performance optimization; develop self-service analytics capabilities.
Partner with stakeholders to define reporting requirements and deliver actionable insights through visualization technologies.
Maintain and enhance business intelligence platforms including Power BI, Qlik Sense, SSRS, Crystal Reports, and other reporting solutions.
Design and support analytics for behavioral healthcare, population health, quality improvement, patient outcomes, and performance measurement.
Develop reporting frameworks for clinical quality measures, productivity, patient experience, crisis services, and outcome tracking; support federal, state, regulatory, accreditation, and grant-funded reporting.
Collaborate with clinical and operational leaders to identify meaningful metrics and ensure reporting methodologies align with industry standards and organizational objectives.
Develop enterprise reporting for revenue cycle, billing, claims, reimbursement, general ledger, and financial performance management.
Design operational dashboards and scorecards for workforce management, productivity, service delivery, and strategic planning; provide leadership with visibility into financial and operational performance.
Establish and maintain enterprise data governance frameworks and stewardship practices; develop data validation, quality assurance, reconciliation, and auditing processes.
Ensure compliance with regulatory requirements, reporting standards, and organizational policies, and promote data integrity, consistency, accuracy, and transparency.
Lead initiatives to improve data literacy and adoption across the organization.
Advise executive, clinical, operational, finance, and research leadership; translate business requirements into scalable architecture and analytics solutions.
Lead cross-functional data integration, reporting modernization, and analytics transformation projects.
Mentor analysts, developers, and data professionals on architecture, reporting, and data management best practices, and promote data-informed decision-making.