Data Architect

Purpose

Under the direction of the Director of Clinical Informatics, the Data Architect provides strategic and technical leadership for the agency’s data architecture, platforms, integrations, databases, and analytics environment. The role serves as the technical lead for the Data Engineering team, overseeing the design and implementation of secure, scalable, and reliable data solutions.

The Data Architect will develop and maintain a comprehensive understanding of the agency's clinical and operational data, electronic health record (EHR) systems, applications, interfaces, integrations, databases, reporting environments, and data flows. The position will provide leadership in the adoption, administration, architecture, and optimization of Microsoft Fabric and related Microsoft data technologies.

Function

1.Provides technical leadership, direction, and mentorship to Data Engineers and other members of the data team, establishing standards, data modeling, priorities, best practices, development methodologies, troubleshooting/problem solving, and optimization.

2.Provides technical leadership and oversight for major data-related projects, including system implementations, application upgrades, migrations, integrations, data conversions, platform modernization, and new technology initiatives.

3.Leads the development and implementation of integration solutions using Microsoft Fabric and related Microsoft technologies, including data ingestion, transformation, orchestration, storage, modeling, and analytics.

4.Oversees the development of reliable and reusable data pipelines and processes that support reporting, analytics, business intelligence, quality initiatives, regulatory reporting, and executive dashboards, ensuring solutions are built upon reliable and governed data structures.

5.Provides technical oversight and direction for the development and maintenance of Microsoft SQL Server databases, SQL-based solutions, data warehouses, and other relational database technologies.

6.Investigates and resolves complex data discrepancies, integration issues, performance problems, and architectural challenges across multiple applications and data sources.

7.Leads the architecture, implementation, administration, optimization, and ongoing development of the agency's Microsoft Fabric environment and associated data services.

8.Designs and maintains enterprise data architecture that integrates clinical, operational, financial, human resources, quality, and other organizational data sources while maintaining appropriate security, privacy, and compliance controls.

9.Establishes architectural standards and technical direction for data warehouses, data lakes, lakehouses, data pipelines, semantic models, data marts, databases, APIs, interfaces, and other data integration technologies.

10.Develops and maintains enterprise data models, logical and physical data structures, data dictionaries, metadata standards, naming conventions, and data lineage documentation.

11.Leads the development, implementation, and maintenance of enterprise data integration strategies connecting the EHR, clinical applications, business systems, external applications, APIs, and other data sources.

12.Initiates processes for monitoring data quality, pipeline performance, system performance, data availability, and overall reliability of enterprise data services.

13.Establishes appropriate development, testing, quality assurance, deployment, change management, and version-control processes for data engineering solutions and across the Data Team.

14.Develops and maintains documentation of enterprise data architecture, system integrations, data flows, data models, data lineage, technical standards, and data governance processes.

15.Evaluates current data systems and develops and maintains data architecture roadmaps and recommend priorities for platform modernization, technology adoption, technical debt reduction, and improvements to data capabilities.

16.Ensures appropriate access controls, permissions, authentication, authorization, and security practices are incorporated into data architecture and data solutions.

17.Works with IT and security personnel to ensure that data platforms and architecture comply with organizational security standards, HIPAA requirements, privacy regulations, and other applicable compliance requirements.

18.Leads the design and implementation of data governance practices to improve data quality, consistency, availability, security, ownership, accountability, and appropriate use throughout the agency.

19.Serves as the agency's lead resource for enterprise data architecture, data engineering strategy, data integration, data modeling, data governance, and data platform development.

20.Supports executive leadership by providing data architecture expertise and helping translate organizational objectives into sustainable data strategies and technical solutions.

21.Maintains transparency and communication regarding data architecture initiatives, project status, risks, dependencies, technical decisions, resource requirements, and escalated issues.

22.Serves as a subject matter expert for Microsoft Fabric, data architecture, data engineering, SQL Server, Power BI, data integration, data modeling, data governance, and enterprise analytics.

23.Collaborates with physicians, nurses, pharmacists, clinicians, Data Analysts, Data Engineers, and other healthcare professionals to understand information needs and develop effective data solutions.

