BCN Claims Business Systems Analyst

With more than 7,000 employees, we are the largest health insurance company in Michigan. We offer an exciting work environment with a diverse group of employees. Our goal is to make health insurance easier for our members. We want to transform the industry and become a resource that people can trust.

Grand Rapids, MI (Hybrid)

Blue Cross Blue Shield of Michigan

When you think of <a href="https://www.bcbsm.com/" target="_blank" rel="noopener noreferrer">Blue Cross Blue Shield of Michigan</a> for health insurance, you can know you&rsquo;re getting much more. We're a company founded on a tradition of affordable, quality health care for everyone, improving the present and investing in the future.&nbsp;<br /><br />We offer:<br />Plans for employers and individuals that meet today&rsquo;s needs, budgets and lifestyle<br />The largest network of doctors and hospitals in the state<br />Lower health care costs Higher quality health care<br />Award-winning diversity practices<br />Grants and programs that promote better health throughout Michigan<br /><strong><br />Mission:&nbsp;</strong>We commit to being our members&rsquo; trusted partner by providing affordable, innovative products that improve their care and health.<br /><br /><a href="http://www.bcbsm.com/index/about-us/our-company.html" target="_blank" rel="noopener noreferrer"><strong>Click here</strong></a> to learn more about our commitment to our Social Mission, view company updates and reviews, and view our awards &amp; accolades.<br /><br />For Application Timeline &amp; Selection Process:&nbsp;<a href="https://s3.amazonaws.com/data.vizirecruiter.com/Images/BCBSMCareers+-+Quick+Reference+Guide.pdf" target="_blank" rel="noopener noreferrer">Click Here</a>. Learn more about your options as an external candidate. <a href="https://ejko.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_3/requisitions" target="_blank" title="BCBSM" rel="noopener noreferrer">Click here</a> to view open positions. http://www.bcbsm.com

keywords: position summary,leadership,analysis,teamwork,management,education,experience,leadership,software,skills

Non-Manager

Competitive Total Compensation Package

Overview: Responsible for analyzing business processes and/or reporting; designs, develops, and maintains complex software applications and reports used by the Claims division to improve department efficiency and support business decision making.
Responsibilities: <ul> <li>Understand business processes in conjunction with leadership to design, develop, implement, and maintain complex Microsoft Access or other designated software databases and applications used to support and improve daily departmental/divisional operations.</li> <li>Work with leadership to understand Macess EXP or other designated software reporting needs to design, develop, implement, and maintain complex SQL Server Reporting Services (SSRS) reports used to support business decision making.</li> <li>Analyze and develop specifications utilizing business input; develop and generate ad hoc reporting requests related to Facets and Macess EXP data.</li> <li>Generate timely and accurate operational reports and extracts for inventory, processing, and operational measurements. Refresh background supportive data tables timely.</li> <li>Document and communicate project concepts, milestones, and results.</li> <li>Recommend and assist with implementing existing and new policies and procedures.</li> <li>Participate in systems testing, develop procedures/controls, and provide recommendations for ongoing improvement of updated processes.</li> <li>Assist internal and external entities through inquiry response, supplying information, and training.</li> <li>Develop and maintain effective working relationships with related business partners.</li> </ul>
Requirements: <ul> <li>Bachelor's Degree in Computer Science, Management Information Systems, or related field preferred.</li> <li>Two (2) years of experience in health care or related field with exposure to claims, systems analysis, and design or database development required.</li> <li>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 application, SQL Server Reporting Services (SSRS) required.</li> <li>Leadership and/or analyst experience required with demonstrated experience in operational analysis, data analysis, and problem resolution type projects and activities.</li> <li>Ability to plan, organize, and control projects.</li> <li>Excellent written and verbal communication skills.</li> <li>Ability to lead and contribute to related projects.</li> <li>Demonstrated knowledge of general statistics, Microsoft Office Suite Software, and related PC or mainframe applications.</li> <li>Other related skills and/or abilities may be required to perform this job.</li> </ul> <br /><strong>Departmental Preferences</strong><br /> <ul> <li>1 to 2 years of experience in MS-Access, including working with tables, queries, forms and VBA code.</li> <li>1 to 2 years of experience with SQL Server, Visual Studio, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS).</li> </ul>