[Remote] Analytics Engineer II (Epic Cogito, Power BI)

Note: The job is a remote job and is open to candidates in USA. Children's Health is dedicated to making life better for children through innovative healthcare solutions. The Analytics Engineer II will operationalize analytics artifacts, collaborate with stakeholders, and bridge data engineering and analytics to deliver analytics-ready data assets for clinical and operational domains.

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)
• 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
• 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

Skills

• 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
• 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

Benefits

• Employee portion of medical plan premiums are covered after 3 years.
• 4%-10% employee savings plan match based on tenure
• Paid Parental Leave (up to 12 weeks)
• Caregiver Leave
• Adoption and surrogacy reimbursement

Company Overview