Lead Business Intelligence Developer

Do you envision finding a meaningful role with an inclusive and compassionate team? At Children's Mercy, we believe in making a difference in the lives of all children and shining a light of hope to the patients and families we serve. Our employees make the difference, which is why we have been recognized by U.S. News & World Report as a top pediatric hospital, for eleven consecutive years.

Children's Mercy is in the heart of Kansas City - a metro abounding in cultural experiences, vibrant communities and thriving businesses. This is where our patients and families live, work and play. This is a community that has embraced our hospital and we strive to say thanks by giving back. As a leader in children's health, we engage in meaningful programs and partnerships throughout the region so that we can improve the lives of children beyond the walls of our hospital.

The Lead Business Intelligence Developer is a senior technical leader who delivers trusted, enterprise-grade BI data models and curated datasets that support reporting and self-service analytics across clinical, operational, and other domains. Lead Developer exhibits deep BI expertise and strong leadership, autonomy, and decision-making accountability. Developer sets standards for data modeling, metric definitions, and analytics best practices, while leading by example through hands-on development, technical guidance, and mentorship. The Lead BI Developer partners with cross-functional teams to ensure data accuracy, consistency, and scalability, and plays a key role in prioritization, design decisions, and continuous improvement of BI capabilities. The Lead BI Developer focuses on the analytics consumption and semantic layer, leveraging platforms such as Epic and Databricks, and ensuring analytics-ready data that enables reliable insights and self-service across the organization.

At Children's Mercy, we are committed to ensuring that everyone feels welcomed within our walls. A successful candidate for this position will join us as we strive to create a workplace that reflects the community we serve, as well as our core values of kindness, curiosity, inclusion, team and integrity.

Additionally, it's important to us that we remain transparent with all potential job candidates. Because we value the safety of the patients and families we serve, as well as the Children's Mercy staff, we want to let you know that the seasonal influenza vaccine is a condition of employment for all employees in our organization. New employees must be willing to be vaccinated if found non-immune to measles, mumps, rubella (MMR) and chicken pox (varicella) and/or without evidence of tetanus, diphtheria, acellular pertussis (Tdap) vaccination since 2005. If you are selected for this position, you will be asked to supply your immunization records as proof of vaccination. If you and have any concerns about receiving these vaccines, medical and/or religious exemptions can be further discussed with Human Resources.

Develop and maintain high-quality, reusable BI data products (datasets, semantic models, reports, and dashboards) within the Epic ecosystem (Clarity, Caboodle, Cogito, etc.) to support reliable analytics and self-service reporting across the organization. Provide technical leadership by setting best practices, guiding design decisions, and mentoring team members to elevate overall BI capability.
• Drive adoption and effective use of enterprise governed data products by providing advanced guidance, consultation, and technical leadership to data practitioners and stakeholders, enabling consistent, trusted self-service analytics across the organization with a focus on the Ambulatory and Access spaces.
• Design, build, and maintain reliable, scalable data pipelines and analytics-ready deliverables sourced mainly from the Epic ecosystem (Clarity, Caboodle, Cogito), ensuring accurate extraction, transformation, and integration into the CMDP and other downstream analytics platforms. Provide technical leadership and mentorship to junior BI developers and analytics partners, promoting best practices and consistent, high-quality delivery.

• Bachelor's Degree and 5-7 years' experience. Relevant experience in business intelligence, analytics engineering, data analytics, or related experience. Preferred hands-on exposure to Epic data systems and modern data platforms. OR
• Associate's Degree and 7 or more years' experience. Relevant experience in business intelligence, analytics engineering, data analytics, or related experience. Preferred hands-on exposure to Epic data systems and modern data platforms.
  • At least 1 application specific Epic certification within the first 120 days of hire. Tracked by department leader. Required

The benefits plans at Children's Mercy are one of many reasons we are recognized as one of the best places to work in Kansas City. Our plans are designed to meet the changing needs of our employees and their families.

Our pay ranges are market competitive. The pay range for this job begins at $50.52/hr, but your salaried offer will be determined based upon your education and experience.

This is an intermittent remote position, which means that the person hired will work with his or her manager to determine a schedule that includes both at home and on-site hours at a Children's Mercy location. The incumbent must live in the Kansas City metro area.

Children's Mercy hires individuals based on their job skills, expertise and ability to maintain professional relationships with fellow employees, patients, parents and visitors. A personal interview, formal education and training, previous work experience, references and a criminal background investigation are all factors used to select the best candidates. The hospital does not discriminate against prospective or current employees based on the race, color, religion, sex, national origin, age, disability, creed, genetic information, sexual orientation, gender identity or expression, ancestry or veteran status. A drug screen will be performed upon hire. Children's Mercy is smoke and tobacco free.

CM is committed to creating a workforce that supports the diverse backgrounds of our patients and families. We know that our greatest strengths come from the people who make up our team, so we hire great people from a wide variety of backgrounds, not just because it's the right thing to do, but because it makes our hospital stronger and our patient care more compassionate.

If you share our values and our enthusiasm for service, you will find a home at CM. In recruiting for our team, we welcome the unique contributions that you can bring, including education, ideas, culture, and beliefs.