Business Intelligence Developer

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.

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

The McLaren system includes 12 hospitals across the state, ambulatory surgery centers, imaging centers, a 730-member employed primary and specialty care physician network, commercial and Medicaid HMOs covering more than 242,000 Michigan lives, home health, infusion and hospice providers, pharmacy services, a clinical laboratory network, and a wholly owned medical malpractice insurance company. McLaren operates Michigan’s largest network of cancer centers and providers, anchored by the Karmanos Cancer Institute, a National Cancer Institute-designated comprehensive cancer center. McLaren has 20,000 full-, part-time and contracted employees and more than 93,000 network providers throughout Michigan.