Senior Data Engineer

Blue Cross Blue Shield of Massachusetts•Boston, MA

1d•$138,870 - $169,730•Remote

About The Position

Blue Cross Blue Shield of Massachusetts is hiring a Data Engineer for its Data Delivery team. The role focuses on designing, developing, and maintaining IBM Planning Analytics (TM1) models and applications that support financial planning, forecasting, and reporting. The engineer works with senior engineers and finance stakeholders to build data solutions for strategic business decisions, including actuarial models for claims projections, financial forecasting, and expense allocation. The position supports forecasting and budgeting applications, data ingestion and transformation, data quality and curation, TM1 security and performance monitoring, and operational support for critical data pipelines. It also involves collaborating with Actuarial teams to translate business planning rules into TM1 system logic, building reusable data-processing utilities, delivering tested and scalable code, and mentoring team members. Candidates may be based in Massachusetts or work remotely from the United States.

Requirements

5–7 years of data engineering experience, including at least 5 years as an IBM Cognos TM1 / Planning Analytics Developer using PAW and PAX.
At least 5 years of experience with cloud platforms such as AWS, Azure, or Google Cloud.
At least 5 years of experience working with rules, feeders, and worksheets.
At least 5 years of working experience with MDX.
Strong mastery of TurboIntegrator scripting and TM1 Rules, including DB functions and feeders.
Advanced Excel skills, including VBA, Active Forms, and complex financial modeling.
Bachelor’s degree in computer science, Finance, Math, Information Systems, or a related field.
Strong verbal and written communication skills, including the ability to explain complex technical concepts to non-technical finance stakeholders.
Excellent problem-solving and analytical skills, with attention to detail.
Ability to multitask, self-motivate, and meet financial reporting deadlines in a fast-paced environment.

Nice To Haves

Healthcare domain experience in budgeting and forecasting.
Healthcare industry experience.

Responsibilities

Design and build forecasting and budgeting applications using Planning Analytics 2.0.9 or above.
Build Planning Analytics cubes, dimensions, hierarchies, rules, feeders, and TurboIntegrator processes using Planning Analytics Workbench.
Develop data ingestion and transformation from ODBC data sources and publish data for consumption by TM1 applications and actuarial models.
Build applications and dynamic reports in TM1 Web, PAW, and Perspectives, including VBA-based solutions.
Work with IBM Cloud Planning Analytics applications and migrate applications from TM1 to Planning Analytics.
Follow established best practices and architecture patterns in implementations.
Develop understanding of healthcare data domains through process ownership, data exploration, and hands-on SQL development; understand how components of the TM1 environment interconnect and recommend approaches for complex solutions.
Design and develop data quality, data masking, data curation, and extraction processes.
Oversee TM1 security configurations, user access groups, and server performance monitoring.
Provide operational support for high-severity issues and incidents affecting critical data pipelines.
Build, maintain, and distribute active forms, slices, and web sheets through TM1 Web or PAW for business unit leaders.
Develop shared data-processing utilities using modular development methodologies.
Deliver high-quality, scalable code with automated test coverage.
Mentor team members in data engineering and software abstractions.
Work with Actuarial teams to translate business planning rules into automated TM1 system logic.