We’re Aspire, a ServiceTitan company
We’re Aspire, the leading SaaS provider for commercial landscaping, snow and ice removal, and janitorial businesses. Acquired by ServiceTitan in 2021, the world's leading provider of software for the trades, our cloud-based business management system enables contractors to grow their business, streamline operations, provide insights, and ultimately impress their customers. When you join our team, you’ll be a part of one of the fastest-growing companies in St. Louis, with an award-winning culture that’s been celebrated by the St. Louis Business Journal and Inc. Magazine. Trusted by thousands of premier field services leaders in the U.S. and Canada, our solutions empower our clients to make better business decisions for their company. Our partnership with ServiceTitan has enabled us to continue scaling our platform and customer base while maintaining our collaborative, tight-knit culture.
What You’ll Do:
Design, implement, test, deploy, and maintain stable, secure, and scalable integration solutions and pipelines in support of data and analytics projects, including integrating new and existing raw and enterprise application sources of data
Configure and build out the infrastructure required for optimal storage, extraction, transformation, loading, and retrieval of data from a wide variety of data sources
Assemble large, complex data sets that meet functional / non-functional business requirements.
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, tuning existing data objects for performance, etc.
Work with various support and development teams to assist with data-related technical issues and support their data infrastructure needs.
Work closely with engineers / product owners to understand data needs, profile data sources, and requirements of production environments while delivering solutions that are relayed directly to business leaders
What You’ll Need:
Bachelor's degree (B.S/B.A) from four-year college or university
3 to 5 years experience in a data-specific role focused on the creation, modification, and maintenance of integration solutions
Expertise with Microsoft SQL Server environments (SQL Skills, Database Server Administration, SSIS, SSAS, SSRS) and Azure SQL (e.g Azure SQL Server, Azure Data Factory)
Proven experience creating objects, performance tuning, query optimization, and troubleshooting scalability issues within Microsoft SQL Server or Azure SQL Server
Authoritative in delivery and optimization of ETL pipelines and processes including experience with Python and Powershell scripting
Experience with data repository, data lake, and data warehouse architecture
Demonstrate efficiency in handling data - tracking data lineage, ensuring data quality, and improving discoverability of data.
Preferred Qualifications:
Familiarity with Azure Synapse
Experience with master data management and data governance processes and programs
Where You’ll Work:
Our headquarters is located in Chesterfield in St. Louis County; however, some local positions will be remote until the time is right to return to the office while other roles are more office-based. Fully remote employees will stay remote.
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 more.
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.