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
Senior Data Engineer building Dandy’s data infrastructure for its technology - powered dental operating system. Developing pipelines, governed data products, and AI - ready platform capabilities.
Senior Data Engineer supporting the Government of Alberta’s Data Management Platform. Building, monitoring, and modernizing Talend integrations, ETL/ELT pipelines, APIs, and data services.
Data Engineer building cloud data pipelines, models, and analytics infrastructure for Boeing’s aviation programs. Supporting machine learning applications and data governance from Richmond/Vancouver.
Data Engineer building cloud - based data pipelines and analytics infrastructure for Boeing’s aviation programs. Supporting machine learning, data governance, and high - performance systems from Richmond/Vancouver.
Data Engineer building trusted data pipelines for Crux’s clean - energy capital platform. Automating surveys, reporting datasets, and research queries for Market Intelligence.
ETL Data Engineer designing Informatica ETL pipelines and Hadoop workflows. Supporting SQL - driven reconciliation, data quality, BI reporting, and analytics solutions.
Data Engineer building Spark pipelines and analytics data models for Dropbox’s file collaboration platform. Supporting datamarts, KPIs, data quality, and production reliability.
Data systems engineer building Python pipelines and APIs for Northbeam’s marketing intelligence platform. Improving integrations, transformations, monitoring, and real - time data flows.
Staff Software Engineer owning ingestion and integration architecture for Northbeam’s marketing intelligence platform. Setting data - processing standards across ad, commerce, and real - time event systems.