BCN Clms Bus Sys Analyst

Blue Cross Blue Shield of Michigan•Grand Rapids, MI

About The Position

Responsible for analyzing business processes and reporting, and designing, developing, and maintaining complex software applications and reports used by the Claims division to improve departmental efficiency and support business decision-making. The role works with leadership to understand business processes and reporting needs, then designs, develops, implements, and maintains databases, applications, and reports supporting daily operations. The position develops specifications and ad hoc reports using Facets and Macess EXP data; generates operational reports and extracts for inventory, processing, and operational measurements; and refreshes supporting data tables. It also documents project concepts, milestones, and results; contributes to policies, procedures, systems testing, controls, and process improvement; assists internal and external entities with inquiries, information, and training; and maintains effective working relationships with business partners.

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, structured query language, object-oriented programming (Microsoft Access or Visual Basic), systems development life-cycle applications, and SQL Server Reporting Services (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.
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 or 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 in conjunction with leadership.
Design, develop, implement, and maintain complex Microsoft Access or other designated software databases and applications supporting departmental and divisional operations.
Work with leadership to identify Macess EXP or other designated software reporting needs and develop complex SQL Server Reporting Services (SSRS) reports.
Analyze business input and develop specifications; create ad hoc reports using Facets and Macess EXP data.
Generate timely, 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 existing and new policies and procedures.
Participate in systems testing, develop procedures and controls, and recommend ongoing process improvements.
Assist internal and external entities by responding to inquiries, supplying information, and providing training.
Develop and maintain effective working relationships with related business partners.