[Hiring] Senior Data Engineer @Blue Cross Blue Shield of Massachusetts

Role Description

At Blue Cross Blue Shield of Massachusetts, we have an exciting opportunity for a Data Engineer to join our Data Delivery team. The primary focus of this role is to design, develop, and maintain our IBM Planning Analytics (TM1) models and applications to enhance our financial planning, forecasting, and reporting capabilities. You will play a crucial role in supporting strategic business decisions by working alongside senior engineers and finance stakeholders to build robust data solutions.

This position is open to candidates based in Massachusetts as well as remote, US-based candidates.

Your Day to Day

• Design and build forecasting/budgeting applications using Planning Analytics 2.0.9 or above.
• Design and build PA cubes, dimensions, hierarchies, rules, and TurboIntegrator processes using Planning Analytics Workbench (PAW).
• Experience writing complex MDX statements, rules and feeders.
• Experience with data ingestion and transformation from ODBC data sources and publish data for consumption related to TM1 cubes, dimensions, hierarchies, rules, and TurboIntegrator (TI) processes to support actuarial models including claims projections, financial forecasting, and expense allocation.
• Experience in building applications in TM1 web, PAW and Perspectives (TM1 combined with VBA), build dynamic reports.
• Experience in working with IBM Cloud Planning Analytics applications and migration of applications from TM1 to PA.
• Follows best practices and architecture patterns as part of all implementations.
• Builds deep understanding of healthcare data domains through process ownership, data exploration and hands-on SQL development.
• Designs & develops data quality, data masking, data curation & extraction processes for appropriate data usage.
• Oversee TM1 security configurations, user access groups, and server performance monitoring.
• Provides operational support to high severity issues and incidents impacting critical data pipelines.
• Build, maintain, and distribute active forms, slices, and web sheets via TM1 Web or Planning Analytics Workspace (PAW) for business unit leaders.
• Ideates & builds common data processing utilities leveraging modular development methodologies.
• Delivers high quality and scalable code with automated test coverage.
• Helps grow and mentors team members on the fine art of data engineering and software abstractions.
• Works closely with the Actuarial teams to translate complex business planning rules into automated TM1 system logic.

Qualifications

• 5-7 years of data engineering experience with at least 5+ years of experience as an IBM Cognos TM1 / Planning Analytics Developer (PAW, PAX).
• 5+ years of experience with cloud platforms like AWS, Azure, Google.
• 5+ working with Rules, Feeders & worksheets.
• 5+ working experience in MDX.
• Strong mastery of TurboIntegrator (TI) scripting and TM1 Rules (DB functions, Feeders).
• Advanced Excel skills, including VBA, Active Forms, and complex financial modeling.
• Health Care Domain working in Budgeting and Forecasting is preferred.

Requirements

• Bachelor’s degree in computer science, Finance, Math, Information Systems, or a related field.
• Strong verbal and written communication skills, with the proven ability to express complex technical concepts effectively to non-technical finance stakeholders.
• Excellent problem-solving and analytical skills, with keen attention to detail.
• Ability to multi-task, self-motivate, and meet critical financial reporting deadlines in a fast-paced environment.
• Healthcare industry experience is preferred.

Benefits

• Comprehensive package of benefits including paid time off, medical/dental/vision insurance, 401(k), and a suite of well-being benefits to eligible employees.
• Salary Range: $138,870.00 - $169,730.00.
• This job is also eligible for variable pay.