24.Maintains an understanding of healthcare data standards, clinical terminology, healthcare workflows, and the unique requirements associated with behavioral health, medical, rehabilitation, and other clinical environments.

25.Communicates complex technical concepts in a clear and understandable manner to both technical and non-technical audiences.

26.Demonstrates exceptional patience, professionalism, and calm demeanor in a high-stress and demanding environment.

27.Demonstrates knowledge of emergency procedures and assists in crisis situations as required.

28.Must be physically able to lift computer equipment that may weigh up to 25 lbs.

29.Regular and predictable attendance is required.

30.May be required to work holidays and/or after-hours on-call as requested.

31.Must be willing and able to perform all job-related travel normally associated with this position.

32.Performs other duties as assigned by immediate supervisor or other management as requested.

Prerequisites

BA/BS degree in Information Management, Computer Science, Data Science, Information Technology, Healthcare Administration, or another related field preferred; an equivalent combination of education and experience may be considered.

Master's degree in Computer Science, Data Science, Information Technology, Healthcare Administration, Clinical Informatics, or another related field preferred.

5+ years of progressively responsible experience in data engineering, data architecture, information systems, business intelligence, database development, analytics, or a related field preferred.

3+ years of experience with Microsoft SQL Server, SQL development, relational databases, and data modeling required.

3+ years of experience with Power BI and enterprise data analytics required.

Strong experience with data architecture within Microsoft Fabric components and capabilities, including designing and implementing Lakehouse, Data Warehouse, Data Factory/Data Pipelines, notebooks, semantic models, APIs, and related data engineering and analytics technologies required.

Experience working with HIPAA-regulated data and healthcare privacy and security requirements preferred.

Skills

• Advanced knowledge of Microsoft Fabric and modern cloud data architecture.
• Strong knowledge of Microsoft data technologies, including SQL Server, Power BI, Microsoft Fabric, data pipelines, data warehousing, and data integration.
• Strong understanding of relational databases, dimensional modeling, data structures, normalization, denormalization, and enterprise data architecture.
• Strong understanding of modern data lake, lakehouse, data warehouse, and cloud data platform architectures.
• Advanced SQL development and data analysis skills.
• Strong understanding of data governance, data quality, metadata, data lineage, master data, and data security principles.
• Strong understanding of Power BI, semantic models, datasets, reporting architecture, and business intelligence environments.
• Ability to design scalable, secure, highly available, and maintainable data solutions.
• Ability to translate complex clinical and business requirements into enterprise data architecture and technical solutions.
• Ability to analyze complex data environments and identify opportunities for integration, modernization, automation, and optimization.
• Ability to establish and enforce technical standards, architecture patterns, coding standards, and development practices.
• Strong technical leadership, project management, organizational, and decision-making skills.
• Superior analytical, oral, and written communication skills.
• Strong problem-solving and critical-thinking skills.
• Strong understanding of IT application, infrastructure, networking, security, privacy, and compliance requirements.
• Knowledge of ECHO and/or current electronic health/medical records systems.
• Understanding of medical terminology, clinical workflows, and healthcare data is critical.
• Ability to communicate complex technical concepts effectively to clinicians, executives, management, analysts, engineers, and other non-technical stakeholders.
• Detail-oriented and capable of developing innovative solutions to complex technical and organizational problems.
• Must be a methodical, pragmatic, and strategic problem-solver.
• Ability to work under pressure, manage competing priorities, and meet deadlines.
• Ability to prioritize multiple projects and organize large amounts of technical information while determining appropriate courses of action.
• Ability to work independently, exercise sound judgment and creativity, and maintain a positive attitude.
• Ability to maintain confidentiality of all medical, financial, legal, and organizational information.
• Ability to complete work assignments accurately and in a timely manner.
• Ability to maintain accurate technical documentation, records, and necessary paperwork.
• Must have adequate individual coping skills.
• Proficient in Microsoft Office, including Excel, Outlook, Word, and related applications.
• Proficient typing skills with a minimum of 50 words per minute