Lead Business Intelligence Developer - Full time - Detroit

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. 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 maintains quality during high pressure/deadlines with greater complexity and ambiguity. The role is a trusted advisor to the organizations 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 the 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 demonstrates 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, using compelling and supportive research and knowledge. Document process flows and ensure they are monitored for accuracy and quality. Work collaboratively with leaders and other teams to understand how data solutions can make a positive impact, consult, design metrics, reports, and build solutions as needed. Research, review, and analyze the effectiveness and efficiency of existing assets and develop strategies for enhancing or further leveraging them. Act as a leader to other team members and provide constructive feedback as necessary. Independently take decisions with little or no coaching. Routinely participate in webinars and other educational resources to enhance understanding of current developments in the healthcare environment. Create recommendations for improving work efficiency, quality, accuracy, and presentation of information. Apply statistical concepts and relay findings, resulting in actionable information as needed. Serve as a liaison between Analytics and business leaders, guiding customers to the central intake process, triaging and fulfilling report requests as assigned by the leader. Standardize the use of analytics tools and semantic layers throughout the organization. Anticipate and work strategically to guide team members based on advanced knowledge of healthcare trends and requirements. Demonstrate competency with highly complex projects, manage large scale projects, monitor timelines for deliverables, with minimal coaching. Effectively manage multiple projects with tight timelines simultaneously, maintaining composure during high pressure deadlines. Act as a resource for others, guide, mentor, provide end-user training on existing or new solutions, and create backup resources on the team. Create project work plans with resources identified, backups, including facilitating the following: assignment of tasks, setting deadlines, appropriately sequencing, and defining the critical path of development. Understand best practices and regulatory standards and apply them to projects. Independently understand driving factors for data needs and provide data in addition to specific requests. Create complex scripts utilizing optimized query techniques on complex data tables. Comfortable and effective in interacting independently with C-Suite and Physician leaders. Do not hesitate to take the lead in any situation, even in the presence of significant ambiguity. Effectively facilitate conflict resolution in politically sensitive situations. Anticipate and quickly adapt to meet the needs of projects and customers. 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, advanced 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 systems, merging, pushing, pulling, branching, staging, and code commenting

OR

MS TFS. Expert in the use of Enterprise Databases

OR

Electronic Medical Record systems. 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, 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 layers and analytics query objects for end-users. Proven customer service experience with strong active listening skills. Effectively and influentially present complex information to diverse audiences. Expert written and verbal communication skills. Make decisions with

D iversity,

E quity,

I nclusion and

J ustice in mind. CERTIFICATIONS/LICENSURES REQUIRED: Must meet or exceed core customer service responsibilities, standards, and behaviors as outlined in the HFHS Customer Service Policy. Must practice the customer skills as provided through ongoing training and in-services. PHYSICAL DEMANDS/WORKING CONDITIONS: Normal office environment with minimal exposure to noise, dust, or extreme temperatures. Organization: Corporate Services Department: Access Improvement Shift: Day Job Union Code: Not Applicable

#J-18808-Ljbffr