Senior Data Architect

Job Descriptions:

Join us in shaping a healthier future for kids. At Children's Hospital Association, we unite more than 200 member hospitals to put children first-advancing care, informing policy, and driving progress together. Where You'll Work This position is based in our Lenexa, KS office. We leverage a hybrid working model working three days in the office, two days optional remote work. What You'll Do The Senior Data Architect plays a pivotal role in organizing and optimizing CHA's data assets to meet the evolving needs of our members and the data analytics landscape. Leads data modeling, data integration and solution design activities for CHA's comparative data program including the implementation and maintenance of data and analytics solutions. This role supports data architecture development activities within an ecosystem that has multiple database technologies. + Designs and implements end-to-end Azure Cloud based data solutions, including data ingestion from different external and internal domains, storage, processing and security. + Creates logical, conceptual, and physical data models including dimensional schemas (star/snowflake), normalization/denormalization, and data lake medallion architecture. + Interprets business requirements and translate them into scalable, secure, and efficient technical data architecture designs. + Acts as a subject matter expert regarding data architecture and data initiatives. + Implements data governance frameworks aligned with

HIPAA , HITRUST

, and PHI compliance, ensuring data quality and security. + Designs, develops and optimizes data pipelines and

ETL / ELT

processes for healthcare data ingestion and transformation. + Designs solutions and integrations connecting to existing platforms and products ( SQL Server, Azure SQL Managed Instances, Business Objects, Tableau) + Designs hierarchical namespace for CHA data lake layers. + Designs and implements pre-aggregated tables for faster Analytics tool performance. + Stays updated on emerging cloud data technologies and best practices in data architecture. + Leads the development and delivery of appropriate data architecture training. + Develops engineering tests and develops database queries to help team analyze the effects and troubleshoot any issues.

Required Experience:

What You'll Bring to CHA Any combination of education and experience providing the required skill and knowledge is qualifying. + Bachelor's degree in computer science, healt To view full details and how to apply, please login or create a Job Seeker account