Lead SQL Developer at Aylo Health
Montréal, QuebecFull-timeIngénierie/ EngineeringPosted 5 months ago
Apply with PipelineAbout the Role
<p><span style="font-size: 10pt;"><span data-contrast="auto">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.</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559738":100,"335559739":100}"> </span></span></p>
<p><span style="font-size: 10pt;"><span data-contrast="auto">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).</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559738":0,"335559739":0}"> </span></span></p>
<p style="text-align: center;"><span style="font-size: 10pt;"><strong><span data-contrast="auto">*A select number of positions require full-time in office attendance*</span></strong><span data-ccp-props="{"134233117":false,"134233118":false,"335551550":2,"335551620":2,"335559738":0,"335559739":0}"> </span></span></p>
<p><span style="font-size: 10pt;"><span data-contrast="auto">Our Data Warehouse Team is looking for a Lead SQL Developer</span><span data-contrast="auto"> to contribute to the </span>evolution of our enterprise data platform within the Data Warehouse Services team. This role combines<strong> </strong>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.</span></p>
<p><span style="font-size: 10pt;"><strong><span data-contrast="auto">What you'll be doing:</span></strong><span data-ccp-props="{"134233117":false,"134233118":false,"335559685":0,"335559738":240,"335559739":240}"> </span></span></p>
<ul>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">Provide technical leadership and architectural guidance to data engineers and SQL developers, leading design discussions and architecture reviews.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">Establish engineering standards and best practices for data pipelines, lakehouse platforms, and SQL development, including code and design reviews.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">Mentor team members and support their technical growth.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">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.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">Define scalable architecture patterns for lakehouse platforms, Delta Lake tables, data ingestion pipelines, and data quality frameworks.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">Optimize and troubleshoot Spark workloads, Synapse queries, and Azure SQL performance.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">Improve platform reliability, observability, monitoring, and Azure workload cost efficiency.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">Support operational processes including investigating alerts, resolving data pipeline failures, and improving operational runbooks.</span></li>
</ul>
<p><span style="font-size: 10pt;"><strong><span data-contrast="auto">What you'll need to be successful:</span></strong><span data-contrast="auto"> </span><span data-ccp-props="{"134233117":false,"134233118":false,"335559685":0,"335559738":240,"335559739":240}"> </span></span></p>
<p><span style="font-size: 10pt;"><strong><span data-contrast="auto">Must Haves:</span></strong><span data-ccp-props="{"134233117":false,"134233118":false,"335559685":0,"335559738":240,"335559739":240}"> </span></span></p>
<ul>
<li style="font-size: 10pt;"><span style="font-size: 10pt;" data-contrast="auto">6+ years of experience in data development.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">2+ years experience leading or mentoring technical teams.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;" data-contrast="auto">2+ years of hands-on Azure Cloud experience, including proficiency in Synapse Analytics, Azure SQL Database, Data Lake Storage Gen2, and Delta Lake.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;" data-ccp-props="{"134233117":false,"134233118":false,"335559738":240,"335559739":240}">Hands-on experience with PySpark, Delta Lake/lakehouse architectures, and large-scale data ingestion pipelines.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;" data-contrast="auto">Strong T-SQL knowledge and relational database design.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;" data-contrast="auto">Experience designing and implementing ETL/ELT pipelines.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;" data-contrast="auto">Strong troubleshooting skills in data pipeline and database performance issues.</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;" data-contrast="auto">Experience working with hybrid environments (Azure, on-prem SQL Server).</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;" data-contrast="auto">Strong communication and leadership skills.</span></li>
</ul>
<p><span style="font-size: 10pt;"><strong><span data-contrast="auto">Nice to Haves:</span></strong><span data-ccp-props="{"134233117":false,"134233118":false,"335559685":0,"335559738":240,"335559739":240}"> </span></span></p>
<ul>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience with Microsoft Fabric</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience implementing CI/CD pipelines (Azure DevOps / Git)</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience with cost optimization of cloud data platforms</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">Familiarity with Azure networking and integration runtimes</span></li>
<li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience designing data quality and observability frameworks</span></li>
<li style="margin-top: 0px; margin-bottom: 0px; vertical-align: middle; color: black; font-size: 10pt;"><span style="font-family: helvetica; font-size: 10.0pt;">Demonstrated judgment reviewing and correcting AI-generated code</span></li>
<li style="margin-top: 0px; margin-bottom: 0px; vertical-align: middle; color: black; font-size: 10pt;"><span style="font-family: helvetica; font-size: 10.0pt;">Evidence of having restructured workflows around AI, beyond occasional use</span></li>
<li style="margin-top: 0px; margin-bottom: 0px; vertical-align: middle; color: black; font-size: 10pt;"><span style="font-family: helvetica; font-size: 10.0pt;">Hands-on experience building or configuring AI agents and automated workflows</span></li>
</ul>
<p> </p>
<p><span style="font-size: 10pt;" data-ccp-props="{"134233117":false,"134233118":false,"335559685":720,"335559738":0,"335559739":0}"> </span></p>
<p style="text-align: center;"><span style="font-size: 10pt;"><strong><span data-contrast="auto">As an equal opportunity employer, we celebrate diversity and are committed to creating an inclusive environment for all employees</span></strong><span data-ccp-props="{"335551550":2,"335551620":2}"> </span></span></p>
<p style="text-align: center;"><span style="font-size: 10pt;"><strong><span data-contrast="auto">In this role you may be exposed to adult content</span></strong><span data-ccp-props="{"335551550":2,"335551620":2}"> </span></span></p>
<p> </p>