Lead Business Intelligence Developer

At Henry Ford Health, we're committed to advancing health and improving lives for the millions of people we serve across Michigan and around the world. As one of the nation's leading academic health systems, we provide a comprehensive continuum of care that includes primary and preventive services, specialty and complex care, virtual care, pharmacy, home health, eye care, health insurance, and more. With 12 hospitals and hundreds of ambulatory care locations, including former Ascension Southeast Michigan and Flint Region facilities, our growing network expands access to exceptional care in the communities we serve.

Headquartered in Detroit, Henry Ford Health is helping shape the future of healthcare through the transformative Future of Health: Detroit initiative, a $3 billion investment that is redefining our academic healthcare campus and advancing innovation, research, education, and community impact.

Our work is grounded in purpose, collaboration, and belonging. We empower team members to grow their careers, contribute innovative ideas, and make a meaningful difference every day. Whether you're caring for patients, supporting operations, conducting research, or driving new solutions, you'll be part of a team united by a shared mission: delivering exceptional care, advancing health outcomes, and building healthier communities for all.

Job Description

GENERAL SUMMARY:

Under the direction of a Manager, Director, or a Leader, develops and implements a comprehensive program to extract (using a computer language) or collect data, analyze it, and effectively report information from this data to a variety of customers in a user-friendly and actionable way. Able to conduct complex statistical analysis and develop new approaches to measurements and presentation of information. Our customers include physicians, physician groups, physician leaders, hospital leaders, the Board of Trustees, system leadership, transformation consulting, clinical/non-clinical services, Markets, Community, Service Lines, Revenue Cycle, Finance, any user needing information and external oversight/regulatory bodies. This position generates reports and supports comparative database assessment and maintenance regarding performance, clinical, operational, and improvement efforts. Mentor other developers to ensure the spread of knowledge, skills, and backup support. Rises to the varying demands and maintain quality during high pressure/deadlines with greater complexity and ambiguity. The Lead Business Intelligence Developer is a completely independent member of Core Analytics and plays a pivotal role in enhancing the data driven culture at Henry Ford Health System. The role is a trusted advisor to organization's leaders and team members in providing actionable interpretation of the information. Demonstrate reliability and expertise in working with and presenting information to customers at all levels, including but not limited to executives, physicians, clinical staff, peers, and external oversight/regulatory bodies. Must work with least amount of direction, manage deadlines, and maintain timeliness, delivery, and high quality of the products. Develops comprehensive solutions, ad-hoc reports, implements new or improved reporting processes to support strategic and clinical goals of the business operations. The Lead Developer fulfills complex requests, works effectively, provides clarity in ambiguous situations, manages deadlines, maintains timeliness, and quality of products. Engage and quickly adapts to evolving needs of the customers. Consistently demonstrate excellent analytical and problem-solving skills while maintaining keen attention to detail. Exemplifies leadership qualities and solution-creation mindset.

Qualifications

EDUCATION/EXPERIENCE REQUIRED:

• Bachelor's Degree with a Healthcare, Computer Science, Engineering, Mathematics/Statistics, Business OR Applied Science major.
• Six to seven (6-7) years of experience in a healthcare OR business setting.
• Expert in the use of SQL, advance Excel, report building, tool development, requirement gathering and technical documentation.
• Experience in developing Relational Databases, Data Models, Data Visualizations, curated datasets, data cubes OR experience in Electronic Medical Record System (EMR) report development, functionality of any EMR (Epic, Cerner, McKesson or other widely used EMRs).
• Maintain code repositories on SCM system, merging, pushing, pulling, branching,
• staging and code commenting OR MS TFS.
• Expert in the use of Enterprise Databases OR Electronic Medical Record system.
• Developer level experience in at-least one programming language OR Electronic
• Medical Record system. Good understanding of dimensional models, de-normalized, normalized, unstructured, Hierarchical, Object-Oriented databases and Warehouse, be able to work on the development of data models. Basic understanding of Statistical and Machine Learning concepts.
• Expertise in data analysis, visualizations, and requirements gathering & documentation.
• Experience in any Business Intelligence tool like Tableau, Cognos, Looker, Toad, Minitab, Power BI, Qlik, SSRS OR any other.
• Working knowledge of Statistical analysis, sampling, confidence interval, distributions, control charts etc.
• Develop multidimensional semantic layer and analytics query objects for end-users.
• Proven customer service experience with strong active listening skills.
• Effectively and influentially presents complex information to diverse audiences.
• Expert written and verbal communication skills.