Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • Junior Data Engineer building Airflow and BigQuery pipelines for Citylitics, which transforms infrastructure data into predictive market and sales intelligence. Supporting custom client solutions and data products.

Responsibilities

  • 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

  • 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

  • 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

Job title

Job type

Full Time

Experience level

Junior

Salary

Not specified

Degree requirement

No Education Requirement

Tech skills

AirflowBigQueryCloudETLGoogle Cloud PlatformPythonSQL

Location requirements

HybridTorontoCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.