Lead Business Intelligence Developer - IT

Henry Ford Health partners with millions of people on their health journey, across Michigan and around the world. We offer a full continuum of services from primary and preventative care to complex and specialty care, health insurance, a full suite of home health offerings, virtual care, pharmacy, eye care and other health care retail. With former Ascension southeast Michigan and Flint region locations now part of our team, Henry Ford's care is available in 13 hospitals and hundreds of ambulatory care locations. Based in Detroit, Henry Ford is one of the nation's most respected academic medical centers and is leading the Future of Health: Detroit, a $3 billion investment anchored by a reimagined Henry Ford academic healthcare campus.

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.

PRINCIPLE DUTIES AND RESPONSIBILITIES:

• Influence with data insights that are clear and discerning to help leaders make actionable decisions, use compelling and supportive research and knowledge.
• Document process flows and ensures they are monitored for accuracy and quality.
• Work collaboratively with leaders and other teams to understand how data solutions can make a positive impact, consults, designs metrics, reports, and builds solutions as needed.
• Research, reviews, and analyzes the effectiveness and efficiency of existing assets and develops strategies for enhancing or further leveraging them.
• Act as a leader to other team members and provides constructive feedback as necessary
• Independently takes decisions with little or no coaching.
• Routinely participates in webinars and other educational resources to enhance understanding of current developments in healthcare environment.
• Creates recommendations for improving work efficiency, quality, accuracy, and presentation of information.
• Applies statistical concepts and relays findings, resulting in actionable information as needed.
• Serves as a liaison between Analytics and business leaders, guides customers to central intake process, triage and fulfill report requests as assigned by the leader.
• Standardize use of analytics tools and semantic layers throughout the organization.
• Anticipates and works strategically to guide team-members based on advanced knowledge of healthcare trends and requirements.
• Demonstrates competency with highly complex projects, manage large scale projects, monitor timelines for deliverables, with minimal coaching.
• Effectively manages multiple projects with tight timelines simultaneously, maintains composure during high pressure deadlines.
• Act as a resource for others, guides, mentors, provides end-user training on existing or new solutions, create backup resources on the team.
• Creates project work plan with resources identified, backups, including facilitating the following: assignment of tasks, setting deadlines, appropriately sequencing, and defining the critical path of development.
• Understands best practice and regulatory standards and applies them to projects.
• Independently understands driving factors for data needs and provide data in addition to specific request.
• Creates complex scripts utilizing optimized query techniques on complex data tables.
• Comfortable and effective in interacting independently with C-Suite and Physician leaders.
• Does not hesitate in taking the lead in any situation, even in the presence of significant ambiguity.
• Effectively facilitates conflict resolution in politically sensitive situations.
• Anticipates and quickly adapts to meet needs of project and customer.
• Other duties as assigned.

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.