Source description
About the role
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
-
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
More at Aylo