Overview:
Every day, Imagine Communications is delivering billions of media moments all over the world — anywhere, anytime and on any device. Imagine Communications delivers innovative, end-to-end media software and networking solutions to over 3,000 customers in more than 185 countries, including the top broadcast facilities and the most technologically advanced sports and live-event venues.
Why Imagine?
Imagine Communications offers a generous Medical, Dental, Vision and Life Insurance package. We like to make sure all our employees are safe when travelling so we’ve got travel insurance covered too. Employee Wellbeing is a priority for us, so all employees and their family have access to our EAP and Wellness programs, including LifeSpeak and Vitality. Volunteer in your community and we will pay for that too.
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
Celebrating difference, together stronger
At Imagine Communications, we don’t just accept difference — we celebrate it, we support it, and we thrive on it for the benefit of our customers, our employees, our products, and our communities. We are committed to providing an environment of mutual respect. Imagine Communications is proud to be an equal opportunity workplace and is an affirmative action employer.
