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