Companies Aylo Careers Lead SQL Developer

About the role

Aylo Careers

 

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 

 

Ready to apply to Aylo Careers?
Apply to Aylo Careers
Apply now
🤖

Whoa — hold up

JobsRadar was built for real people having a rough time in their job search — not for automated requests. You're clicking way too fast and you're now temporarily blocked.

Come back later. If you're genuinely job hunting, we've got your back — just act like a human.

Catch your next role the second it’s posted.

Create a free account and we’ll watch the boards for you — the instant a job matches your search, it lands in your inbox or Telegram. No digging, no refreshing.

Create free account

Free forever · takes 30 seconds · already have one?

Get the worldwide-remote edge.

Join our Telegram channel for the stuff that helps you land the role — salary benchmarks, the weekly market pulse, and new-feature drops. No spam, just signal.

Join the channel — it's free