City of Boston

Welcome page

Data Engineer

Req ID
2024-26579
Dept
Dpt of Innovation & Technology
Position
Regular Full-Time
Location
ASD-Mgmt Information Systems
Salary Min
77,085.65
Salary Max
114,228.89
Union
SE1
Openings
1
Posting End Date
8/28/2024
Contact Email
estelle.tshitenge@boston.gov

Overview:

 

Brief Job Description (essential functions of the job):

The Department of Innovation and Technology is looking for a Data Engineer to join our growing Analytics Team. As part of a highly-collaborative group using data to improve all aspects of city government, the Data Engineer will work on expanding our data infrastructure, developing ETL pipelines and open datasets, and connecting our analysts and data scientists to the data they need. Successful candidates will be able to work closely with other technical staff, project managers, and external partners across City government. They will have a strong understanding of data engineering principles and processes and be able to work on a wide range of projects and with a variety of tools.

Responsibilities:

  • Sets up automated extract, transforms, and loads (ETL) workflows.
  • Works closely with other members of the team to support their data needs and assist users in interacting with and connecting to databases. 
  • Designs and maintains data warehouse/reporting schemas and migrate pipelines from legacy systems to the team’s new data warehouse.
  • Independently researches and implements new tools and techniques to develop ETL pipelines.
  • Analyzes existing code and make suggestions for optimizing and migrating existing processes.
  • Writes scripts to automate manual processes, improve existing ones, and troubleshoot problems as they occur.
  • Works closely with data analysts and other staff to build data integrations that quickly and effectively solve reporting needs.
  • Performs related work as required.

Minimum Entrance Qualifications:

  • Applicant must have at least three (3) years of full-time, or equivalent part-time, experience using databases to manage and process datasets for reporting and analytics as part of a large organization.
  • A bachelor's degree in computer science, mathematics, engineering, or another STEM field is preferred and may be substituted for two (2) years of the required experience.
  • Strong analytical, problem solving, and communication skills, including mapping of business needs or issues to technical solutions.
  • Demonstrated ability to communicate technical nuances in plain language with partners of varying technical background.
  • Excellent problem solving and critical thinking skills and experience troubleshooting and debugging software and hardware issues.
  • Advanced SQL query and data transformation skills, preferably using PostgreSQL and/or Transactional SQL (T-SQL).
  • Familiarity with PostGIS preferred.
  • Experience with the Civis Analytics platform preferred.
  • Experience with lightweight scripting languages such as Python or Bash, version control using Git, and using Linux operating systems.
  • Familiarity with managing and supporting automated ETL and data synchronization.
  • Familiarity with Amazon Web Services cloud computing ecosystem.
  • Experience in the public sector (especially local government) desirable but not required.
  • Must be able to exercise good judgment and focus on detail as required by the job.

 

BOSTON RESIDENCY REQUIRED.

 

Terms:

Union/Salary Plan/Grade: SENA/MM1-8

Hours per week: 35

Options:

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed



The City of Boston is proud to be an Equal Opportunity Employer. We are committed to creating a diverse and inclusive environment. Therefore, qualified applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical or mental disability, genetic information, marital status, sexual orientation, gender identity, gender expression, military and veteran status, or other protected category.

The City of Boston has played a role in causing and perpetuating the inequities in our society. To break down these barriers, we are embedding equity and inclusion into everything we do.

We define equity as ensuring every community has the resources it needs to thrive in Boston. This requires the active process of meeting individuals where they are. Inclusion is engaging every resident to build a more welcoming and supportive city. We are building a city for everyone, where diversity makes us a more empowered collective.