Business Systems Analyst Advanced

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.

Detroit, 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 />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,analysis,support,reporting,artificial intelligence,assessment,technical,education,experience,knowledge,skills

Non-Manager

Competitive Total Compensation Package

Overview: <p>Put your technical and analytical skills to work solving complex business challenges at Blue Cross Blue Shield of Michigan. As a Business Systems Analyst Advanced, you&rsquo;ll partner with business and IT teams to identify opportunities, improve systems and processes, and design and implement technology solutions that strengthen performance across the organization.</p>
Responsibilities: <ul> <li>Actuarial and underwriting analytics: Apply actuarial methodologies to data ingestion, transformation, and analytical asset development, including incurred but not reported claims (IBNR), non-claims-based expense (NCBE), medical loss ratios (MLR), risk adjustment, provider and entity arrangements, cohort and segmentation trends, and member-level financial measures.</li> <li>Data modernization and modeling: Support migration from legacy data warehouses to Databricks and enterprise cloud platforms. Develop dimensional data models and analytical assets that support reporting and business analysis.</li> <li>Technical development: Develop, test, debug, document, and maintain SQL, Python, and PL/SQL code, data transformations, and ETL processes.</li> <li>Data quality and reconciliation: Perform validation and reconciliation across claims, membership, premium, and related financial data. Investigate variances, resolve data gaps, and improve data integrity and reporting reliability.</li> <li>Reporting and visualization: Develop and maintain interactive Tableau and Databricks dashboards using multiple data sources, including Databricks, Redshift, and external files.</li> <li>AI-assisted analytics and automation: Develop analytics automation and AI-enabled solutions using tools such as Databricks Genie, Tableau Agent, and Tableau Pulse to improve self-service access and reduce manual analysis.</li> <li>Business requirements and stakeholder engagement: Interview business users, including directors and vice presidents, to identify analytical needs and AI use cases. Translate requirements into technical specifications and clearly communicate findings, recommendations, and demonstrations.</li> <li>Analytical problem-solving: Work under minimal supervision to address complex business problems using statistical, algorithmic, and visualization techniques.</li> <li>Solution assessment and optimization: Evaluate analytical tools against business needs, conduct gap analyses, recommend feasible solutions, and improve application and reporting performance.</li> <li>Delivery and ongoing support: Apply SDLC and Agile methodologies across requirements, design, testing, deployment, documentation, change control, and production support. Support tool adoption and continuous process improvement.</li> </ul>
Requirements: <ul> <li>Bachelor&rsquo;s degree in related field preferred.</li> <li>Three (3) years of relevant technical or business work experience required.</li> <li>Experience in managing cross functional teams or projects required.</li> <li>Advanced knowledge preferred in system development life cycle, process design, re-engineering, and organization transformation, Six Sigma, CMMI or ITIL, and computer programming languages.</li> <li>Basic knowledge of business operations and systems requirement processes.</li> <li>Strong technical, analytical, systems skills.</li> <li>Display innovation in identifying, proposing, and overseeing the execution of business solutions.&nbsp;</li> <li>Written and verbal communication skills; interpersonal skills.</li> <li>Ability to provide technical or business guidance to clients, both internal and external.</li> <li>Ability to work independently, or within a team environment.&nbsp;</li> <li>Other related skills and/or abilities may be required to perform this job.</li> </ul>