inhousefyi
← Back to listings

Lead SQL Developer

Montréal, Quebec, Canada · Posted 6 months ago
Full-time
Apply now

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

Similar jobs

Aylo CareersMontréal, Quebec, Canada

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 collabor…

Full-time
Aylo CareersThessaloniki, Greece

Est. 45,000 EUR

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 collabor…

Full-time
Aylo CareersNicosia, Cyprus

Est. 55,000 EUR

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 collabor…

Full-time
Aylo CareersMontréal, Quebec, Canada

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 collabor…

Full-time
Aylo CareersMontréal, Quebec, Canada

Availability required: 6:00 PM to 2:00 AM EST/EDT (Montreal time) 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.…

Full-time
Aylo CareersRemote

Est. 60,000 EUR

Availability required: 1:00 AM to 8:00 AM Cyprus time (Europe/Nicosia time zone) Established in 2004, we are a tech pioneer offering world-class adult entertainment and games on some of the internet’s safest and most pop…

Full-timeRemote
Aylo CareersRemote

Est. 55,000 EUR

Availability required: 1:00 AM to 8:00 AM Cyprus time (Europe/Nicosia time zone) Established in 2004, we are a tech pioneer offering world-class adult entertainment and games on some of the internet’s safest and most pop…

Full-timeRemote
Aylo CareersRemote

Est. 60,000 EUR

Availability required: 1:00 AM to 8:00 AM Cyprus time (Europe/Nicosia time zone) Established in 2004, we are a tech pioneer offering world-class adult entertainment and games on some of the internet’s safest and most pop…

Full-timeRemote
Aylo CareersMontréal, Quebec, Canada

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 collabor…

Full-time
VMLCopenhagen, Capital Region, Denmark

Est. 650,000 DKK

Who We Are VML is a leading creative company that combines brand experience, customer experience, and commerce, creating connected brands to drive growth. VML is celebrated for its innovative and award-winning human-firs…

Full-time
AxleRockville, Maryland, United States

Est. 165,000 USD

(ID: 2026-1572) Axle is a bioscience and information technology company that offers advancements in translational research, biomedical informatics, and data science applications to research centers and healthcare organiz…

Full-time
AxleLondon, United Kingdom

Est. 80,000 GBP

(ID: 2026-2740) Axle Informatics is a bioscience and information technology company advancing translational research through biomedical informatics, data science, artificial intelligence, and intelligent automation. We p…

Full-time
SonatusDublin, Ireland

Est. 95,000 EUR

At Sonatus, we’re driving the transformation to AI-enabled software-defined vehicles. Traditional automotive software methods can’t keep pace with consumer expectations shaped by the mobile industry—where features evolve…

Full-time

Est. 250,000 USD

USA (Remote) with 35-40% Travel Robots & Pencils is an applied AI engineering firm building the next frontier of business architecture. We design and ship AI co-workers that integrate into enterprise operations and d…

Full-timeRemote

Robots & Pencils is an applied AI engineering firm building the next frontier of business architecture. We design and ship AI co-workers that integrate into enterprise operations and deliver measurable results for ou…

Full-timeRemote
WPP MediaGurgaon, India

About WPP Media WPP is the trusted growth partner for the world’s leading brands. With exceptional talent, trusted data and intelligence, and world-class partnerships – all united by our pioneering agentic marketing plat…

Full-time
Sr. Legal Counsel3 months ago
Aylo CareersMontréal, Quebec, Canada

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 collabor…

Full-time
84.51°Cincinnati, Ohio, United States

Est. 166,000 USD

84.51° Overview: 84.51° is a retail data science, insights and media company. We help The Kroger Co., consumer packaged goods companies, agencies, publishers and affiliates create more personalized and valuable experienc…

Full-time
AxleRemote

Est. 140,000 USD

(ID: 2026-3404) Axle Informatics is a bioscience and information technology company committed to accelerating biomedical discovery through data science, software engineering, scientific computing, and research technology…

Full-timeRemote
84.51°Cincinnati, Ohio, United States

Est. 133,525 USD

84.51° Overview: 84.51° is a retail data science, insights and media company. We help The Kroger Co., consumer packaged goods companies, agencies, publishers and affiliates create more personalized and valuable experienc…

Full-time
EncoraRemote

Job Title: Senior Data EngineerKey Skills: DBT, Python, SQL, Snowflake, DatabricksLocation: BrazilMode: RemoteWe at Coforge are hiring Senior Data Engineer with the following skill set.Key Responsibilities Delivery &…

Full-timeRemote
WPP MediaRemote

About WPP Media WPP is the trusted growth partner for the world’s leading brands. With exceptional talent, trusted data and intelligence, and world-class partnerships – all united by our pioneering agentic marketing plat…

Full-timeRemote
WPP MediaRemote

About WPP Media WPP is the trusted growth partner for the world’s leading brands. With exceptional talent, trusted data and intelligence, and world-class partnerships – all united by our pioneering agentic marketing plat…

Full-timeRemote
WPP MediaRemote

About WPP Media WPP is the trusted growth partner for the world’s leading brands. With exceptional talent, trusted data and intelligence, and world-class partnerships – all united by our pioneering agentic marketing plat…

Full-timeRemote
WPP MediaRemote

About WPP Media WPP is the trusted growth partner for the world’s leading brands. With exceptional talent, trusted data and intelligence, and world-class partnerships – all united by our pioneering agentic marketing plat…

Full-timeRemote
WPP MediaRemote

About WPP Media WPP is the trusted growth partner for the world’s leading brands. With exceptional talent, trusted data and intelligence, and world-class partnerships – all united by our pioneering agentic marketing plat…

Full-timeRemote
WPP MediaRemote

About WPP Media WPP is the trusted growth partner for the world’s leading brands. With exceptional talent, trusted data and intelligence, and world-class partnerships – all united by our pioneering agentic marketing plat…

Full-timeRemote
84.51°Cincinnati, Ohio, United States

Est. 166,000 USD

84.51° Overview: 84.51° is a retail data science, insights and media company. We help The Kroger Co., consumer packaged goods companies, agencies, publishers and affiliates create more personalized and valuable experienc…

Full-time
WorkatoSingapore, Singapore

About Workato Workato delivers enterprise infrastructure for the agentic era, redefining iPaaS and helping enterprises unify data, applications, processes, and AI into a single, governed platform. A leader in Enterprise…

Full-time
BOLDNoida, Uttar Pradesh, India

BOLD is seeking for the newest addition to our existing Data Science team, you’ll combine your analytical skills and business knowledge to deliver key insights to our Product and Management teams. You’ll help drive produ…

Full-time