Senior 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

What We Need

Ready to help us transform healthcare? Bring your true colors to blue. What we need 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.

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. Develop a holistic understanding of how various components within the TM1 environment interconnect, acting as a proactive technical partner who makes strong, creative recommendations for implementing complex solutions.
• 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. While also working closely with the Actuarial teams to translate complex business planning rules into automated TM1 system logic.

We’re Looking for

• 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.
• TM1 Development:Strong mastery of TurboIntegrator (TI) scripting and TM1 Rules (DB functions, Feeders).
• Excel Mastery:Advanced Excel skills, including VBA, Active Forms, and complex financial modeling.
• Health Care Domain working in Budgeting and Forecasting is preferred.

What You Bring

• 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.

What You’ll Gain

It is our mission at Blue Cross Blue Shield of Massachusetts to foster a culture that enables associates to do their best work while living happy and healthy lives. That's why we offer you a variety of ways to support your best physical, emotional, financial, and social well-being. For more information on our benefit offerings, visit https://careers.bluecrossma.org/us/en/benefits #LI-HYRBID

Benefits

• Paid time off
• Medical/dental/vision insurance
• 401(k)
• A suite of well‑being benefits to eligible employees

Minimum Education Requirements

High school degree or equivalent required unless otherwise noted above

Location

Boston

Time Type

Full time

Salary Range

$138,870.00 - $169,730.00 The job posting range is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting. We may ultimately pay more or less than the posted range, and the range may be modified in the future. An employee’s pay position within the salary range will be based on several factors including, but limited to, relevant education, qualifications, certifications, experience, skills, performance, shift, travel requirements, sales or revenue-based metrics, and business or organizational needs and affordability. This job is also eligible for variable pay. No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion until paid and may be modified.

Equal Employment

Blue Cross Blue Shield of Massachusetts is an Equal Employment Employer - veterans/disability. Applicants are considered for all positions without regard to race, color, religion, sex, national origin, age, veteran status, disability, sexual orientation, gender identity or expression or any other characteristics protected by law. Blue Cross Blue Shield of Massachusetts will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action including an investigation conducted by the employer, or (c) consistent with Blue Cross Blue Shield of Massachusetts's legal duty to furnish information.

Our Commitment to You

We are committed to investing in your development and providing the necessary resources to enable your success. We are dedicated to creating a refreshing and rewarding workplace that promotes excellence and provides opportunities for employees to forge their unique career path. We take pride in our diverse, community-centric, wellness-focused culture and believe every member of our team deserves to enjoy a positive work‑life balance.

Why Blue Cross Blue Shield of MA?

Voted as the highest in member satisfaction among Massachusetts commercial health plans by JD Power, Blue Cross Blue Shield of Massachusetts is a community-focused, tax‑paying, not-for-profit health plan headquartered in Boston. We have been a market leader for over 75 years, and are consistently ranked among the nation's best health plans. Our daily efforts are dedicated to effectively serving our 2.8 million members, and consistently offering security, stability, and peace of mind to both our members and associates.

Work-Life Balance Resources

For more information on how we work and support that work/life balance visit our "How We Work" Page.