SQL Developer

Job summary

Develop, optimize, and maintain SQL queries, database objects, schemas, data models, and ETL/ELT pipelines across relational and cloud data platforms. Build trusted reporting and data warehouse solutions, ensure data quality and security, troubleshoot issues, and collaborate with technical and business teams.

Job details

What you’ll do Write, optimize, and maintain complex SQL queries, stored procedures, functions, views, and triggers Design and improve relational database schemas, indexing strategies, and data models (normalized and dimensional) Build and maintain ETL/ELT pipelines using SSIS, Azure Data Factory, dbt, Airflow, Informatica, or similar tools Work across platforms such as SQL Server, PostgreSQL, MySQL, Oracle, Snowflake, BigQuery, Redshift, or Azure SQL Tune slow queries using execution plans, indexing, and partitioning, and make them measurably faster Develop data marts, warehouses, and reporting layers that analysts and BI tools can trust Build reports and dashboards with Power BI, Tableau, SSRS, or Looker, or support the teams who do Maintain data quality, validation, and reconciliation so the numbers always tie out Support migrations, upgrades, and cloud moves of databases and data platforms Manage security, access controls, backups, and documentation, and support audits and privacy requirements (PIPEDA, SOX, and others) Troubleshoot data issues, find the root cause, and fix the process behind them Work with analysts, application developers, and business stakeholders to turn questions into reliable data solutions Find your level Level Typical experience What you’ll own SQL Developer I - 0-2 years : Queries, reports, and well-scoped database changes, learning our data model with a dedicated mentor and code review SQL Developer II - 2-5 years : Owning pipelines and data models end to end, tuning performance, leading migrations, mentoring newer developers Senior SQL Developer - 5+ years : Architecting data solutions, setting database standards, leading major initiatives, advising teams on design and performance Promotion criteria are written down at every level, with regular career conversations. Many of our senior developers have moved into data engineering, data architecture, analytics engineering, and database leadership. What you bring Must have Strong SQL: joins, subqueries, CTEs, window functions, aggregations, and set-based thinking Understanding of relational database design, normalization, and indexing Hands-on experience with at least one major database platform (SQL Server, PostgreSQL, MySQL, or Oracle) Attention to detail and a habit of checking that the numbers are right Clear communication, able to explain data logic to non-technical colleagues Degree or diploma in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or equivalent experience. Bootcamp graduates and self-taught developers are welcome. We hire for skill, not pedigree. Legal authorization to work in Canada (citizens, permanent residents, and valid work permit holders) Nice to have (not required) Experience with ETL/ELT tools (SSIS, Azure Data Factory, dbt, Airflow) and data warehousing concepts Cloud data platforms: Snowflake, Databricks, BigQuery, Redshift, or Azure Synapse BI tools: Power BI, Tableau, or SSRS Scripting in Python or PowerShell for automation Performance tuning experience using execution plans and query profiling Certifications: Microsoft DP-300, DP-203, Oracle SQL, Snowflake SnowPro, or similar Familiarity with Git, CI/CD for database changes, and Agile workflows Industry background in [finance, healthcare, retail, insurance, SaaS, government, etc.] Fluency in French, an asset for roles serving Quebec or bilingual teams [if applicable] A GitHub repo, portfolio, or personal data project you can show off

What you’ll do

Develop, optimize, and maintain SQL queries, database objects, schemas, data models, and ETL/ELT pipelines across relational and cloud data platforms. Build trusted reporting and data warehouse solutions, ensure data quality and security, troubleshoot issues, and collaborate with technical and business teams.

Requirements

Requires strong SQL skills, knowledge of relational database design and indexing, and hands-on experience with at least one major database platform. Candidates need clear communication skills and a relevant degree or diploma, or equivalent experience, and must be legally authorized to work in Canada.

Listed skills

• SQL · Preferred
• Power BI · Preferred
• Tableau · Preferred
• Python · Preferred
• Git · Preferred
• Communication · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Relational Database Design
• Query Optimization
• Stored Procedures
• Database Indexing
• ETL/ELT Pipelines
• Data Modeling
• Data Warehousing
• Data Quality
• Performance Tuning
• Database Migration
• Power BI
• Tableau
• Python
• Git
• Communication

Job areas

• Data & Analytics
• Technology
• Software

More jobs from SMARTFOX