A Bit About The Role
We're looking for a Junior SQL Developer to join our data team. Your day-to-day is writing and reading SQL - primarily in Snowflake - to support our reporting and analytics. You'll write and maintain the queries and views behind our Snowflake dimensions, facts, and reporting layer, and you'll also get hands-on exposure to our Oracle environment, where you'll learn to read and understand the SQL behind our Oracle Fusion BI Publisher (BIP) reports.
This is a hands-on role with genuine room to grow. You'll start close to the data - writing queries and validating outputs - and take on more as your skills develop. We care as much about curiosity, attention to detail, and work ethic as we do about years on a resume.
- Write, test, and optimize SQL queries and views in Snowflake - this is the core of the role
- Maintain the SQL behind our Snowflake dimensions, facts, and reporting views that feed Power BI reporting
- Read and interpret the SQL behind existing Oracle Fusion BIP reports to understand how they work and support changes over time
- Support ETL/ELT work and help keep reporting data accurate and consistent
- Run data validation and quality checks, and help troubleshoot discrepancies in reporting outputs
- Document your SQL so the team can maintain and reuse it
- Work with BI developers and analysts to understand reporting requirements
About You
- Working knowledge of SQL - able to confidently read and write queries (joins, aggregations, filtering, subqueries)
- Understanding of relational database and data-warehousing fundamentals (tables, keys, dimensions vs. facts)
- Strong attention to detail
- Good written and verbal communication skills
- A genuine eagerness to learn and a strong work ethic - you ask "why," dig into problems, and follow through
Nice to Have - Preferred
- 1 to 3 years of hands-on SQL experience in a commercial setting
- Experience with Snowflake or another cloud data warehouse (Redshift, BigQuery, Synapse, Databricks)
- Exposure to Oracle SQL and/or Oracle Fusion BI Publisher (BIP) reports
- Familiarity with Power BI or other BI/reporting tools
- Exposure to ETL/ELT tooling (e.g., Informatica) or Microsoft Fabric (pipelines, notebooks, lakehouses, SQL endpoints)
- Some Python for data work and automation
- Post-secondary education in Computer Science, Data/Information Systems, Mathematics/Statistics, Engineering, or a related field - or equivalent practical experience
Salary Range: $80,000 - $100,000 CAD
