Senior Data Engineer: TM1/Planning Analytics Lead (Remote)

Blue Cross and Blue Shield of Massachusetts Inc.; Northern (KY); Hybrid; USD 139,000 - 170,000; Full time

Job summary

Blue Cross Blue Shield of Massachusetts is seeking a Senior Data Engineer to design, develop, and maintain TM1/Planning Analytics models and applications. You will work with senior engineers and finance stakeholders to build robust data solutions for forecasting, budgeting, and reporting.

The role requires 5+ years in data engineering and TM1/PA experience, plus cloud proficiency across AWS/Azure/Google. A strong Excel/VBA background and healthcare budgeting knowledge are highly valued.

Qualifications

• 5+ years in data engineering with IBM Cognos TM1/Planning Analytics experience.
• 5+ years on cloud platforms like AWS, Azure, Google.
• Strong Excel mastery with VBA and complex financial modeling.
• Healthcare budgeting/forecasting knowledge preferred.

Responsibilities

• Design, develop, and maintain TM1 models and applications.
• Support actuarial models including claims projections, financial forecasting, and expense allocation.
• Build data pipelines and data quality processes for TM1 environment.
• Mentor team members and collaborate with finance stakeholders.

Skills

Data engineering

MDX

VBA

Communication skills

Problem-solving

Multi-tasking

Education

Bachelor's degree in Computer Science, Finance, Math, Information Systems, or related field

Tools

TurboIntegrator (TI)

TM1 Rules

TM1 Perspectives

Planning Analytics Workbench (PAW)

Planning Analytics Workspace

Active Forms

Excel

Job description

Blue Cross Blue Shield of Massachusetts is seeking a Senior Data Engineer to design, develop, and maintain TM1/Planning Analytics models and applications. You will work with senior engineers and finance stakeholders to build robust data solutions for forecasting, budgeting, and reporting.

The role requires 5+ years in data engineering and TM1/PA experience, plus cloud proficiency across AWS/Azure/Google. A strong Excel/VBA background and healthcare budgeting knowledge are highly valued.