Lead Data Engineer

Join ABC Fitness and become part of a culture that’s as ambitious as it is authentic. Let’s transform the future of fitness—together! Our Values Best Life We believe great work begins with great people. That’s why our culture is built on respect, trust, and belonging. We create an inclusive environment where every team member can bring their authentic self to work—because diverse perspectives drive innovation and meaningful impact. Growth Mindset We are doers, thinkers, and dreamers. At ABC Fitness, your growth is our investment. Through continuous learning, mentorship, and professional development opportunities, we empower you to reach new heights—personally and professionally. One Team From day one, you’ll be part of a team that collaborates, celebrates, and cares. We move fast, support one another, and have fun along the way. Because when you thrive, we all thrive. RESPONSIBILTIES: Lead the design, development, optimization, and maintenance of enterprise-scale ETL/ELT pipelines using Azure Data Factory, Azure Synapse Analytics, and Azure Databricks (DBX). Design, develop, and optimize data processing solutions using Databricks, Apache Spark, and Delta Lake. Lead the technical design and implementation of complex data engineering initiatives from concept through production deployment. Design and maintain dimensional data models that support enterprise analytics and reporting. Develop scalable stored procedures, SQL scripts, and data transformation processes capable of handling large volumes of data. Ensure data quality through validation, reconciliation, monitoring, auditing, and automated quality checks. Troubleshoot and resolve complex production issues while improving platform reliability, scalability, and operational efficiency. Optimize SQL workloads, Spark jobs, and ETL/ELT pipelines for performance and cost efficiency. Collaborate with Product, Engineering, DBAs, and business stakeholders to translate business requirements into scalable technical solutions. Participate in data architecture discussions and contribute to the evolution of ABC's enterprise data platform. Provide technical leadership through architecture reviews, code reviews, mentoring, and knowledge sharing across the team. Establish and promote engineering best practices, reusable frameworks, coding standards, and operational excellence. Maintain technical documentation, deployment processes, and operational runbooks. Follow and advocate engineering best practices, including source control, CI/CD, testing, monitoring, and release management. QUALIFICATIONS: 6+ years of experience in data engineering, data warehousing, or ETL/ELT development. Advanced SQL development skills, including complex query development, stored procedures, large-scale data transformations, query optimization, and performance tuning. Strong experience with Azure Synapse Analytics, Azure Data Factory, Azure Databricks, Apache Spark, and Delta Lake. Strong understanding of dimensional modeling, including Kimball methodology, and enterprise data warehouse design principles. Experience designing, developing, modernizing, and supporting enterprise-scale ETL/ELT solutions and mission-critical production data platforms. Experience with Azure SQL Database and/or SQL Server. Strong understanding of data quality, auditing, reconciliation, troubleshooting, and production support. Experience with Git-based source control, Azure DevOps, Agile development methodologies, CI/CD, and automated deployment pipelines. Demonstrated ability to lead complex technical initiatives and mentor other engineers. Strong analytical, problem-solving, and troubleshooting skills. Excellent communication and collaboration skills with technical and business stakeholders. Experience modernizing legacy data warehouse solutions to cloud-based architectures. NICE TO HAVE: Experience designing and implementing data solutions using Databricks Medallion Architecture (Bronze, Silver, and Gold layers). Compensation for this role will be determined based on a variety of factors, including relevant experience, qualifications, skills, geographic location, and market considerations. The anticipated compensation range for this position is - $128,200 - $133,500 CAD- annually. In addition to base compensation, eligible employees may be offered other forms of compensation, such as bonuses, commissions, equity, or other incentive programs, where applicable. Compensation and benefits may vary by location and are subject to applicable legal, business, and market requirements. WHAT’S IN IT FOR YOU: Purpose led company with a Values focused culture – Best Life, One Team, Growth Mindset Time Off – with our open PTO policy, we offer flexibility in how and when you take PTO! Days of Disconnect – once a quarter, we take a collective breather and enjoy a day off together around the globe. #oneteam Parental & Pawternity Leave – we offer leave for when your family grows by two feet or four paws! Best Life Perk – we are committed to meeting you wherever you are in your fitness journey with a quarterly reimbursement Medical/Dental/Vision coverage EAP – we get you help when you need it. Period. Premium Calm App – enjoy tranquility with a Calm App subscription for you and up to 4 dependents over the age of 16 And more! – so many benefits we couldn’t even fit them all here! At ABC Fitness, we don’t just build technology—we build communities and transform lives. Your work matters here, your growth is supported, and your voice is heard. We welcome diverse talent and encourage you to apply, even if you don’t meet every requirement. ABC’S COMMITMENT TO DIVERSITY, EQUALITY, BELONGING AND INCLUSION: ABC is an equal opportunity employer committed to diversity, equity, and inclusion. We strive to create a workplace where every employee, client, and partner feels valued, inspired, and empowered to reach their full potential. For us, inclusion isn’t just the right thing to do—it’s a business imperative. Learn more at abcfitness.com. About ABC Fitness ABC Fitness is the #1 software provider for fitness businesses of any size, all around the world. Supporting 30K clubs, 650K coaches, 40M members, and processing more than $12B in payments every year, ABC Fitness provides scalable, data-driven solutions to simplify club management and engage members and clients. From personal trainers, boutique studios, and gyms, to international franchise health clubs, ABC Fitness will move your business forward through technology and industry insights. Innovation is at the center of everything we do, across ABC Glofox, ABC Ignite, ABC Trainerize, and ABC Evo. Let's make your fitness vision a seamless reality, together. Learn more at abcfitness.com #LI-REMOTE Our employees are encouraged to be pro-active in expressing their ideas and contributing to the company’s future. We have achieved this through constant pursuit of new developments and innovations in an exciting team environment. Likewise, ABC contributes to our employees’ futures. In addition to our outstanding employee benefits, employees also receive training on an on-going basis allowing them to develop their strengths and move up in the company.