The Center for Government Excellence is seeking a Data Engineer who will help create and maintain complex data pipelines from raw acquisition of data to visualization. This main responsibilities of this role will include the design, production, and maintenance of software infrastructure to automatically extract, transform, and load data from diverse sources, input/output data from databases and realize complex queries, 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. They will also contribute to explore and analyze data to answer policy-related questions that are crucially needed by local governments. The Data Engineer must be someone with experience developing software for data processing, with knowledge of data analytics, exceptional organizational skills and attention to detail, intellectually curious, and with commitment to unlocking the value of data for the public good.
This position will work in support across all the portfolio of data projects carried out by the GovEx Analytics Team, and in collaboration with Civic Impact's analysts, data scientists, researchers, data visualization analysts, database managers, program manager, and other external collaborators and partners. They will report to the Center for Government Excellence Program Officer.
Specific Duties & Responsibilities:
Data Engineering (50%)
Support the design, production, and maintenance ofdata 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 & 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 Civic Impact's leadership, and others on the team
Collaborate with external partners, contractors, and vendors
Minimum Qualifications (Mandatory):
Four years of related experience in a professional environment where the required knowledge base and skills have been utilized, and a minimum of 2 years of data analytics
Additional education may substitute for experience and additional experience may be substituted for education, to the extent permitted by the JHU equivalency formula*
* JHU Equivalency Formula: 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for the required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job.
** Applicants who do not meet the posted requirements but are completing their final academic semester/quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date.
Bachelors' Degree in Computer Science, Information Systems, Engineering, or quantitative discipline
Experience developing and managing ETL/ELT processes
Experience in Workflow orchestration tools such as Airflow
Experience designing and deploying data warehouse systems
Experience using project management and collaboration software such as Asana and Slack
Experience with version control software (GitHub)
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 container management frameworks such as Docker, Kubernetes
Familiarity with public sector data and policies
Classified Title: Sr. Business Intelligence Analyst Working Title: Data Engineer, GovEx Role/Level/Range: ATP/04/PD Starting Salary Range: $59,870 - $80,000, Commensurate with Experience Employee group: Full Time Schedule: 5/37.5 Exempt Status: Exempt Location: 01-MD:Homewood Campus Department name: 60006654-KSAS - Centers for Civic Impact Personnel area: School of Arts & Sciences
The successful candidate(s) for this position will be subject to a pre-employment background check.
If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the Talent Acquisition Office at [email protected]. For TTY users, call via Maryland Relay or dial 711.
The following additional provisions may apply, depending on campus. Your recruiter will advise accordingly.
The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing. Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers. Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.
Note: Job Postings are updated daily and remain online until filled.
Equal Opportunity Employer
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Johns Hopkins University remains committed to its founding principle, that education for all students should be grounded in exploration and discovery. Hopkins students are challenged not just to learn but also to advance learning itself. Critical thinking, problem solving, creativity, and entrepreneurship are all encouraged and nourished in this unique educational environment. After more than 130 years, Johns Hopkins remains a world leader in both teaching and research. Faculty members and their research colleagues at the university's Applied Physics Laboratory have each year since 1979 won Johns Hopkins more federal research and development funding than any other university. The university has nine academic divisions and campuses throughout the Baltimore-Washington area. The Krieger School of Arts and Sciences, the Whiting School of Engineering, the School of Education and the Carey Business School are based at the Homewood campus in northern Baltimore. The schools of Medicine, Public Health, and Nursing share a campus in east Baltimore with The Johns Hopkins Hospital. The Peabody Institute, a leading professional school of music, is located on Mount Vernon Place in downtown Bal...timore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.