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 maintain quality during high pressure / deadlines with greater complexity and ambiguity. 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, BusinessORApplied Science major.

Six to seven (6-7) years of experience in a healthcareORbusiness 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 cubesORexperience 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 commentingORMS TFS.

Expert in the use of Enterprise DatabasesORElectronic Medical Record system.

Developer level experience in at-least one programming languageORElectronic 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, SSRSORany 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.

Make decisions withDiversity,Equity,Inclusion andJustice 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 on-going training and in-services.

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 on-going training and in-services.

PHYSICAL DEMANDS / WORKING CONDITIONS :

Normal office environment with minimal exposure to noise, dust, or extreme temperatures.

Additional Information

Organization : Corporate Services

Department : Ambulatory Analytics

Shift : Day Job

Union Code : Not Applicable

Additional Details

This posting represents the major duties, responsibilities, and authorities of this job, and is not intended to be a complete list of all tasks and functions. It should be understood, therefore, that incumbents may be asked to perform job-related duties beyond those explicitly described above.

Overview

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. Learn more at henryford.com / careers .

Benefits

The health and overall well-being of our team members is our priority. That’s why we offer support in the various components of our team’s well-being : physical, emotional, social, financial and spiritual. Our Total Rewards program includes competitive health plan options, with three consumer-driven health plans (CDHPs), a PPO plan and an HMO plan. Our team members enjoy a number of additional benefits, ranging from dental and eye care coverage to tuition assistance, family forming benefits, discounts to dozens of businesses and more. Employees classified as contingent status are not eligible for benefits.

Equal Employment Opportunity / Affirmative Action Employer

Equal Employment Opportunity / Affirmative Action Employer Henry Ford Health is

committed to the hiring, advancement and fair treatment of all individuals without regard to

race, color, creed, religion, age, sex, national origin, disability, veteran status, size, height,

weight, marital status, family status, gender identity, sexual orientation, and genetic information,

or any other protected status in accordance with applicable federal and state laws.