Jr Data Engineer

Citylitics Inc.; Toronto; Hybrid; CAD 65,000 - 90,000; Full time

Benefits offered by this job

Make real-world impact

Sell a differentiated platform

Grow with intention

Mentorship program

Internal promotion pathways

Job summary

Citylitics Inc. is seeking a Junior Data Engineer to design, build, and maintain data pipelines powering customer-facing solutions.

You will work in a collaborative, cross-functional team, leveraging Airflow, BigQuery, and AI-assisted tooling to deliver high-quality data products. The role emphasizes strong Python/SQL skills, data modeling, and production stability, with a hybrid in-office requirement at Citylitics' Toronto office (3+ days/week).

Qualifications

• Requires solid Python and SQL skills.
• 2+ years building and maintaining data pipelines with Airflow/Cloud Composer.
• Strong understanding of data warehousing principles and BigQuery usage.

Responsibilities

• Design, build, and maintain production data pipelines using Airflow and BigQuery.
• Collaborate with analysts and stakeholders to define data requirements and data models.
• Translate client requirements into technical solutions for Custom Solutions work.
• Contribute to ongoing data infrastructure improvements and adopt AI tools to boost productivity.
• Perform other duties as assigned.

Skills

Python

SQL

Collaboration

Problem solving

Communication

Tools

Airflow / Cloud Composer

BigQuery

Git

Dash on Cloud Run

Job description

About Citylitics Inc.

Citylitics delivers predictive intelligence on where, how, and why infrastructure investments will occur across North America.

Infrastructure includes the foundational systems that shape our quality of life: water, transportation, transit, roads and highways, broadband, and power. It represents a multi-trillion-dollar market and a 20+ year megatrend in North America. Citylitics transforms millions of documents across more than 40,000 cities, utilities, and public agencies into real-time market signals and high-value sales intelligence. Leading infrastructure vendors, engineering firms, and construction companies use the platform to identify and pre-position for major infrastructure opportunities earlier, helping them build relationships, shape project priorities, and influence scope before projects move to formal procurement. Citylitics combines a network of AI agents, fine-tuned models, a proprietary infrastructure signals graph, and daily human-in-the-loop quality assurance workflows to deliver highly nuanced and reliable sales intelligence. The platform integrates seamlessly with CRMs, ERPs, and data lakes, embedding actionable insights directly into sales workflows so teams can prioritize the right pursuits and build stronger pipelines.

Our mission is to improve how infrastructure investments get made so critical needs can be addressed earlier and communities benefit from stronger, more resilient infrastructure.

Join Citylitics to work in a meaningful industry that will matter for decades to come while helping grow a company at the forefront of applied AI. We operate with a Results-Driven Mentality and a commitment to Raise The Bar, in a collaborative environment where Teamwork Makes the Dream Work as we tackle big challenges and celebrate wins together.

Who Are We Looking For?

We're looking for a skilled and enthusiastic Junior Data Engineer to join our growing team! We're a close-knit group building and maintaining mission-critical data products, and we need someone who can hit the ground running.

This role requires a solid understanding of data engineering best practices, and experience with orchestration, data modeling, and data warehouses. You'll be responsible for designing, building, and maintaining production data pipelines that power customer-facing solutions. You'll leverage various technologies we already use, including GCP services like Cloud Composer, Cloud SQL, and BigQuery.

Beyond the technical skills, we value collaboration, a proactive approach to problem-solving, and a willingness to learn and adapt to evolving technologies. If you're passionate about data, thrive in a collaborative environment, and are excited by the prospect of working on impactful projects, we encourage you to apply.

This is a hybrid role based out of Citylitics' Toronto office and requires 3+ days in-office per week.

What Will You Accomplish? / How You Will Make An Immediate Impact:

• Design, build, and maintain: Develop and deploy highly performant, reliable, and maintainable pipelines using Airflow and BigQuery. This includes everything from initial design and development through testing, deployment, and ongoing monitoring and maintenance
• Data Modeling & Optimization: Collaborate with data analysts and stakeholders to define data requirements, and design efficient and effective data models within BigQuery. You'll be optimizing queries and pipeline/dashboard performance for maximum efficiency
• Custom Solutions: Serve as the dedicated data engineering resource for our Custom Solutions work, partnering closely with Data, Product, and Customer Success teams to take bespoke client requests from validated proof-of-concept through to production. Throughout, you'll translate client requirements into technical solutions and clearly communicate technical details and project progress to stakeholders
• Continuous Improvement: Contribute to the ongoing improvement of our data infrastructure and processes, including suggesting and implementing new technologies and best practices. We're a team that actively uses AI tools to work smarter - from accelerating development and debugging to assisting with design and documentation. We're looking for someone who's comfortable leveraging AI to boost their productivity and is excited to help us find new ways to build faster and better
• Other duties as assigned

Requirements

• Proficiency in Python and SQL
• Proven experience (2+ years) building and maintaining data pipelines using Airflow/Cloud Composer.
• Strong understanding of data warehousing principles and experience working with BigQuery
• Understanding of data engineering fundamentals, like ETL/ELT, data modeling, and building idempotent, reliable pipelines
• Experience with Git and cloud platforms (GCP preferred)
• Experience building and deploying interactive dashboards or data apps (e.g., 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 - you'll be working closely with analysts and other stakeholders
• Comfort and enthusiasm for using AI tools like Claude in your daily workflow

Vacancy Status

This position is for an existing and active vacancy that the company is currently seeking to fill.

Benefits

• Make real-world impact: Influence positive change across one of the biggest societal challenges of our generation: building and maintaining sustainable public infrastructure
• Sell a genuinely differentiated platform: You'll represent a disruptive, data-driven solution with a compelling value proposition in a market that is eager to engage
• Operate at the intersection of infrastructure, scale-up, and data science: We live where infrastructure meets AI and advanced data. There is no other team like ours in Toronto
• Move fast, learn faster: There's no corporate bureaucracy here. You'll accomplish more in a few months than you would in years at a large, entrenched technology company
• Be empowered by data and AI: We believe Data and AI will play an outsized role in the future of sales and decision-making. Every CityZen has access to generative AI tools and our full data universe to enhance productivity and encourage experimentation
• Grow with intention: We invest deeply in our people through in-role coaching, skill-based development, an internal mentorship program, and clear internal promotion pathways
• Win as a team: We work hard, we support one another, and we celebrate progress along the way. We're serious about solving infrastructure and just as serious about enjoying the journey together

Citylitics is an equal opportunity employer. We are passionate about providing a safe workplace where everyone is accepted and has the opportunity to grow with us. We are committed to making diversity and inclusivity part of our culture!