TM1 Planning Analytics Data Engineer

Blue Cross and Blue Shield of Massachusetts Inc.; Boston (MA); On-site; USD 139,000 - 170,000; Full time

Benefits offered by this job

Paid time off

401(k)

Job summary

Blue Cross Blue Shield of Massachusetts is seeking a Data Engineer to design, develop, and maintain IBM Planning Analytics models to enhance financial planning, forecasting, and reporting. You will collaborate with senior engineers and finance stakeholders to build scalable data solutions.

Responsibilities include building forecasting apps, TM1 TI processes, MDX rules, data ingestion, and TM1 Web/PAW reports, with an emphasis on data quality and performance. Boston-based, full-time role.

Qualifications

• Bachelor's degree in a related field.
• 5-7 years of data engineering experience.
• 5+ years with IBM Cognos TM1 / Planning Analytics (PAW, PAX).
• 5+ years with cloud platforms (AWS, Azure, Google).
• 5+ years MDX knowledge.
• Strong Excel mastery including VBA.

Responsibilities

• Design and build forecasting/budgeting apps using Planning Analytics 2.0.9 or above.
• Build TM1 cubes, dimensions, hierarchies, rules, and TI processes.
• Develop data ingestion and transformation for TM1 cubes and actuarial models.
• Create TM1 web, PAW and Perspectives apps with VBA.

Skills

Data engineering

IBM Cognos TM1/Planning Analytics

MDX

SQL

Data warehousing

Education

Bachelor's degree in computer science, Finance, Math, Information Systems, or related field

Tools

TM1/PAW/TI

Cloud platforms (AWS/Azure/Google)

Excel/VBA

Job description

Blue Cross Blue Shield of Massachusetts is seeking a Data Engineer to design, develop, and maintain IBM Planning Analytics models to enhance financial planning, forecasting, and reporting. You will collaborate with senior engineers and finance stakeholders to build scalable data solutions.

Responsibilities include building forecasting apps, TM1 TI processes, MDX rules, data ingestion, and TM1 Web/PAW reports, with an emphasis on data quality and performance. Boston-based, full-time role.