Data Engineer, GovEx

Why Join GovEx?

Working at GovEx means joining a dynamic team committed to improving the lives of people living in cities around the world through data-driven, innovative solutions. You’ll have the opportunity to collaborate with cities at the forefront of public sector innovation and be part of transformative projects that improve government performance and outcomes.

The Bloomberg Center for Government Excellence at Johns Hopkins University (GovEx or the Center) seeks to hire a Data Engineer, GovEx to join our team of government, data, and performance practice experts to support senior government leaders across the United States, Canada, and Latin America to use data to get better results for residents.

The Data Engineer plays a critical role in our organization to help create and maintain complex data pipelines from raw acquisition of data to visualization.

Your main responsibilities will include the design, production, and maintenance of software infrastructure to automatically extract, transform, and load data from diverse sources. You will input/output data from databases and realize complex queries. You will be responsible for the creation of scripts for data manipulation, cleaning, filtering, and preparation of data outputs to be used for data visualization or web display. This will also include creating systems to monitor and guarantee data quality, perform daily data quality assurance tasks, maintain, and troubleshoot the infrastructure, and audit data sources. You will also contribute to exploring and analyzing data to answer policy-related questions that are crucially needed by local governments.

You will work in support across all the portfolio of data projects carried out by the GovEx Analytics Team. You’ll also work closely with GovEx’s analysts, data scientists, researchers, data visualization analysts, database managers, program managers, and other external collaborators and partners.

Since 2015, GovEx has supported over 10,000 public sector leaders in 37 countries, and over 568 cities, counties, and states by providing coaching and technical assistance; research and analytics; training and capacity building; and human resource support. GovEx is a recognized leader in the provision of public sector training to upskill employees and improve data practices through self-guided courses and instructor-facilitated learning.

GovEx is dedicated to supporting governments in leveraging the power of data to identify, understand, and dismantle legacies of structural and entrenched racism. We seek candidates who are committed to using data-driven approaches to promote equity and justice in communities. For more information about GovEx, please visit https://govex.jhu.edu/.

Specific Duties and Responsibilities

Data engineering (50%)

• Support the design, production, and maintenance of data pipelines for data acquisition, management, and transformation, and back-end code development to power data web applications and convert raw data into usable information.
• Write and maintain ETL/ELTs that operate on a variety of structured and unstructured sources.
• Develop and maintain web data scraping systems for automatic data acquisition.
• Help design data architecture and provide ongoing support.
• Input/output data from databases and perform queries.
• Create scripts to clean, transform, and analyze data.
• Put into production data pipelines using data warehousing systems.

Data quality assurance (25%)

• Create and implement into production software to monitor data quality and detect data anomalies.
• Perform daily manual data quality assurance tasks.
• Support, maintain, and troubleshoot the software infrastructure.

Data analysis and visualization (15%)

• Source data, conduct analyses, visualize data, and generate insights to support ongoing research projects and other requests across the organization.

Other duties (10%)

• Collaborate with developers, analysts, data scientists, researchers, policy experts, and other partners.
• Communicate with GovEx's leadership, and others on the team.
• Collaborate with external partners, contractors, and vendors.

Special Knowledge, Skills, & Abilities

• Expertise programming in Python for data acquisition, processing and analysis.
• Expertise with SQL and relational databases.
• Excellent attention to detail and organizational skills.
• Capacity to work independently.
• Commitment to a collegial workplace.
• At least two years’ experience developing python scripts, with object-oriented programming, for data processing and analysis.
• Knowledge of statistics, data analysis, and data quality standards.
• Knowledge of data scraping techniques
• Familiarity with public sector data and policies.

• Bachelor’s Degree required.
• Five years of related work experience focused within database management and design and business requirement gathering.
• Additional experience may be substituted for education.

• Familiarity with SQL (PostgreSQL preferred).
• Familiarity with open-source tools like Airflow, Kafka, Spark, or TinkerPop.
• Experience with cloud services like AWS, Azure, or Google Cloud..
• Strong analytical skills with the ability to collect, organize, and monitor large amounts of information with attention to detail and accuracy.

Classified Title: Data Engineer 
Job Posting Title (Working Title): Data Engineer, GovEx   
Role/Level/Range: ATP/04/PG  
Starting Salary Range: $99,800 - $175,000 Annually (Commensurate w/exp.) 
Employee group: Full Time 
Schedule: Monday - Friday 8:30am-5pm 
FLSA Status: Exempt 
Location: Hybrid/Homewood Campus 
Department name: ​​​​​​​Ctrs for Govt Excellence & Public Innova  
Personnel area: Academic and Business Centers