Business Systems Analyst Advanced

Blue Cross Blue Shield of Michigan•Detroit, MI

About The Position

At Blue Cross Blue Shield of Michigan, the Business Systems Analyst Advanced applies technical and analytical skills to solve complex business challenges. The role partners with business and IT teams to identify opportunities, improve systems and processes, and design and implement technology solutions that strengthen organizational performance. The position supports actuarial and underwriting analytics, including data ingestion, transformation, and analytical asset development for 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. It also supports migration from legacy data warehouses to Databricks and enterprise cloud platforms, and develops dimensional data models and analytical assets for reporting and business analysis. The analyst develops, tests, debugs, documents, and maintains SQL, Python, and PL/SQL code, data transformations, and ETL processes. Work includes validating and reconciling claims, membership, premium, and related financial data; investigating variances and data gaps; and improving data integrity and reporting reliability. The role develops and maintains interactive Tableau and Databricks dashboards using sources such as Databricks, Redshift, and external files, and develops analytics automation and AI-enabled solutions using tools such as Databricks Genie, Tableau Agent, and Tableau Pulse. The analyst interviews business users, including directors and vice presidents, to identify analytical needs and AI use cases, translates requirements into technical specifications, and communicates findings, recommendations, and demonstrations. With minimal supervision, the position addresses complex business problems using statistical, algorithmic, and visualization techniques; assesses tools and solutions against business needs; conducts gap analyses; and recommends improvements to application and reporting performance. The role applies SDLC and Agile methodologies across requirements, design, testing, deployment, documentation, change control, and production support, while supporting tool adoption and continuous process improvement.

Requirements

  • Three years of relevant technical or business work experience.
  • Experience managing cross-functional teams or projects.
  • Basic knowledge of business operations and systems requirement processes.
  • Strong technical, analytical, and systems skills.
  • Ability to identify, propose, and oversee execution of business solutions.
  • Written and verbal communication skills and interpersonal skills.
  • Ability to provide technical or business guidance to internal and external clients.
  • Ability to work independently or within a team environment.
  • Other related skills and/or abilities may be required to perform the job.

Nice To Haves

  • Bachelor's degree in a related field.
  • Advanced knowledge of system development life cycle, process design, re-engineering, and organizational transformation.
  • Knowledge of Six Sigma, CMMI, or ITIL.
  • Knowledge of computer programming languages.

Responsibilities

  • Apply actuarial methodologies to data ingestion, transformation, and analytical asset development for IBNR, NCBE, MLR, risk adjustment, provider and entity arrangements, cohort and segmentation trends, and member-level financial measures.
  • Support migration from legacy data warehouses to Databricks and enterprise cloud platforms.
  • Develop dimensional data models and analytical assets for reporting and business analysis.
  • Develop, test, debug, document, and maintain SQL, Python, and PL/SQL code, data transformations, and ETL processes.
  • Validate and reconcile claims, membership, premium, and related financial data; investigate variances, resolve data gaps, and improve data integrity and reporting reliability.
  • Develop and maintain interactive Tableau and Databricks dashboards using multiple data sources, including Databricks, Redshift, and external files.
  • Develop analytics automation and AI-enabled solutions using tools such as Databricks Genie, Tableau Agent, and Tableau Pulse.
  • Interview business users, including directors and vice presidents, to identify analytical needs and AI use cases.
  • Translate requirements into technical specifications and communicate findings, recommendations, and demonstrations.
  • Address complex business problems using statistical, algorithmic, and visualization techniques while working under minimal supervision.
  • Evaluate analytical tools against business needs, conduct gap analyses, recommend feasible solutions, and improve application and reporting performance.
  • Apply SDLC and Agile methodologies to requirements, design, testing, deployment, documentation, change control, and production support.
  • Support tool adoption and continuous process improvement.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service