Data Engineer (NCS) - Mayors Office of Performance and Innovation at City of Baltimore
Interview Preparation Plan
The City of Baltimore's Mayor's Office of Performance and Innovation (OPI) is seeking a mission-driven Senior Data Engineer and Architect to design and develop the city's next-generation data infrastructure. This role involves co-developing a centralized, enterprise-wide data warehouse and building secure, reliable, and scalable data pipelines. The position offers a high-impact opportunity to influence data architecture, orchestration, tooling, and governance, utilizing technical skills for public good. As a core contributor, you will work across city agencies to strengthen service delivery, build modern data and digital capabilities, and promote transparency. OPI uses data and design to improve services in ways that residents and staff can see and feel. This role supports ad hoc data curation, visualization, and statistical needs by translating business questions into technical solutions, making it ideal for someone passionate about contributing to public service.
Key Responsibilities
- Design, build, and maintain ETL/ELT pipelines using Python, PostgreSQL, and modern orchestration frameworks.
- Automate data ingestion from multiple sources (APIs, flat files, databases) into centralized data models.
- Develop comprehensive data models and Lakehouse-style tiered layers.
Ready to Ace Your Interview?
Sign up for free to practice with AI-powered mock interviews tailored to this role and company.