Sr Engineer Planning Analytics

Mercury Insurance is dedicated to helping people reduce risk and overcome unexpected events. They are seeking a Senior Engineer, Planning Analytics to architect, optimize, and deploy complex solutions using IBM Planning Analytics while ensuring system stability and data quality.

Responsibilities:

• 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
• Engineer and maintain robust models (cubes, dimensions, rules, TI, python): proactively identify and resolve technical challenges and performance bottlenecks; deliver solutions on time
• Design and deliver TM1Py/TI automations that materially reduce manual effort and improve data integration and reporting efficiency
• Design and optimize PAW dashboards and reports; ensure usability and decision-readiness for business stakeholders
• Lead requirements discovery with cross-functional teams; translate complex needs into scalable technical solutions and recommend system enhancements
• Build and manage successful integrations between IBM Planning Analytics and enterprise systems/data sources ensuring seamless data flow and process alignment
• Uphold high standards for data quality, integrity and security; create and maintain technical documentation; lead code and documentation reviews; meet compliance and regulatory requirements
• Optimize the IBM Planning Analytics Cloud environment; support licensing and resolve performance issues
• Create comprehensive training materials and documentation; provide ongoing user support, including bug and enhancements requests and training needs
• Provide technical guidance and mentorship; promote best practices and knowledge sharing across the team

Requirements:

• Bachelor's degree in Computer Science, Engineering, Finance/Accounting, or related field
• 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
• 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
• 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
• Experience building ML-enabled budget/forecasting solutions in IBM Planning Analytics is a strong plus