Data Engineer, Citylitics
Public infrastructure sales insights
Be an early applicant
Public infrastructure sales insights
21-100 employees
Be an early applicant
21-100 employees
Company mission
To help vendors and AECs in Public Infrastructure increase sales efficiency by delivering market insights & sales intelligence that precisely match their business needs.
Role
Who you are
- If you're passionate about data engineering, thrive in a collaborative environment, and are excited by the prospect of working on impactful projects, we encourage you to apply
- Beyond the technical skills, we value collaboration, a proactive approach to problem-solving, and a willingness to learn and adapt to evolving technologies
- We're not looking for just someone who knows these tools, but someone who has built with them – ideally, complex and robust data pipelines in a production environment
- Proven experience (2+ years) building and maintaining data pipelines using Apache Airflow. We're particularly interested in seeing examples of complex pipeline orchestration
- Strong understanding of data warehousing principles and experience working with BigQuery
- Experience with cloud-based data processing frameworks like Apache Beam (ideally with Google Cloud Dataflow)
- Familiarity with Google Cloud Platform (GCP) services, specifically BigQuery, Dataflow, and Vertex AI. Experience with other GCP services is a plus
- Proficiency in at least one scripting language (Python preferred)
- 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
- Understanding of data modeling concepts and best practices
- Experience with CI/CD pipelines is a plus
What the job involves
- We're looking for a skilled and enthusiastic Data Engineer to join our growing team
- This role requires a solid understanding of and experience with Apache Airflow
- You'll be responsible for designing, building, and maintaining both streaming and batch data pipelines, leveraging various technologies we already use, including Google Cloud Platform (GCP) services like Dataflow, BigQuery, and Vertex AI
- Experience with these specific GCP services is a must
- Design, build, and maintain: Develop and deploy highly scalable and reliable data pipelines using Apache Airflow, Dataflow, and other GCP services
- 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 pipeline performance for maximum efficiency
- Monitoring & Troubleshooting: Implement robust monitoring and alerting for data pipelines
- Proactively identify and resolve issues, ensuring data quality and pipeline 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
- Backend: Python, Django, Cloud SQL and Airflow/Cloud Composer as the main language, web framework, database and orchestration tool respectively
- Cloud Infrastructure: Google Cloud Platform
- Other Tools: Dash & Plotly as the main framework for our dashboards hosted in Cloud Run
Application process
- We're interested in seeing examples of your work, so please be prepared to discuss past projects and challenges you've overcome
Our take
North American infrastructure is undergoing a major overhaul and modernization. The U.S. Infrastructure Bill and other significant funding have been approved, meaning that in the coming years, the US will likely be spending trillions on upgrading its infrastructure. Citylitics leverages predictive analysis data to automate and coordinate infrastructure upgrades.
Citylitics' technology allows developers a vastly increased level of infrastructure intelligence, saving time and money on upgrades while improving precision. As the first company of its kind, Citylitics has been able to secure an impressive amount of funding.
Citylitics has provided tailored reporting to businesses such as Suez, AgileAssets and Mueller. The company has invested in hiring in order to double its sales & marketing and engineering teams, which will be a critical step in its continued growth.
Freddie
Company Specialist at Welcome to the Jungle
Insights
Company
Funding (2 rounds)
Mar 2022
$5m
SERIES A
Mar 2021
$0.9m
SEED
Total funding: $5.9m
Company benefits
- Flex Time, All the Time: We believed in flexible hours and work from home days before it became the norm. We encourage a flow that works best for you
- Benefits and Perks: Our benefits cover everything from your trip to the dentist to massage therapy. We offer online learning, the right hardware to succeed, and time to hang out via yoga, donut chats, Gather, and more!
Company HQ
Wellington Place, Toronto, ON
Articles
Leadership
Ahmed Badruddin
(CEO)A former Microsoft Software Engineer who also co-founded Simpleafy, a Smart Grid software company. Was CEO of WatrHub for 9 years before joining Citylitics in 2021 as CEO.
Salary benchmarks
We don't have enough data yet to provide salary benchmarks for this role.
Submit your salary to help other candidates with crowdsourced salary estimates.
Share this job
View 3 more jobs at Citylitics