Aylo Logo

Aylo

Lead Software Developer

Reposted 2 Days Ago
Be an Early Applicant
Easy Apply
In-Office
Montréal, QC, CAN
Mid level
Easy Apply
In-Office
Montréal, QC, CAN
Mid level
Design and build Azure-native Lakehouse and SQL data solutions using Synapse, Spark, Delta Lake and Data Factory; migrate on-prem SQL/SSIS to Azure; optimize performance, implement governance, and support architecture and documentation.
The summary above was generated by AI

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 


Top Skills

Azure Data Factory
Azure Data Lake Storage Gen2
Azure Devops
Azure Networking
Azure Sql Database
Azure Synapse Analytics
Ci/Cd
Csv
Delta Lake
External Tables
Git
Infrastructure-As-Code
Integration Runtime
JSON
Microsoft Fabric
Monitoring/Logging
Parquet
Polybase
Pyspark
Role-Based Access Control
Spark Pools
SQL Server
Ssas
Ssis
T-Sql

Aylo Montréal, Québec, CAN Office

Montréal, Quebec, Canada

Similar Jobs

10 Days Ago
In-Office or Remote
2 Locations
Expert/Leader
Expert/Leader
Events • News + Entertainment
Lead a team of software developers at Ticketmaster, overseeing the development and maintenance of high-quality backend services while driving collaboration and delivering an exceptional ticketing experience.
Top Skills: AWSDockerGitlabJava 17/21JenkinsKubernetesSpring Boot
9 Days Ago
Hybrid
Montréal, QC, CAN
Senior level
Senior level
Artificial Intelligence • Software
As a Lead Software Developer, you'll guide teams, develop software solutions, mentor colleagues, and consult with clients to deliver quality products.
Top Skills: AngularjsAWSAzureCi/CdGCPJavaJavaScriptPythonReactSvelteTypescript
7 Days Ago
Easy Apply
In-Office or Remote
CA
Easy Apply
Senior level
Senior level
Artificial Intelligence • Software • Generative AI
Lead the development of user-facing features, oversee projects from inception to launch, and mentor junior engineers. Architect scalable APIs integrating AI technologies.
Top Skills: GoJavaNoSQLOpenapiReactRest ApisSQLTypescript

What you need to know about the Montreal Tech Scene

With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.

Key Facts About Montreal Tech

  • Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
  • Major Tech Employers: SAP, Google, Microsoft, Cisco
  • Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
  • Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
  • Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
  • Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account