Analytics Engineer II (Microsoft Fabric, Epic Cogito, Power BI)

Children's Health is hiring an Analytics Engineer II to operationalize analytics products across clinical and operational domains. The role builds and maintains semantic layers, metrics stores, and data marts, while improving data quality and performance and collaborating with stakeholders to support domain KPIs and BI consumption.

Responsibilities:

• Prepare and model analytically ready datasets; implement and maintain semantic layers, metrics stores or data marts; apply data engineering best practices to analytics (version control, CI/CD, environment management); collaborate with BI analysts, data scientists and domain stakeholders to operationalize analytics products; ensure alignment with governance and data quality requirements
• Design and implement semantic layer components (metrics store objects, analytical models, data marts) to support domain KPIs and BI consumption
• Implement automated testing, CI/CD pipelines and deployment promotion for analytics products; own environment management for domain artifacts
• Lead data quality monitoring for analytics products and collaborate with data stewards to remediate issues; maintain metadata and lineage in the catalog
• Optimize query and semantic performance for BI tools; implement best practices to reduce dashboard sprawl and inconsistent metrics
• Collaborate with clinical and operational stakeholders to translate clinical workflows and EHR/ERP data into repeatable analytics products (e.g., procedure-level cost and outcomes dashboards, inventory visibility reports)
• Work with EHR/clinical data and supply‑chain/ERP data sources, follow interoperability expectations (FHIR/HL7 awareness for clinical integrations), support clinical analytics use cases (procedural analytics, outcomes measurement, preference card analytics) and supply‑chain analytics (spend, contract, inventory visibility) when relevant
• Version control of analytics content, separate dev/test/prod environments, workflow orchestration, metadata/cataloging and performance testing to improve model uptime, adoption, code quality and defect resolution
• Adhere to organizational data governance, privacy and security requirements (e.g., HIPAA-relevant controls), and collaborate with governance or ARB where analytics/AI artifacts will be used in clinical or high-risk contexts

Requirements:

• Domain collaboration (e.g. clinical, financial, or supply chain), stakeholder facilitation and problem-solving skills
• Ability to translate business KPIs into reproducible metrics-as-code and communicate technical concepts to a wide range of stakeholders
• Ability to mentor junior engineers
• FHIR/HL7 awareness for clinical integrations
• At least 3 years In analytics/data roles with demonstrated delivery of analytics artifacts, experience with dbt or other analytics engineering tools, and hands-on CI/CD and orchestration tool usage
• At least 3 years Advanced SQL, dbt or equivalent transformation frameworks, familiarity with metrics store concepts and knowledge-graph/ontology basics for semantic enrichment where applicable
• At least 3 years Ability to implement CI/CD for analytics, automated testing, environment promotion and metadata/catalog integration
• At least 3 years Proficiency with at least one cloud data platform (Snowflake, Databricks, MS Fabric) and BI tool optimizations (Power BI/Tableau performance tuning)
• Four-year Bachelor's degree or equivalent experience in Computer Science, MIS, Engineering, or related field
• Analytics related certifications (e.g. Dbt Analytics Engineering, Microsoft Fabric Analytics Engineer Associate, Snowflake SnowPro, Databricks, Epic Cogito) or a learning plan requirement to be provided with offer includes missing relevant certifications needed to perform role, and certifications must be obtained within 180 days of starting first class
• Epic Cogito Fundamentals and Caboodle Data Model experience
• At least 1 year Exposure to machine learning, data science, or artificial intelligence concepts
• At least 1 year Experience working in healthcare or other regulated industry