Mercury Insurance · 16 hours ago
Lead Engineer Planning Analytics
United States
Full-time
Remote
Mid, Senior Level
$101K/yr - $204K/yr
5+ years expMercury Insurance is a company focused on helping people reduce risk and overcome unexpected events. The Lead Engineer Planning Analytics will develop and optimize TM1 solutions, ensuring data integrity while collaborating with cross-functional teams to translate business needs into technical solutions.
Insurance
Responsibilities
Develop, optimize and deploy end-to-end Planning Analytics (TM1) solutions; contribute to technical design reviews and ensure system stability
Build and maintain cubes, dimensions, business rules, and high-performance Turbo Integrator (TI) processes that safeguard data integrity and optimize performance; deliver assigned projects on time
Implement TM1Py- and TI-based automations to reduce manual effort and streamline data integration and reporting workflows
Develop, enhance, and optimize Planning Analytics Workspace (PAW) dashboards and reports that translate data into actionable insights
Partner with cross-functional teams to gather requirements and translate business needs into scalable technical solutions
Implement integrations between Planning Analytics and enterprise data sources and systems (e.g., ERP, data warehouse) to ensure seamless data flow
Ensure data quality, integrity and security; create and update solution documentation; participate in code and documentation reviews
Support the Planning Analytics Cloud environment, including licensing and troubleshooting performance issues
Contribute to end-user training materials; provide technical assistance, troubleshoot reports/models/cubes, and respond to bug inquiries
Collaborate with development team and share knowledge; stay current on new Planning Analytics technologies
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, Finance/Accounting, or related field
5+ years of experience in Planning Analytics (TM1) development
Strong practical skills with PAW, SQL, MDX, Feeders, Python/TM1Py, and Turbo Integrator; solid multidimensional cube design
Strong testing techniques skills
1+ years supporting Planning Analytics infrastructure in the cloud
Understanding of data modeling, ETL, and data warehousing concepts; exposure to accounting, analytics, budgeting, and forecasting processes
Exposure to accounting, analytics, budgeting and forecasting concepts and process requirements
Strong problem-solving and communication skills; self-starter with initiative and ownership
Ability to support, troubleshoot and resolve off-hours issues
Ability and willingness to mentor and train Planning Analytics users
Advanced proficiency with Microsoft Office and Excel integration with Planning Analytics
Preferred
Experience building ML-enabled budget/forecasting solutions in Planning Analytics is a strong plus
Benefits
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
Company
Mercury Insurance
Mercury Insurance has offered quality insurance for personal auto insurance to homeowners insurance to mechanical breakdown protection.
5001-10000 employees
H1B Sponsorship
Mercury Insurance has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (22)
2024 (23)
2023 (14)
2022 (15)
2021 (8)
2020 (13)
Funding
Current Stage
Public CompanyTotal Funding
unknown1985-11-29IPO
Leadership Team
T
Ted Stalick
SVP & CFO
V
Victor Joseph
President & Chief Operating Officer
Recent News
2025-12-18
2025-12-04
2025-11-25
Company data provided by crunchbase