BCN Clms Bus Sys Analyst

Blue Cross Blue Shield of Michigan

About The Position

The Business Systems Analyst analyzes business processes and reporting, and designs, develops, and maintains complex software applications and reports for the Claims division to improve efficiency and support business decision-making. Working with leadership, the analyst translates business processes and needs into Microsoft Access or other designated databases and applications that support daily departmental and divisional operations. The role also develops and maintains SQL Server Reporting Services (SSRS) reports based on Macess EXP or other designated reporting needs, and creates ad hoc reports using Facets and Macess EXP data. The analyst generates operational reports and extracts for inventory, processing, and operational measurements; refreshes supporting data tables; documents and communicates project concepts, milestones, and results; and recommends or helps implement policies and procedures. The role participates in systems testing, develops procedures and controls, and recommends process improvements. It also supports internal and external entities by responding to inquiries, supplying information, and providing training, while maintaining effective working relationships with business partners. The position is located in Grand Rapids or Detroit.

Requirements

Two years of experience in health care or a related field, with exposure to claims, systems analysis and design, or database development.
Experience with relational databases, structured system programming and coding schemes, SQL, object-oriented programming (Microsoft Access or Visual Basic), systems development life cycle applications, and SSRS.
Leadership and/or analyst experience, including demonstrated experience in operational analysis, data analysis, and problem-resolution projects and activities.
Ability to plan, organize, and control projects.
Excellent written and verbal communication skills.
Ability to lead and contribute to related projects.
Demonstrated knowledge of general statistics, Microsoft Office Suite software, and related PC or mainframe applications.
Other related skills and/or abilities may be required to perform the job.

Nice To Haves

Bachelor's degree in Computer Science, Management Information Systems, or a related field is preferred.
Experience in systems reporting and a solid understanding of database development, testing, and integration methodologies.
Some project management experience.
Accuracy and attention to detail.
Experience with SSIS, SQL, Microsoft Power Platform, and AI for analytics involving conversational, natural-language interaction and automated workflows for data reporting.
Ability to develop, maintain, and support existing reporting tools, automation solutions, dashboards, and related processes.

Responsibilities

Analyze business processes and reporting needs for the Claims division.
Design, develop, implement, and maintain complex Microsoft Access or other designated software databases and applications.
Work with leadership to design, develop, implement, and maintain complex SSRS reports for business decision-making.
Analyze business input and develop specifications; create ad hoc reports using Facets and Macess EXP data.
Generate timely and accurate operational reports and extracts for inventory, processing, and operational measurements.
Refresh supporting background data tables in a timely manner.
Document and communicate project concepts, milestones, and results.
Recommend and assist with implementing policies and procedures.
Participate in systems testing, develop procedures and controls, and recommend ongoing process improvements.
Respond to inquiries, supply information, and provide training to internal and external entities.
Develop and maintain effective working relationships with related business partners.