ServiceTitan is looking to shape its data-driven strategy by building foundational analytics infrastructure to be used across its product ecosystem, including its core platform and Pro product lines.
Requirements
- SQL Mastery: Advanced, expert-level SQL expertise, including functions, query optimization, and complex data modeling in a data warehouse environment (Snowflake preferred).
- Data Engineering & ETL: Strong, practical experience with data engineering and ETL/ELT concepts. Hands-on experience with dbt is required.
- Business Intelligence Expertise: Proven experience building scalable, reusable, and insightful dashboards using business intelligence platforms like Tableau.
- Analytical Depth: Deep analytical skills with the ability to collect, organize, and analyze significant amounts of information with meticulous attention to detail.
- Experience leveraging Generative AI tools (e.g., Claude Code, Cursor) to enhance personal workflow.
- Python for Data Analysis: Proficiency in Python for data wrangling and analysis using libraries such as Pandas
- Experience working with clickstream data
Responsibilities
- Architect Data Solutions: Design, build, and maintain scalable and performant upstream data tables and models in Snowflake.
- Develop Reusable Tools: Build a portfolio of robust, multipurpose, and reusable dashboards and visualizations in Tableau, empowering business users to self-serve actionable insights.
- Provide Strategic Insights: Use statistical tools to identify, analyze, and interpret patterns in complex data sets, preparing and presenting findings and recommendations to senior management.
- Drive Infrastructure Improvements: Proactively partner with stakeholders in product, finance, and engineering to continuously improve and maintain our analytics infrastructure, ensuring it evolves with business needs.
- Mentor and Lead: Serve as a technical leader and mentor for other analysts on the team.
- Own the Roadmap: Take the lead in directing and implementing solutions to complex, loosely scoped problems.
- Partner with stakeholders to translate business needs into a long-term roadmap for your projects and the team.
Other
- Education & Experience: Bachelor's degree in a business or quantitative field with 8+ years of experience as a product or data analyst.
- Executive Communication: Excellent written, verbal, and presentation skills, with a demonstrated ability to communicate complex technical information clearly and concisely to VP+ leaders.
- Business Acumen: Strong business acumen and systems-thinking ability that lets you anticipate how your work connects to broader business goals and customer decisions.
- Flextime, recognition, and support for autonomous work
- Holistic health and wellness benefits