Senior Business Intelligence Developer (Hybrid -Troy, MI) - Populance

Henry Ford Health System; Troy (MI); Hybrid; USD 80,000 - 110,000; Full time

Job summary

An innovative healthcare organization is seeking a Senior Business Intelligence Developer to enhance their data-driven culture. This role involves extracting and analyzing data, generating actionable reports, and collaborating with various stakeholders to optimize data solutions. You'll work with advanced tools and methodologies to support strategic goals and improve healthcare delivery. If you're passionate about using data to drive decisions and improve patient outcomes, this is the perfect opportunity for you.

Benefits

Tuition Assistance

Health Plan Options

Dental and Eye Care Coverage

Family Forming Benefits

Discounts to Businesses

Qualifications

• 3-4 years of experience in a healthcare or business setting.
• Expert in SQL, advanced Excel, and report building.
• Experience with Electronic Medical Record (EMR) systems.

Responsibilities

• Generate reports and develop tools to support business initiatives.
• Collaborate with leaders to understand data needs and design solutions.
• Document processes and provide end-user training on tools.

Skills

SQL

Advanced Excel

Data Visualization

Analytical Skills

Problem-Solving

Communication Skills

Statistical Analysis

Machine Learning Concepts

Education

Bachelor's Degree in Healthcare, Computer Science, Engineering, Mathematics/Statistics, Business, or Applied Science

Tools

Tableau

Power BI

Microsoft Fabric

AWS

Google Cloud

Job description

Senior Business Intelligence Developer (Hybrid -Troy, MI) - Populance

Under the direction of a Manager, Director or Lead/Experienced developer, implements a comprehensive program to extract data using a computer programming language or collect data, then analyze it and effectively report information from this data to a variety of customers in a user-friendly and actionable way. This position generates reports, develops tools and provides consultative support as needed. 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, external oversight/regulatory bodies, or any other user needing information. The Senior Business Intelligence Developer should be able to enhance the data driven culture within the Henry Ford health System, must be able to work in cross-collaboration to gather data, generate reports, develop automated tools, and provides actionable interpretation of information to all the customers.

The candidate must be able to present information to customers at all levels, including but not limited to executives, physicians, clinical staff, peers, and external oversight/regulatory bodies. Independently develop comprehensive data assets, ad-hoc reports and implement new or improved reporting processes to support strategic goals, clinical efforts, and any business initiative. Must be able to work with least amount of direction, manage deadlines, maintain timeliness, delivery, and high quality of the products. Anticipate and quickly adapt to evolving needs of the customer. Consistently demonstrate excellent analytical and problem-solving skills while maintaining keen attention to detail. Candidate must be able to handle complex and ambiguous requests, maintain timeliness of delivery, data quality and manage changing deadlines.

PRINCIPLE DUTIES AND RESPONSIBILITIES:

• Tells a story with data insights that are clear and discerning to help leaders make actionable decisions.
• Takes ownership of tasks, data assets, tools, and project goals to work towards overall success of the business initiatives.
• Works collaboratively with leaders and teams to understand how data solutions can make a positive impact.
• Consults, designs metrics, reports, and builds solutions as needed.
• Documents the process flows and ensures they are monitored for accuracy and quality, train others to create backup support.
• Provides end-user training on existing tools.
• Routinely participates in webinars and other educational resources to enhance understanding of current developments in healthcare environment.
• Generates suggestions for improving work efficiency and promoting quality, demonstrates accuracy and thoroughness.
• Guides customers to the central intake process, triage and fulfill report requests as assigned by the leader.
• Serves as a liaison between Analytics and business leaders.
• Research, reviews, and analyzes the effectiveness and efficiency of existing report procedures and develops strategies for enhancing or further leveraging these processes.
• Creates complex scripts utilizing optimized query techniques on complex data tables.
• Standardizes 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.
• Independently understands driving factors for data needs and provide data elements in addition to specific request.
• Self-manage projects and timelines.

The Senior Business Intelligence Developer will work within Populance Analytics and available applications serving various clients, each with specific requirements and responsibilities such as:

• Preferred knowledge of healthcare and statistical analysis.
• Work with backend data for Clinical Delivery Systems and Financial Data Systems.
• Collaborate with operational stakeholders and organizational leaders to understand data needs, design reports, and build solutions.
• Act as a liaison between Analytics and Operational leaders.
• Gather requirements, identify solutions, create delivery plans, and pull data from internal and external systems.
• Create reports, metrics, tools, data models, dashboards, and fulfill data needs.
• Work on Per-Member-Per-Month, Case Management, Ambulatory, Utilization Management, and other similar tasks.

EDUCATION/EXPERIENCE REQUIRED:

• Bachelor's Degree with a Healthcare, Computer Science, Engineering, Mathematics/Statistics, Business, OR an Applied Science major.
• Three to four (3-4) years of experience in a Healthcare OR Business setting.
• Expert in the use of advance Excel, SQL, report building, tool development, requirements gathering and technical documentation.
• Experience in the use and design of Relational Databases, Data Models, Data Visualizations, curated datasets, data cubes OR experience in Electronic Medical Record(EMR) report development, functionality of any EMR(Epic, Cerner, McKesson or other widely used EMRs).
• Maintain code repositories on SCM system, familiar with merging, pushing, pulling, branching, staging and code commenting OR MS TFS.
• Good understanding of fundamental Computer Programming concepts OR Electronic Medical Record systems.
• Basic understanding of Statistical and Machine Learning concepts.
• Basic understanding of dimensional models and Data Warehouse OR Electronic Medical Record system.
• Experience in any Business Intelligence tools such as Tableau, Cognos, Looker, Toad, Minitab, Power BI, Qlik, SSRS OR any other.
• Develop multidimensional semantic layer and analytics query objects for end-users.
• Proven customer service experience with strong active listening skills.
• Able to present complex information to diverse audiences.
• Excellent written and verbal communication skills.

Experience Preferred:

• Cloud Platforms: Proficiency with platforms like Microsoft Fabric, Azure Data Factory, AWS, or Google Cloud (with a preference for Microsoft Cloud).
  Data Visualization Tools: Proficiency with platforms like Microsoft Power BI, Tableau, Qlik, or other similar applications (with a preference for Microsoft Power BI).
• ETL/ELT Processes: Experience in data integration and pipeline development.
• Performance Optimization: Skills in query tuning, report performance, and data refresh optimization.
• CI/CD & DevOps: Implementing automated deployments for BI reports and ETL workflows.
• Automation & Scripting: Proficiency in Python and PowerShell for data processing and workflow automation.
• Advanced Analytics Support: Integrating BI solutions with ML/AI models.
• Data Governance & Security: Knowledge of row-level security (RLS) and data compliance (GDPR, HIPAA).

Additional Information

• Organization: Populance
• Department: Analytics and Insights
• Shift: Day Job
• Union Code: Not Applicable

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 .

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 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.

Previous Job Searches

My Profile

Create and manage profiles for future opportunities.