Job Details

McLaren Health Plan, recognized by Modern Health Care as one of the 100 Best Places to Work for four years in a row, is seeking a Reporting Specialist II to join our Team!

JOB SUMMARY

Responsible for the development and maintenance of management, standard production, customer, regulatory, and ad hoc reports.

Required Qualifications:

• Bachelor’s Degree in computer science, business, health care or related field. An equivalent combination of relevant education and experience may be substituted for the educational requirement.
• Two (2) years of experience creating and analyzing complex reports.
• Proficient in writing, modifying and executing SQL queries and SQL stored procedures.
• Demonstrated ability to create, modify and design MS Access databases
• Exceptional skills in the development of financial spreadsheets using Microsoft Excel and other programs.
• Proficient in extracting, manipulating, converting and integrating data to and from various systems.
• Experience with report development and data mining software such as SSRS, Crystal Reports, and Monarch.

Preferred Qualifications:

• Knowledge of health care claims billing/reimbursement practices and data including CPT, HCPCS, ICD9/10, Revenue and DRG codes.
• Experience working for an HMO, TPA, PPO or managed care entity.
• Experience working with state and federal regulatory agencies.

NOTE: To further our mission of enhancing the health status of the individuals and communities we serve, effective February 1, 2013,McLaren Health Plan will no longer hire individuals who use tobacco or nicotine products in any form. Cotinine testing will be used to verify non-tobacco use. Individuals whose health screening results are verified positive for tobacco/nicotine use will be disqualified from employment, their job offer will be rescinded, and they will be disqualified from reapplying for employment for six (6) months from the date of the health screening.