Overview Position Summary: We’re looking for an Analytics Engineer II to build our next-generation enterprise metrics store and enable insights across underwriting, sales, product, claim and experience. This role blends analytics engineering and prompt engineering, supporting our journey toward a fully governed, AI-ready data ecosystem.As an Analytics Engineer, you will sit at the intersection of:• data modeling (dbt, semantic layer)• business metrics (insurance domain: quotes, binds, premium, agency performance)• analytics engineering (root cause analysis, metric relationships, metric store)This is a hands-on role where you will design, build, and scale core metrics and analytical workflows, working closely with product, business, and engineering stakeholders. The team is evolving toward exposing metric infrastructure as internal services, so you’ll have the opportunity to shape that API layer as it matures. Geo-Salary Information An in-person interview may be required during the hiring process State specific pay scales for this role are as follows: $94,458 to $179,048 (CA, NJ, NY, WA, HI, AK, MD, CT, RI, MA) $X85,871 to $162,771 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME) $77,283 to $146,494 (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 Essential Job Functions: - Build and scale the metric layer - Develop and maintain dbt models - Contribute to semantic layer definitions (metrics, dimensions, relationships)Ensure consistency and correctness of: key business metrics o metric hierarchies (metric pyramid) - Implement analytical logic (root cause analysis & metric insights) - Build root cause analysis workflows:Implement baseline comparisons , companion metric analysis - Translate business questions into scalable analytical patterns - Enable metric consumption across toolsSupport metric usage in different BI or analytical tools - Build reusable logic that avoids duplication across tools - Prepare for future API-based metric serving layer - Partner with business and product stakeholders - Work closely with sales, product, underwriting, claims, experience and other business teams, Translate ambiguous questions into: - Structured metrics - Actionable insights - Improve data quality and governance - Define and enforce: - Metric definitions - Dimension standards - Data contracts - Debug issues across: - Upstream pipelines - Semantic layer - Analytical outputs Qualifications Education: - 3–5 years of analytics engineering or similar analytical role experience with dbt or similar transformation frameworks proficiency: models, tests, incremental materialization, Jinja macros - Advanced SQL on a columnar warehouse (Redshift, Snowflake, or BigQuery) - Python for data transformation and analysis (pandas, basic scripting) - Comfort working with YAML-based configuration and version-controlled analytics workflows - Clear written and verbal communication—able to explain metric definitions and data lineage to non-technical stakeholders - Nice to haveP&C insurance domain experienceExperience with:Cohort analysisFunnel metricsPerformance analysisFamiliarity with MetricFlow specifically and the dbt Semantic LayerExposure to Retool or similar low-code tools for operational write-back workflowsFastAPI or similar Python API frameworks (Flask, Django REST) for serving data products as services 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. Pay Range USD $94,458.00 - USD $179,048.00 /Yr.

Job Family: Systems Engineering Travel Required: Up to 10% Clearance Required: None Guidehouse is seeking a highly skilled Analytics Platform DevOps Engineer to be part of its central Products, Platforms, and Tools group in the office of the CTO. This role requires someone comfortable writing code who can both implement and help set standards and best practices to automate creation of cloud resources—including Databricks and Unity Catalog—in a complex environment. This engineering professional will be focused on Analytics Infrastructure as Code, GitOps, and Security/Risk techniques necessary to build successful (minimal risk) solutions for large commercial enterprises and public sector customers. The engineer will leverage expertise in deploying and managing Databricks environments, alongside other cloud-driven architectures, to improve consistency, safety, and operational excellence. Partnering with IT Architecture and IT Security team, this leader will build from re-usable components highly secure and repeatable solutions / frameworks that will be used in proposals and as delivery structures to accelerate the delivery. The successful engineer will partner with business segments to build novel solutions, as well as harvesting successful solutions into a common catalog. What You Will Do: As an Full Stack Analytics DevOps Engineer, you will: - Architect, automate, and operate enterprise analytics platforms leveraging Terraform, GitHub, Kubernetes, and GitOps to deliver secure, repeatable, and scalable cloud environments. - Design and build next‑generation analytics infrastructure, modernizing legacy deployments and implementing hardened CI/CD workflows aligned with Zero Trust and cloud governance best practices. - Develop reusable modules, templates, and reference architectures to accelerate product teams and improve platform standardization. - Integrate and operationalize third‑party libraries, APIs, and partner technologies into end‑to‑end cloud solutions. - Contribute to engineering excellence through code commits, PR reviews, automation improvements, and platform observability enhancements. - Improve containerized workloads on both Azure and AWS and enhance workload efficiency across analytic platforms such as Databricks, Posit Workbench, and Posit Connect. - Collaborate across IT and security organizations to ensure compliance, resiliency, and policy alignment. - Leverage tools such as GitHub, Jira, and ServiceNow as part of a mature DevSecOps operating model. What You Will Need: - 6+ years of relevant industry experience. - 4+ years of experience in a DevOps or Cloud Infrastructure Engineering (or similar) role. - Strong knowledge of Terraform and other Infrastructure-as-Code tools. - Strong knowledge of Security principles, 12 Factor App design. - Experience working in public cloud (specifically Azure or AWS). - Ability to research, plan, organize, lead, and implement new processes or technologies. - Experience in Agile CI/CD cloud deployment techniques. - Demonstrated capabilities to apply policy driven frameworks to cloud deployments. inclusive of micro-services (Kubernetes) alongside terraform or similar IaC techniques. - Knowledge of modern development languages with deep 3-4yrs experience in at least one (python, golang, javascript). - Experience deploying or maintaining Big Data or analytics platforms like Databricks, Snowflake, RedShift, BigQuery, Synapse. - Experience working in version control platforms such as GitHub or Azure DevOps. - Experience with agile management tools like Jira, GitHub Projects, or Azure DevOps. - Strong communications and leadership skills with a demonstrated capability to drive change within organizations and for clients. - No Visa Sponsorship for this position. What Would Be Nice To Have: - Experience configuring Helm charts, writing Terraform, administrating Azure and/or AWS, working in Docker. - Have knowledge of containerization through Docker, Kubernetes, Ansible, etc. - Ability to clearly articulate pros and cons of various technologies and platforms and architectural options, as well as being able to document use cases, solutions and recommendations. - Cloud certifications (Azure or AWS) preferred. - Client-facing skills with the capability of facing off with a variable set of client stakeholders from SME’s to key executives. The annual salary range for this position is $98,000.00-$163,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs. What We Offer: Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace. Benefits include: - Medical, Rx, Dental & Vision Insurance - Personal and Family Sick Time & Company Paid Holidays - Parental Leave - 401(k) Retirement Plan - Group Term Life and Travel Assistance - Voluntary Life and AD&D Insurance - Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts - Transit and Parking Commuter Benefits - Short-Term & Long-Term Disability - Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities - Employee Referral Program - Corporate Sponsored Events & Community Outreach - Care.com annual membership - Employee Assistance Program - Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.) - Position may be eligible for a discretionary variable incentive bonus About Guidehouse Guidehouse is an Equal Opportunity Employer–Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation. Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco. If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at RecruitingAccommodation@guidehouse.com. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation. All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or guidehouse@myworkday.com. Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process. If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse’s Ethics Hotline. If you want to check the validity of correspondence you have received, please contact recruiting@guidehouse.com. Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant’s dealings with unauthorized third parties. Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.

