Data Warehouse Architect

Get to know us:

We're FieldRoutes, a leading cloud-based and mobile SaaS provider in the pest control and lawn care industry. Recently acquired by ServiceTitan, the world's leading provider of software for the trades, our platform automates all aspects of field service operations for enterprise and small businesses, enabling them to accelerate growth, streamline operations, increase customer retention, and maximize revenue.

When you join our team, you'll be joining one of the fastest growing companies in the US with an award-winning culture that's been celebrated by Inc. Magazine and Forbes. Trusted by over 1,700 field service companies across thousands of locations, our software helps clients manage upwards of a billion dollars in revenue. Our partnership with ServiceTitan will enable us to accelerate investment in our technology and people while maintaining our flexible startup culture.

What will you do?

As data warehouse architect at FieldRoutes you can expect to do the following types of things:

• Own and drive complex technical solutions to enable our business functions, from revenue operations to FP&A, maximize the value of their data
• Take business requirements from different business functions (Sales, Marketing, Finance, ect.) and relate those to technical requirements
• Use best of breed modern data warehouse tools across traditional data warehouses and modern big data solutions. Specifically moving from AWS to Azure and from WhereScape to DBT. Key tools and platforms incuding but not limited to Snowflake, AWS, Azure, WhereScape, DBT, and other Cloud ETL tools such as FiveTran and Census).
• Participate in integrated projects that include BI solutions such as Tableau and PowerBI, specifically migrating current dashboards from PowerBI to Tableau for reporting
• Ingesting data from multiple snowflake instances to populate reporting views in Tableau
• Continuously learn about data analytics business and technology trends, and effectively communicate/share information with colleagues
• Mentor technical employees and contribute to their individual development, and lead performance management processes for technical delivery teams

What You'll Bring:

We are seeking individuals with the following experience:

• Minimum 5 years of recent, progressive experience and demonstrable technical expertise in enterprise-class data analytics solutions and services. Including advanced skills in areas such as Data Modeling, Integration, Storage, Indexing, Security, Logging, Data Quality, Master Data Management and Archiving
• Minimum 2 years architect and hands-on experience with modern data analytics solutions (Snowflake, AzureDW, DBT, Tableau)
• Experience with Architecture and applications on or incorporating cloud infrastructure-, platform-, and/or software- as a service (particularly data analytic solutions on Amazon AWS, Microsoft Azure, or other cloud platforms and service providers)
• Experience in core business systems (e.g. customer, call center, billing, etc.) transformation programs, with a focus on related changes in data analytics architecture, engineering, and business capabilities
• B.S. in Computer Science or equivalent degree or 5-7 years of professional work experience is required
• Strong database skills
• Strong Data Modeling skills (dimensional modeling, DBT)
• BI Tool experience (Tableau, PowerBI)
• WhereScape RED and 3D experience
• DBT experience
• Snowflake experience

Be Human With Us:

Being human isn't about checking every box on a list. It's about the experiences we have, people we meet, and the perspectives we share. So, if you have the skills but are hesitant to apply because of your background, apply anyway. We need amazing people like you to help us challenge the conventional and think differently about the problems that we're solving. We're in this together. Come be human, with us.

What We Offer:

When you join our team, you're not just accepting a job. You're making a career move. Here's how we'll support you in doing some of the most impactful work of your career:

• Flextime, recognition, and support for autonomous work: Flexible time off with ample learning and development opportunities to continue growing your career. We offer a comprehensive onboarding program, leadership training for Titans at all levels, and other programs and events. Great work is rewarded through Bonusly, peer-nominated awards, and Founders Club- open to all Titans.
• Holistic health and wellness benefits: Company-paid medical, dental, and vision (with 100% employer paid options and 90% coverage for dependents), FSA and HSA, 401k match, and telehealth options including memberships to Headspace, Galileo, One Medical, Ginger and more.
• Support for Titans at all stages of life: Parental leave and support, up to $20k in adoption reimbursement, on demand maternity support through Maven Maternity, free breast milk shipping through Maven Milk, pet insurance, legal advisory services, financial planning tools, and more.

At ServiceTitan, we celebrate individuality and uniqueness. We believe that the convergence of fresh perspectives and experiences from all walks of life is what makes our product and culture so great. We strongly encourage people from underrepresented groups to apply. We do not discriminate against employees based on race, color, religion, sex, national origin, gender identity or expression, age, disability, pregnancy (including childbirth, breastfeeding, or related medical condition), genetic information, protected military or veteran status, sexual orientation, or any other characteristic protected by applicable federal, state or local laws.