Data Engineer

About Citylitics

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 market & opportunity 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.

What are we looking for?

We are looking for a Data Engineer with an ownership mindset where they can take a challenging data problem all the way through to an elegant tech solution that is robust and scalable. Someone who prides themselves on not only writing efficient code, but also in creating intuitive dashboards and data flows with clear and easy to read documentation.

What will you accomplish?

• Design and implement scalable data pipelines that power our products and all the market insights that our customers love
• Spearhead the development of end-to-end data management and customer-facing dashboards. Observe and foster best practices in business process design, implementation, and review.
• Integrate (ingest, model, load, transform) data from external, heterogeneous sources and combine them with internal data to produce insights
• Automate internal data processes and tooling
• Developing Python code to facilitate the integration of additional data sources
• Collaborating in cross-functional software/architecture design sessions to find the best data sessions for the problems that we are facing
• Develop and maintain our data warehouse ETLs and automated report scheduling system
• Create reports and data pipelines for stakeholders across the organization from multiple sources
• Manage and launch new data pipelines, dashboards and machine learning models to accelerate our data strategy and roadmap
• Other duties as assigned
  

• Backend: Python, Django and MySQL as the main language, framework and database
• Cloud Infrastructure: Google Cloud Platform and Docker
• Frontend: Javascript, React as the main language and framework
• Other Tools: Apache Airflow/Cloud Composer

Requirements

• 2+ years experience with Python and Django, with a focus on Django migrations
• 2+ years experience with database design and development using MySQL/NoSQL
• 1+ year experience with Google Cloud Platform, Docker
• Experience with Apache Airflow/Cloud Composer is an asset

Benefits

• This is a rare opportunity to influence positive change within one of the biggest societal challenges of our generation (infrastructure - from water to transport to energy and more).
• Be a part of a scale up company with 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.
• Comprehensive health and dental benefits with an emphasis on mental health
• Annual Learning and Development Budget and Plans
• Flexible hours and work-from-wherever you are with the option to work in our downtown office if interested!
• Competitive salary and equity incentives to give you a stake in our future
• We work hard. We play hard. From virtual trivia to exploring the food scene around our office, we like to get together!