Jr Data Engineer - Custom Solutions

About the role

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 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 communic

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Citylitics? Share your experience