Lead SQL Developer
Aylo
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 Demonstrated judgment reviewing and correcting AI-generated code
- Evidence of having restructured workflows around AI, beyond occasional use
- Hands‑on experience building or configuring AI agents and automated workflows
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
#J-18808-Ljbffr- ...(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...SuggestedFull timeWork at officeLocal areaRemote work
- ...Company Description IT Job Description Role: Lead ETL Developer Location: Montreal, QC Duration: Fulltime BGV will be done... ...; using stored procedures, user defined functions and embedded SQL in other Programming Languages. - Must have Unix shell scripting...SuggestedFull timeRelocation
- ...enjoying ourselves. We wake up every day inspired to build a more efficient and enjoyable world. Role overview As a Lead Software Developer, we expect you to be disciplined regarding software development, ready and eager to lead projects and initiatives, and...SuggestedFull timeWork at officeFlexible hours
- ...centre-ville de Montréal. Nous sommes à la recherche d’un(e) Team Lead pour venir compléter notre équipe travaillante et dédiée aux... ...the heart of downtown Montreal. We are looking for a Team Lead (Developer) to complement our hardworking teams dedicated to the tech challenges...SuggestedDaily paidFull time
- ...Company Description Astucemedia is a global leader in innovative creative and software solutions for real-time data visualization... ...Qatar, and Times Square. Job Description As a Lead Front & Back-End Developer at Astucemedia, you will bridge the gap between high-level...SuggestedFull time
- ...Quantitative Developer, Investment Platforms Location: Montreal (Hybrid: 3 days in-office... ...contracts; mentor the team on best practices. Lead AI-native development : Evolve how the... ...Proficiency: Expert-level Python, SQL/PostgreSQL, data modeling, and API design....Daily paidFull timeContract workApprenticeshipWork at officeImmediate startRemote workDay shift
- ...À propos du poste TS Imagine, un leader mondial des logiciels SaaS de trading... ...données haute performance en Python, SQL, Snowflake et dbt afin de transformer... ...management SaaS-based software, is seeking a Lead Quantitative Data Developer to join our Models and Quantitative...Full timeWork at officeWorldwideDay shift
$96.56k - $128.74k per year
...new markets, reduce risks, all towards the goal of making Canada and the world better through trade. Position: Senior Software Developer (Lead) Employment Type: Permanent Compensation Details: ~ Software Engineer 18: Salaries typically range from $96,557 to $128...Permanent employmentFull timeWork at officeRelocation packageFlexible hours3 days per week- ...’écrit). Personne dynamique axée sur les résultats ayant un fort esprit d’équipe et un bon sens de l’initiative. C++ Software Developer Position description: The Software Developer role within the Magnetic Anomaly Detection (MAD) Engineering group is to develop...Flexible hours
- ...Having an in-depth analysis and understanding of software development and customer issues, the Lead Software Developer evaluates and selects possible technology options for a project. They take part in evaluating efforts, solving problems and ensuring the quality of solutions...
- ...technologique hautement collaboratif, vous agirez à titre de leader technique pour notre équipe de gestionnaires de flux (... ...participants. Job Summary Exegy is seeking a highly motivated Lead C++ Software Developer to join our Market Data Engineering group in Montreal....Long term contractFull timeWork at office
- ...Description Frank & Oak is a leading vertically integrated menswear... ...for breakfast. Our Backend Developer will help Frank & Oak deliver... ...Proficiency with PHP, MySQL & SQL Working knowledge of XML and... ...Build your profile as a thought leader in the industry, backed by a...Full time
- ...Lead Developer - Tools Who We Are 2K is headquartered in Novato, California and is a wholly owned label of Take-Two Interactive Software, Inc. (NASDAQ: TTWO). Founded in 2005, 2K Games is a global video game company, publishing titles developed by some of the most influential...Casual workWork from home
- ...Americas, APAC, and EMEA. By partnering with leading technology providers, we craft... ...engagement and drive business success. The team develops applications that support Regulatory Reporting... ...back on applications across Java, Python, SQL, and more. You will be expected to drive...Ongoing contractFull timeInternshipLocal areaWorldwideWork visaFlexible hours
- ...attendance* As a Full Stack Java/React Developer, you will work on large-scale web... ...functional teams (Frontend, QA, DevOps, and team leads) to achieve project objectives. Partner... ..., and Hibernate. ~ Strong knowledge of SQL databases, including writing queries and designing...Full timeWork at officeLocal areaRemote work
- ...Company Description IT Job Description Role: Database Developer Location: Montreal, QC Duration: Fulltime BGV will be done... ...of experience • Strong database experience • Very strong SQL skills (preference for the DB2 platform) • Database Design, STAR...Full timeRelocation
- ...Company Description Ubisoft is a global leader in gaming with teams across the world... ...unknown! Job Description As a Data Developer at Ubisoft Montreal , you will join the... ...What you bring to the team Advanced SQL skills for data analysis and transformation...Full timeWork at office
- ...systèmes de base de données tels que SQL, NoSQL et vector... ...Tower Research Capital is a leading quantitative trading firm founded... ...Engineers thrive at Tower while developing electronic trading infrastructure... ...department is seeking a Software Developer II to join the Data team in...Full timeApprenticeshipCasual workWork at officeWorldwide
- ...Company Description IT Job Description Role: Java Developer Location: Montreal, Canada Duration: Fulltime BGV will be... ...Hands-on experience on Software Application development Good in SQL joins, sub queries, referential integrity, Able to work independently...Full timeRelocation
- ...We're seeking a talented Data Platform Developer to join our Platform Engineering team and architect... ...and model training Work with the Lead Software Architect to ensure data architecture... ...Delta Lake, Iceberg) ~ Proficiency with SQL and database design including both...Full timeWorldwide
- ...GURUS Solutions is a leading NetSuite consulting firm providing ERP... ...Software Development, the Team Lead will play a pivotal role in managing... ..., and well-being of a team of developers. This role combines technical... ...People & Team Management Develop and execute a strategic vision...Long term contractFull timeFlexible hours
- ...’s Trading, Risk and Prime Brokerage products. As an Analytics Developer you’ll build both the foundation and the intelligence on top of it... ...-paced, innovative setting. What You Bring ~ Strong SQL skills and hands-on experience with Snowflake. ~ Proficiency...Full timeWork at officeWorldwide
$110k - $130k per year
...looking for an experienced .NET Full Stack Developer. This role suits someone who has built and... ..., reliability, and scale. Work across SQL Server and other relational stores, contributing... ...centre-of-excellence teams. ~ Work on leading-edge engagements with top-tier banks,...Long term contractFull timeFlexible hours- ...Kubernetes). Excellentes compétences en SQL et expérience de collaboration sur des... ...affiliate logic engine). As a Senior ML/DL Developer in the Neuro Squad, you will architect the... ...levels and honing their superpowers. Lead with Impact: We empower our team members...Full timeApprenticeshipWork at officeFlexible hours
- ...développer et améliorer le courtier de projections SQL au sein du DAL (Data Access Layer) pour... ...a part of a dynamic team as a Java/Scala Developer for one of our clients. This is an... ...trading platforms to critical applications for leading airlines. We recruit professionals who are...Full timeApprenticeshipLocal areaWorldwide
- ...sur la conception de semantic layers avancés , l'écriture de SQL complexe et la livraison de dashboards robustes, publiés dans un... ...in a meeting room with a client. This role is posted as BI Developer , with the internal title of Spécialiste Données, volet Analytique...Daily paidPermanent employmentFull timeWork at officeRemote workFlexible hours2 days per week
- ...the world deserves energy without compromise. dcbel is at the leading edge of the residential energy revolution. Its products enable... ...The opportunity dcbel is looking to hire a UI embedded developer to work in our growing team. The successful candidate will play...Full timeFlexible hours
- ...Requirement This position is for a senior Java/Database developer (5-7 years experienced ideally) for Securities Reference Data.... ...programming languages (Java or Python) # RDBMS (Well versed with SQL, DB fundamentals like tables, triggers, , stored Procs etc.) #...Full time
- ...Expertise pratique en développement Tableau. Solides compétences en SQL (idéalement dans MariaDB/MySQL ou Snowflake). Expérience en... ...you ready to make data come alive? As a Business Intelligence Developer at TS Imagine, you’ll create interactive, visually stunning...Full timeWork at officeWorldwideDay shift
- ...We are currently hiring an Data Governance Lead for our global consulting client. Role... ...MONTREAL, QUEBEC Key Responsibilities Develop and implement enterprise data governance... ...Management Data Warehousing SQL DAMA-DMBOK GDPR CCPA SOX HIPAA...Full time
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Lead SQL Developer. Be the first to apply!


