Aylo

Tech / AI / Software

LeadSQLDeveloper

montréal, quebec, canada; austin, texas, united states; nicosia, nicosia, cyprus Remote Friendly
Market Sentiment
HIGH DEMAND

Neural analysis suggests this role is
optimal for Lead candidates.

The Brief

“Lead SQL Developer at Aylo. Skills: SQL Development, Azure Data Platform, Data Pipelines, Lakehouse Architecture, Technical Leadership. Provide technical leadership and architectural guidance to data engineers and SQL developers. leading design discussions and architecture reviews”

What You'll Achieve.

contribute to the evolution of our enterprise data platform; enable safe user experiences; empower our communities; maintaining robust trust-and-safety protocols

Industry & Context.

Tech / AI / Software
Problems you'll solve

Optimize and troubleshoot Spark workloads, Synapse queries, and Azure SQL performance; investigating alerts; resolving data pipeline failures

Eligibility Requirements

A select number of positions require full-time in office attendance, In this role you may be exposed to adult content

What They're Looking For.

Must Have

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

Nice to Have

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

What You'll Do.

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

including code and design reviews

Mentor team members and support their technical growth

Design and evolve a modern Azure data platform

Define scalable architecture patterns for lakehouse platforms

data ingestion pipelines

and data quality frameworks

Optimize and troubleshoot Spark workloads

and Azure SQL performance

Improve platform reliability

and Azure workload cost efficiency

Support operational processes including investigating alerts

resolving data pipeline failures

and improving operational runbooks

How You'll Work.

Team & Collaboration

international team of dynamic and collaborative innovators; guide a team of data engineers; Provide technical leadership and architectural guidance to data engineers and SQL developers; leading design discussions and architecture reviews; Mentor team members

Communication Scope

communication and leadership skills

Full 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 relia

Free ATS check

Applying for this Lead SQL Developer role?

Most applicants get filtered before a human reads their resume. See if yours makes the cut.

How to Apply on Greenhouse

  • Create a Greenhouse profile before applying — it saves time across multiple applications.
  • Upload your resume as a PDF; the parser handles it better than Word.
  • Answer all knockout questions carefully — wrong answers auto-reject before a human sees you.
  • Enable email notifications to track application status in real time.

ANONYMOUS · UNFILTERED

What do employees actually say about Aylo?

Real rants from real employees. Read before you apply.

Read Company Rants →