Business Intelligence Developer

McLaren Health Care; Lansing (MI); On-site; USD 85,000 - 120,000; Full time

Job summary

McLaren Health Care in Lansing, MI is seeking a Business Intelligence Developer for Revenue Cycle to design, build and maintain BI reports, dashboards and data sets that drive revenue cycle performance. You will gather requirements with business users, translate them into specs, develop SQL-based data queries, and provide production support while aligning with BI strategy.

You will collaborate with project leads, analysts and end-users to deliver measurable improvements, while ensuring data

Qualifications

• Bachelor's degree in healthcare or information technology.
• 2 years of experience with BI technologies such as Business Objects, Power BI, and Tableau.
• 2 years of experience writing and tuning advanced SQL.

Responsibilities

• Designs and implements BI reporting applications including dashboards and reports.
• Gathers requirements and translates them into functional specifications for BI reports and dashboards.
• Develops and maintains test strategies and plans for BI solutions.
• Supports BI capabilities and aligns with the organization’s BI strategy.

Skills

Advanced SQL

BI reporting

Data analysis

Education

Bachelor's degree in healthcare or information technology

Tools

Business Objects

Power BI

Tableau

Cerner CCL

Job description

Position Summary:

The Business Intelligence Developer for Revenue Cycle is responsible and proficient in the review and improvements of all aspects of the Revenue Cycle. This includes the monitoring of Revenue Cycle systems, development of reports and data sets, analyzing trends and opportunities, identify root causes and proficient in recommending design improvements.

Essential Functions and Responsibilities:

• Designs and implements reporting applications including, but not limited to, BI dashboards, reporting cubes and batch reports.
• Works with project lead, business users and analysts to gather requirements, conduct design sessions and prepare specifications.
• Translates project requirements into functional and technical specifications for BI reports, dashboards and analytical applications.
• Develops, implements and maintains test strategies and plans.
• Contributes to and supports the organization’s short and long term Business Intelligence strategy.
• Provides production support for Business Intelligence capabilities.
• Works closely with the Systems Administrator to ensure operational efficiency.
• Works with end users on specific questions regarding appropriate use of the BI tools and data.
• Provides strong input into the release timeframe, available resources and fulfills obligations outlined in project plans to deliver a defined release package.
• Assists in managing dependencies and identifying efficiencies to package project deliverables into viable business capabilities/releases.

Qualifications

Required:

• Bachelor's degree in healthcare or information technology
• 2 years of experience working with BI technologies such as Business Objects, Power BI, and Tableau.
• 2 years of experience writing and tuning advance SQL.

Preferred:

• Working knowledge of CPT, HCPCS, and ICD-10
• Two years’ experience in hospital financial services or patient service.
• Certifications:
• Certified Revenue Cycle Representative (CRCR)
• Certified Specialist Business Intelligence (CSBI)
• Proficient in Cerner CCL programming language

Additional Information

• Schedule: Full-time
• Requisition ID: 26011377
• Daily Work Times: 8am - 4:30pm
• Hours Per Pay Period: 80
• On Call: No
• Weekends: No