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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Job Type
Full-time
Career Level
Mid Level