IT Data Engineer (Aspire)

We’re Aspire, a ServiceTitan company 

We’re Aspire, the leading SaaS provider for the landscaping and commercial cleaning industries and a proud member of the ServiceTitan family since 2021. Our cloud-based business management system automates all aspects of field service operations for enterprise and small to medium-sized businesses enabling our clients to accelerate growth, streamline operations, increase customer retention, and maximize revenue. Trusted by thousands of premier field services leaders in the US and Canada, our solutions empower our clients to make better business decisions for their companies. 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 cross-functional teams to assist with data-related requests and solution development

• Work closely with engineers, product owners, data owners, and other cross-functional teams to understand data needs

• Deliver solutions that are relayed directly to business leaders

• Maintain delta lake architecture to support real-time and batch data processing

• Contribute to the development of SSAS or other Tabular models to support complex analytics and business intelligence requirements Implement best practices for data security, backup, recovery and redundancy to ensure data integrity and availability

• Stay updated with the latest trends and technologies in data engineering and suggest improvements to our data stac

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

• Proven experience in data engineering, specifically with Microsoft Azure SQL Database, Azure Data Factory and Databricks

• Strong proficiency in SQL Proven experience in optimizing and performance tuning 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.

• Excellent problem-solving, analytical and communication skills 

Preferred Qualifications: 

• Familiarity with Terraform Familiarity with open-source data engineering tools and software

• Experience with master data management and data governance processes and program

Where You’ll Work:

Employees for this position will be 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.