Title: Senior Analyst, Analytics & Insights Location: Mohali, IND Job Description: About Zscaler Zscaler accelerates digital transformation to ensure our customers can be more agile, efficient, resilient, and secure. As an AI-forward enterprise, we are constantly pushing the envelope, leveraging the world’s largest security data lake to power our cloud-native Zero Trust Exchange platform. This innovation protects our customers from cyberattacks and data loss by securely connecting users, devices, and applications in any location. Here, impact in your role matters more than title and trust is built on results. We say, impact over activity. We seek innovators who actively use AI to amplify their impact and who thrive in an environment where we leverage intelligent systems to stay ahead of evolving threats. We believe in transparency and value constructive, honest debate—we’re focused on getting to the best ideas, faster. We build high-performing teams that can make an impact quickly and with high quality. To do this, we are building a culture of execution centered on customer obsession, collaboration, ownership, and accountability. We value high-impact, high-accountability with a sense of urgency where you’re enabled to do your best work and embrace your potential. If you’re driven by purpose, thrive on solving complex challenges, and want to be part of the team that’s helping to secure the AI age, we invite you to bring your talents to Zscaler and help shape the future of cybersecurity. Role We are looking for a Senior Analyst - Analytics and Insights to join our FP&A department. This is a hybrid role based in our Mohali Office, reporting to the Manager - Analytics and Insights, FP&A. As a Senior Analyst, you will sit at the intersection of analytics delivery and analytics engineering—supporting and improving existing BI/data assets while also developing new, scalable datasets and metrics. You will use strong SQL and Python to deliver reliable insights, improve data quality, and help evolve our semantic layer to enable consistent self-serve reporting. What you’ll do (Role Expectations) - Provide day-to-day analytics support for existing dashboards, data models, and reporting—triaging issues, and ensuring stakeholder trust in outputs - Build and enhance curated datasets (tables/views/marts) using strong SQL and Python to enable repeatable analysis and scalable reporting - Contribute to the semantic layer—maintain metric definitions, improve governance/documentation, and ensure consistent KPI logic across BI assets - Partner with FP&A/business stakeholders to translate questions into analytical requirements, deliver insights, and recommend actions based on data - Improve data infrastructure reliability—support pipeline monitoring, data quality checks, and performance tuning to reduce recurring reporting/manual effort Who You Are (Success Profile) - You act like an owner. Your passion for the mission fuels your bias for action. You operate with integrity because you genuinely care about the outcome. You adapt to what’s needed, navigating seamlessly between high-level strategy and hands-on execution. - You are a high-trust collaborator. You are ambitious for the team, not just yourself. You embrace our challenge culture by giving and receiving ongoing feedback—knowing that candor delivered with clarity and respect is the truest form of teamwork and the fastest way to earn trust. - You are a pragmatic builder. You are obsessed with creating, iterating, and shipping. You aren't afraid to roll up your sleeves and build the first version yourself, balancing the drive for technical excellence with the need to deliver value to users quickly. - You are data-driven. You use data and analytics to find the truth, measure what matters, and guide informed decisions. You value evidence over assumptions, replacing "I think" with "I know" to drive better outcomes. - You think at scale. You connect your day-to-day work to the larger company mission and think globally. You build solutions, processes, and teams that are not just effective today but are built to last and support a high-growth, global organization. What We’re Looking for (Minimum Qualifications) - 3–5 years of experience in Analytics, BI, Analytics Engineering, or Finance/Data Analytics roles - Strong SQL skills (joins, window functions, CTEs, performance-minded query writing) and experience working with data warehouses - Proficiency in Python for analytics/automation (data wrangling, scripting, APIs, building repeatable workflows) - Understanding of data infrastructure concepts (ELT/ETL, orchestration basics, data quality/testing, dimensional modeling fundamentals) - Familiarity with semantic layer concepts and metric governance (consistent definitions, reusable measures, documentation) What Will Make You Stand Out (Preferred Qualifications) - Hands-on experience with a semantic layer tool/framework (e.g., dbt Semantic Layer/MetricFlow, LookML, Cube, AtScale) and metric governance practices - Experience maintaining or developing BI assets (Tableau/Power BI/Looker) including performance optimization and stakeholder enablement - Experience with modern analytics engineering practices (dbt, Git, CI basics, testing, modular modeling) #Hybrid #LI-HG1 At Zscaler, we are committed to building a team that reflects the communities we serve and the customers we work with. We foster an inclusive environment that values all backgrounds and perspectives, emphasizing collaboration and belonging. Join us in our mission to make doing business seamless and secure. Our Benefits program is one of the most important ways we support our employees. Zscaler proudly offers comprehensive and inclusive benefits to meet the diverse needs of our employees and their families throughout their life stages, including: - Various health plans - Time off plans for vacation and sick time - Parental leave options - Retirement options - Education reimbursement - In-office perks, and more! Learn more about Zscaler’s Future of Work strategy, hybrid working model, and benefits here. By applying for this role, you adhere to applicable laws, regulations, and Zscaler policies, including those related to security and privacy standards and guidelines. Zscaler is committed to providing equal employment opportunities to all individuals. We strive to create a workplace where employees are treated with respect and have the chance to succeed. All qualified applicants will be considered for employment without regard to race, color, religion, sex (including pregnancy or related medical conditions), age, national origin, sexual orientation, gender identity or expression, genetic information, disability status, protected veteran status, or any other characteristic protected by federal, state, or local laws. See more information by clicking on the Know Your Rights: Workplace Discrimination is Illegal link. Pay Transparency Zscaler complies with all applicable federal, state, and local pay transparency rules. Zscaler is committed to providing reasonable support (called accommodations or adjustments) in our recruiting processes for candidates who are differently abled, have long term conditions, mental health conditions or sincerely held religious beliefs, or who are neurodivergent or require pregnancy-related support.

• Architect performant and reusable data models to scale Analytics across ClickUp. • Design and implement scalable SQL transformations, frameworks, and governance practices to support data pipelines and models across the organization. • Apply an ownership mentality to the datasets you're working with, deeply understanding the data and how it'll be used. • Partner effectively with stakeholders across various departments to understand how they are leveraging data and help them design and implement data solutions to enable their work.