Jr. Data Engineer

Citylitics delivers predictive intelligence on local utility & public infrastructure markets

What is Infrastructure? It is the roadways you rely on to safely get to Grandma's house, it's the potable water that comes out of your kitchen tap that you wash your family's food with and it's the energy that heats our homes and powers our digital lifestyles.

Every year, trillions of dollars are spent on all areas of infrastructure to maintain our quality life and move our economy forward. However, our infrastructure is no longer equipped to meet the needs of the future. We hear about infrastructure failures, whether bridge collapses, power blackouts, or water main breaks, every day in the news. Climate change and extreme weather events are disrupting the basic infrastructure we took for granted for years.

Citylitics is solving the hardest data problems in infrastructure while building the sales intelligence platform that enables a faster, more transparent, and more efficient infrastructure marketplace. We turn millions of unstructured documents into high value intelligence feeds and datasets that are available on an intuitive user experience. Our goal is to enable solution providers to connect with cities with relevant infrastructure needs in a faster and more digital way than historic market channels. As more companies adopt our platform, cities & utilities will be able to access solutions that deliver on the promise of moving towards a more resilient, sustainable, and equitable infrastructure future.

Who Are We Looking For?

We're looking for a skilled and enthusiastic Jr. 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 and experience with Dash. You'll be responsible for designing, building, and maintaining user-friendly dashboards, leveraging various technologies we already use, including GCP services like BigQuery, Cloud Run, and Cloud Functions. Experience with these specific GCP services is a must.

We're not looking for just someone who knows these tools, but someone who has built with them – ideally, complex and robust applications in a production environment. We're interested in seeing examples of your work, so please be prepared to discuss past projects and challenges you've overcome.

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.

What Will You Accomplish?

• Design, build, and maintain: Develop and deploy highly performant, reliable, and user-friendly dashboards using Dash and Cloud Run. This includes everything from initial design and development through testing, deployment, and ongoing 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 dashboard performance for maximum efficiency.
  
• Monitoring & Troubleshooting: Implement robust monitoring, testing, and alerting for cloud-based applications. Proactively identify and resolve issues, ensuring data quality and dashboard uptime.
  
• Collaboration & Communication: Work closely with other engineers, data scientists, and product teams to understand business requirements and translate them into technical solutions. Clearly communicate technical details and project progress.
  
• Continuous Improvement: Contribute to the ongoing improvement of our data infrastructure and processes, including suggesting and implementing new technologies and best practices. We're always looking for ways to optimize our workflows and improve efficiency.
  
• Other Duties as assigned

Requirements

• Proficiency in Python and SQL.
• Proven experience (2+ years) building and maintaining data applications using Dash. 
• Strong understanding of data warehousing principles and experience working with BigQuery.
• Understanding of data modeling concepts and best practices.
• Familiarity with Google Cloud Platform (GCP) services, specifically BigQuery, Cloud Run, and Cloud Functions. Experience with other GCP services is a plus.
• Experience with version control systems (Git).
• Excellent problem-solving skills and a proactive approach to identifying and resolving issues.
• Good communication and collaboration skills – you'll be working closely with other engineers and stakeholders.
• Bonus points for experience with CI/CD pipelines, Docker, Apache Airflow, and/or Apache Beam.

Benefits

• This is a rare opportunity to influence positive change within one of the biggest societal challenges of our generation: sustainable public infrastructure

• You get to support a disruptive solution with a compelling value proposition into an industry that is eager to hear from you and in a market with no direct competition.
• We live at the cross section of infrastructure, scaleup and data science/AI. There is no other team like us in Toronto.
• There is no corporate bureaucracy here. You will accomplish more here in a few months than what you would in a few years at a large, entrenched technology company.
• We believe that Data and AI will play an outsized role in our future, so we equip every team member with access to Generative AI tools and our full Data Universe to enhance their productivity and encourage innovation through experimentation.
• We are proud to offer every CityZen an internal mentorship program, in-role professional growth, skill-based development & learning, and internal promotion opportunities.
• We work hard, we play together, we win as a team! We are on a mission to solve infrastructure while savoring the moment and celebrating the little details along the way.