The City of Baltimore is seeking a Senior Data Engineer and Architect to help design and develop Baltimore's next-generation data infrastructure, strengthening service delivery, building modern data and digital capabilities, and promoting transparency.
Requirements
- Proficiency in Python for data engineering (Pandas, Polars, SQLAlchemy, Object-relational mapping, requests)
- Strong SQL skills and experience working with PostgreSQL or other relational databases with an emphasis on geospatial data.
- Experience building and maintaining data pipelines (ETL/ELT) using modern tools
- Experience with data model and database design
- Understanding of cloud data workflows, APIs, and modern DevOps tools for CI/CD, logging, and monitoring
- Ability to work collaboratively on GitHub and contribute to shared codebases
- Ability to explain complex data structures to non-technical audiences
Responsibilities
- Develop data models, data Lakehouse-style tiered layers, orchestration frameworks that make sense for both efficient computation, fellow engineers, and data consumers.
- Develop, and maintain ETL/ELT pipelines using Python, PostgreSQL, and modern orchestration frameworks while implementing data quality, monitoring, alerting, and logging mechanisms to ensure pipeline reliability, performance, and transparency.
- Automate data ingestion from multiple data sources (e.g., APIs, flat files, databases) into centralized data models for reporting and analysis.
- Broadly supports ad hoc data curation, visualization, and statistical needs in City Hall.
- Translate business questions into technical solutions and data products that surface insights and guide action.
- Co-develop a centralized, enterprise-wide data warehouse and the secure, reliable, and scalable data pipelines that feed it.
- Influence data architecture, orchestration, tooling, and governance.
Other
- Bachelor’s degree in computer science, Data Science, Information Systems, or a related field from an accredited college or university.
- Five plus years of professional experience in data engineering or related technical role.
- Ability to work evening and weekend hours and 24-hour callback in an emergency.
- Must complete a mandatory six-month probation.
- Background Check: Eligible candidates under final consideration for appointment to positions identified as positions of trust will be required to complete authorization for a Criminal Background Check and/or Fingerprint must be successfully completed.
