Lead SQL Developer

Aylo; Montreal (administrative region); Hybrid; CAD 110,000 - 150,000; Full time

Job summary

Aylo, a Montreal-based tech company, seeks a Lead SQL Developer to guide a data engineering team and shape our Azure-based data platform. You will design pipelines, optimize Spark workloads, and drive reliable, cost-efficient analytics across Synapse, Data Factory, and Delta Lake.

You will lead design reviews, establish standards, mentor engineers, and collaborate with hybrid and on‑prem environments to deliver scalable data solutions.

Qualifications

• 6+ years of experience in data development.
• 2+ years leading or mentoring technical teams.
• 2+ years hands-on Azure Cloud experience (Synapse, Azure SQL DB, Data Lake Gen2, Delta Lake).
• Hands-on PySpark and large-scale data ingestion pipelines.
• Strong T-SQL knowledge and relational DB design; ETL/ELT pipelines.
• Experience in hybrid environments (Azure + on-prem SQL Server).

Responsibilities

• Provide technical leadership and architectural guidance to data engineers and SQL developers.
• Establish engineering standards for data pipelines and lakehouse platforms.
• Mentor team members and support their technical growth.
• Design and evolve a modern Azure data platform using Synapse, Data Factory, Data Lake Gen2, Azure SQL.
• Define scalable patterns for lakehouse platforms and data quality frameworks.
• Optimize Spark workloads, Synapse queries, and Azure SQL performance.
• Improve platform reliability, observability, and cost efficiency.
• Support operational runbooks and investigate data pipeline alerts.

Skills

Data development

Team leadership

Azure cloud

PySpark

Delta Lake

T-SQL

ETL/ELT pipelines

Tools

Azure Synapse Analytics

Azure Data Factory

Azure Data Lake Storage Gen2

Delta Lake

Azure SQL Database

Microsoft Fabric

Azure DevOps

Job description

Established in 2004, we are a tech pioneer offering world-class adult entertainment and games on some of the internet’s safest and most popular platforms. With the support of an international team of dynamic and collaborative innovators, we are on a mission to enable safe user experiences and empower our communities by celebrating diversity, inclusion, and expression — all while maintaining robust trust-and-safety protocols. We embrace the best of both worlds! Local talent can thrive in our collaborative office space with the flexibility of a hybrid work environment, while remote team members play an integral role in shaping our dynamic culture from afar. We have offices in Montreal (Quebec), Austin (Texas) and Nicosia (Cyprus).

• A select number of positions require full-time in office attendance*

Our Data Warehouse Team is looking for a Lead SQL Developer to contribute to the evolution of our enterprise data platform within the Data Warehouse Services team. This role combines technical leadership and hands‑on engineering. The Lead will guide a team of data engineers responsible for designing, building, and operating modern data pipelines and analytical platforms across Azure.

What you'll be doing:

• Provide technical leadership and architectural guidance to data engineers and SQL developers, leading design discussions and architecture reviews.
• Establish engineering standards and best practices for data pipelines, lakehouse platforms, and SQL development, including code and design reviews.
• Mentor team members and support their technical growth.
• Design and evolve a modern Azure data platform using Azure Synapse Analytics, Synapse Spark, Azure Data Factory, Azure Data Lake Storage Gen2, Azure SQL Database, and Microsoft Fabric.
• Define scalable architecture patterns for lakehouse platforms, Delta Lake tables, data ingestion pipelines, and data quality frameworks.
• Optimize and troubleshoot Spark workloads, Synapse queries, and Azure SQL performance.
• Improve platform reliability, observability, monitoring, and Azure workload cost efficiency.
• Support operational processes including investigating alerts, resolving data pipeline failures, and improving operational runbooks.

What you'll need to be successful:

Must Haves:

• 6+ years of experience in data development.
• 2+ years experience leading or mentoring technical teams.
• 2+ years of hands‑on Azure Cloud experience, including proficiency in Synapse Analytics, Azure SQL Database, Data Lake Storage Gen2, and Delta Lake.
• Hands‑on experience with PySpark, Delta Lake/lakehouse architectures, and large-scale data ingestion pipelines.
• Strong T‑SQL knowledge and relational database design.
• Experience designing and implementing ETL/ELT pipelines.
• Strong troubleshooting skills in data pipeline and database performance issues.
• Experience working with hybrid environments (Azure, on‑prem SQL Server).
• Strong communication and leadership skills.

Nice to Haves:

• Experience with Microsoft Fabric
• Experience implementing CI/CD pipelines (Azure DevOps / Git)
• Experience with cost optimization of cloud data platforms
• Familiarity with Azure networking and integration runtimes
• Experience designing data quality and observability frameworks
Demonstrated judgment reviewing and correcting AI-generated code
• Evidence of having restructured workflows around AI, beyond occasional use
• Hands‑on experience building or configuring AI agents and automated workflows

As an equal opportunity employer, we celebrate diversity and are committed to creating an inclusive environment for all employees

In this role you may be exposed to adult content