Principal, IBM Planning Analytics/TM1

Overview

As a Principal Engineer, Planning Analytics, you will architect, optimize, and deploy complex end‑to‑end solutions using IBM Planning Analytics (TM1), proactively resolving performance bottlenecks and ensuring system stability. You will lead requirements discovery, develop integrations with ERP and data warehouses, optimize PAW dashboards, and uphold rigorous standards for data quality, security, and documentation through code and documentation reviews. You will optimize the IBM Planning Analytics Cloud environment and drive user enablement – creating comprehensive training materials while providing technical guidance and mentorship across the team.

Geo-Salary Information

An in-person interview may be required during the hiring process

State specific pay scales for this role are as follows:

$101,167 to $204,439 (CA, NJ, NY, WA, HI, AK, MD, CT, RI, MA)

$91,970 to $185,853 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME)

$82,773 to $167,268 (UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV)

The expected base salary for this position will vary depending on a number of factors, including relevant experience, skills and location.

Responsibilities

• Solution Architecture & Design: Architect, develop, optimize and deploy complex end-to-end IBM Planning Analytics (TM1) solutions – from proof-of-concepts to scalable production – ensuring system stability; conduct technical design sessions; stay current on Planning Analytics advances.
• Technical Development & Modeling: Engineer and maintain robust models (cubes, dimensions, rules, TI, python): proactively identify and resolve technical challenges and performance bottlenecks; deliver solutions on time.

• Automation & Innovation: Design and deliver TM1Py/TI automations that materially reduce manual effort and improve data integration and reporting efficiency.

• Reporting & Visualization: Design and optimize PAW dashboards and reports; ensure usability and decision-readiness for business stakeholders.

• Business Collaboration: Lead requirements discovery with cross-functional teams; translate complex needs into scalable technical solutions and recommend system enhancements.

• System Integration: Build and manage successful integrations between IBM Planning Analytics and enterprise systems/data sources ensuring seamless data flow and process alignment.

• Data Quality, Security & Governance: Uphold high standards for data quality, integrity and security; create and maintain technical documentation; lead code and documentation reviews; meet compliance and regulatory requirements.

• Cloud Infrastructure: Optimize the IBM Planning Analytics Cloud environment; support licensing and resolve performance issues.

• User Enablement: Create comprehensive training materials and documentation; provide ongoing user support, including bug and enhancements requests and training needs.

• Collaboration: Provide technical guidance and mentorship; promote best practices and knowledge sharing across the team.

Qualifications

Education: 

Minimum: 

Bachelor’s degree in Computer Science, Engineering, Finance/Accounting, or related field.

Experience:

Minimum:

• 8+ years of experience in IBM Planning Analytics (TM1) development, including 2+ years supporting financial systems.

•   3+ years monitoring and maintaining IBM Planning Analytics Cloud infrastructure.

Knowledge and Skills:

Minimum:

• Advanced proficiency in PAW, SQL (including stored procedures), REST API, MDX, Feeders, Python/TM1Py, Turbo Integrator, and multi-dimensional cube design; strong experience with analytics platforms (e.g. Planning Analytics, PowerBI).
• Advanced testing techniques skills.
• 3+ years monitoring and maintaining IBM Planning Analytics Cloud infrastructure.
• Demonstrated experience with the full IBM Planning Analytics Cloud feature-set (rules/feeders and PAW), data modeling, ETL, and large-scale data systems.
• Strong communication and project execution skills; proven ability to partner across business and technology teams and communicate with both technical and business teams.
• Demonstrated ownership, drive, and critical thinking; strong analytical and problem-solving skills; willingness to dive into the details.
• Ability to support, troubleshoot and resolve off-hours issues.
• Demonstrated mentoring capabilities.
• Advanced proficiency with Microsoft Office and Excel integration with IBM Planning Analytics.

Preferred:

• Experience building ML-enabled budget/forecasting solutions in IBM Planning Analytics is a strong plus.

About the Company

Why choose a career at Mercury?

At Mercury, we have been guided by our purpose to help people reduce risk and overcome unexpected events for more than 60 years. We are one team with a common goal to help others. Everyone needs insurance and we can’t imagine a world without it.

Our team will encourage you to grow, make time to have fun, and work together to make great things happen. We embrace the strengths and values of each team member. We believe in having diverse perspectives where everyone is included, to serve customers from all walks of life.

We care about our people, and we mean it. We reward our talented professionals with a competitive salary, bonus potential, and a variety of benefits to help our team members reach their health, retirement, and professional goals.

Learn more about us here: https://www.mercuryinsurance.com/about/careers

Perks and Benefits

We offer many great benefits, including:

• Competitive compensation
• Flexibility to work from anywhere in the United States for most positions
• Paid time off (vacation time, sick time, 9 paid Company holidays, volunteer hours)
• Incentive bonus programs (potential for holiday bonus, referral bonus, and performance-based bonus)
• Medical, dental, vision, life, and pet insurance
• 401 (k) retirement savings plan with company match
• Engaging work environment
• Promotional opportunities
• Education assistance
• Professional and personal development opportunities
• Company recognition program
• Health and wellbeing resources, including free mental wellbeing therapy/coaching sessions, child and eldercare resources, and more

Mercury Insurance is an equal opportunity employer.  All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by federal, state, or local law.

#LI-TG1

Pay Range

USD $101,167.00 - USD $204,439.00 /Yr.