Aylo
Lead SQL Developer
Montréal, Quebec · Full-time
Sponsorship not specifiedDetected 83 days ago
GitSQLAzureCI/CDDevOpsSparkData EngineeringLeadershipCommunicationMentoring
About the role
- 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.
- This role combines technical leadership and hands-on engineering.
Responsibilities
- 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.
- Optimize and troubleshoot Spark workloads, Synapse queries, and Azure SQL performance.
- Support operational processes including investigating alerts, resolving data pipeline failures, and improving operational runbooks.
- Strong T-SQL knowledge and relational database design.
Requirements
- 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.
- Experience designing and implementing ETL/ELT pipelines.
- 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
Company info
- 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.
Equal opportunity
- As an equal opportunity employer, we celebrate diversity and are committed to creating an inclusive environment for all employees
This listing is sourced directly from Aylo's careers page and normalized into a canonical job model.