IT Data Engineer (Aspire)

We're Aspire, a ServiceTitan company. We're the leading SaaS provider for commercial landscaping, snow and ice removal, and janitorial businesses. We were 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 become part of one of the fastest-growing companies in St. Louis, boasting an award-winning culture that has been recognized by the St. Louis Business Journal and Inc. Magazine. Trusted by thousands of top field services leaders in the U.S. and Canada, our solutions empower our clients to make better business decisions. Our partnership with ServiceTitan has enabled us to continue expanding our platform and client base, all while maintaining our collaborative, close-knit culture. What You’ll Do: Your responsibilities will include designing, implementing, testing, deploying, and maintaining stable, secure, and scalable integration solutions and pipelines to support data and analytics projects, which includes integrating new and existing raw and enterprise application data sources. You'll also configure and establish the infrastructure needed for optimal data storage, extraction, transformation, loading, and retrieval from various data sources. Furthermore, you'll assemble large, complex data sets based on business requirements. You'll also identify and implement internal process improvements, including automating manual procedures, optimizing data delivery, redesigning infrastructure for improved scalability, and tuning existing data objects for performance. You will also work with different support and development teams to address data-related technical issues and assist with their data infrastructure needs. What You’ll Need: To qualify for this role, you should have a Bachelor's degree (B.S/B.A) from a four-year college or university, and 3 to 5 years of experience in a data-specific role. You should be an expert in Microsoft SQL Server environments (SQL Skills, Database Server Administration, SSIS, SSAS, SSRS) and Azure SQL. You need to have demonstrated experience in creating objects, performance tuning, query optimization, and troubleshooting scalability issues within Microsoft SQL Server or Azure SQL Server. A solid knowledge of ETL pipelines and processes including experience with Python and Powershell scripting is necessary. You should also be experienced with data lake and data warehouse architecture and efficient at handling data. Preferred Qualifications: Familiarity with Azure Synapse and experience with master data management and data governance processes and programs would be advantageous. Where You’ll Work: Our headquarters is located in Chesterfield in St. Louis County. However, some positions will be remote until we decide to return to the office, while other roles will remain office-based. Full-time remote employees will continue to work remotely. Be Human With Us: Being human isn’t just about meeting all the requirements. It’s about the experiences we share, and the perspectives we bring to the table. 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 conventional thinking and think differently about the problems that we’re solving. We’re in this together. What We Offer: When you join us, you’re not just accepting a job. You’re making a career move. To support you in doing the most impactful work of your career, we provide flexible working hours, recognition, and support for autonomous work, and opportunities to grow your career. Our comprehensive onboarding program, leadership training, and other programs and events help in fostering your growth. Great work is rewarded through Bonusly, peer-nominated awards, and more. We also offer comprehensive health and wellness benefits, support for parents, adoption reimbursement, on demand maternity support, free breast milk shipping, 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 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, age, disability, pregnancy, genetic information, protected military or veteran status, sexual orientation, or any other characteristic protected by law.