Lead SQL Developer at Aylo

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