Junior Data Engineer

Citylitics Inc.

. Design, build, and maintain highly performant, reliable, and maintainable pipelines using Airflow and BigQuery .

Posted 9/18/2026full-timeToronto • CanadaJuniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and maintaining data pipelines using Airflow and BigQuery, with a strong foundation in Python and SQL. Capable of collaborating with cross-functional teams to translate client requirements into effective technical solutions while optimizing data infrastructure and processes.

Highest-signal resume keywords

Python ProficiencySQL ProficiencyAirflow/Cloud Composer ExperienceBigQuery ExperienceData Warehousing Principles

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data Pipeline DevelopmentETL/ELT UnderstandingData ModelingIdempotent Pipeline BuildingQuery Optimization

Soft Skills

Problem-Solving SkillsCommunication SkillsCollaboration Skills

Tools & Technologies

GitGCPAI Tools

Industry Keywords

Data EngineeringData InfrastructureCustom SolutionsInteractive DashboardsData Apps

Tech Stack

Tools & technologies

AirflowBigQueryCloudETLGoogle Cloud PlatformPythonSQL

About the role

Key responsibilities & impact

Design, build, and maintain highly performant, reliable, and maintainable pipelines using Airflow and BigQuery
Handle pipeline design, development, testing, deployment, monitoring, and maintenance
Collaborate with data analysts and stakeholders to define data requirements
Design efficient data models within BigQuery
Optimize queries and pipeline/dashboard performance
Serve as the dedicated data engineering resource for Custom Solutions work
Partner with Data, Product, and Customer Success teams to take bespoke client requests from validated proof-of-concept through production
Translate client requirements into technical solutions
Communicate technical details and project progress to stakeholders
Contribute to improvements in data infrastructure and processes
Suggest and implement new technologies and best practices
Leverage AI tools to accelerate development, debugging, design, and documentation
Other duties as assigned

Requirements

What you’ll need

Proficiency in Python and SQL
2+ years of experience building and maintaining data pipelines using Airflow/Cloud Composer
Strong understanding of data warehousing principles
Experience working with BigQuery
Understanding of ETL/ELT, data modeling, and building idempotent, reliable pipelines
Experience with Git and cloud platforms, preferably GCP
Experience building and deploying interactive dashboards or data apps, such as Dash on Cloud Run, is a plus
Excellent problem-solving skills and a proactive approach to identifying and resolving issues
Excellent communication and collaboration skills
Comfort and enthusiasm for using AI tools like Claude in daily workflow

Benefits

Comp & perks

Make real-world impact by influencing positive change across sustainable public infrastructure
Represent a differentiated, data-driven infrastructure platform
Work at the intersection of infrastructure, scale-up, and data science
Fast-paced environment with opportunities to accomplish more quickly than at large technology companies
Access to generative AI tools and the company's full data universe
In-role coaching
Skill-based development
Internal mentorship program
Clear internal promotion pathways
Collaborative team environment with celebration of progress
Equal opportunity, safe, diverse, and inclusive workplace