You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
Early Window: Closes in
Company hidden

Data Engineer

  • Office

Salary

Not stated

Similar roles pay $115K - 205K a year · our estimate

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

The agency keeps New York City healthy, safe, and clean by collecting and recycling waste, cleaning city streets and vacant lots, and clearing snow and ice.

The agency clears litter, snow, and ice from about 6,500 miles of city streets, removes debris from vacant lots, and takes abandoned vehicles off the streets.

The role supports the Operations Management Division with reporting, analytics, and operational projects. You will design, build, improve, document, and maintain database systems, data integration solutions, custom applications, and related software.

You will be a Data Engineer working on complex data engineering, integration, and analysis across several platforms in one enterprise environment.

Responsibilities

  • Carry out data analysis, profiling, modeling, source-to-target mapping, and reporting for enterprise data and analytics projects.
  • Build and maintain conceptual, logical, and physical data models that meet current and future operational, analytical, and reporting needs.
  • Review legacy and current source systems for data quality problems, inconsistencies, and gaps in integrity, and recommend fixes that strengthen governance.
  • Work with business stakeholders, technical teams, and external partners to design, build, and support complex integration pipelines in tools such as Databricks, Informatica PowerCenter, Pentaho Data Integration (Kettle), and similar technologies.
  • Write and update technical documents, including data models, data dictionaries, source-to-target mappings, ETL specifications, process flows, and reporting materials.
  • Build and maintain SQL-based solutions, such as complex queries, stored procedures, database objects, and transformation processes.
  • Create reports, dashboards, and analytics tools in platforms such as OBIEE, Power BI, and other enterprise reporting tools to support business intelligence work.
  • Help design and implement data architecture and integration strategies that improve data sharing and interoperability across business areas in the agency and with other city agencies.
  • Support and maintain internal IT systems, applications, and databases, keeping them reliable, performant, and aligned with agency standards.

Requirements

  • Strong SQL and Python skills.
  • Experience with data modeling, data analysis, ETL development, and database design.
  • Experience with enterprise reporting and analytics platforms such as Power BI, OBIEE, Tableau, or similar tools.
  • Knowledge of modern data platforms and cloud analytics environments.
  • Bachelor's degree from an accredited college in computer science, engineering, or a related field, plus 4 years of satisfactory full-time experience in datacenter engineering and operations, cloud engineering and operations, or complex IT infrastructure engineering; or
  • Bachelor's degree from an accredited college plus 8 years of satisfactory full-time experience in datacenter engineering and operations, cloud engineering and operations, or complex IT infrastructure engineering; or
  • Education and/or experience equivalent to option 1 or option 2 above.
  • Strong analytical and problem-solving skills, clear communication, and the ability to work well with others.

Conditions

Works under general supervision, with considerable latitude to use independent judgment and initiative.

The city is an equal opportunity employer that works to keep the workplace free from discrimination and harassment based on any legally protected status or characteristic.

Where you’d work

From the office

The office

About the company

Company hidden

Office in New York City, United States

Your chances

Mixed signs it's still hiring, not crowded yet, and you'd be among the first.

  • 15 checks run
  • 5 good signs
  • 2 red flags

Still hiring?

10 checks

Mixed signals

In its favour2

  • Still on the company's own careers site, checked 1 h agoModerate evidence
  • Found in the last 48 hours, before the big job boardsModerate evidence

Against it2

  • Listed again after an earlier listing of the same role closedModerate evidence
  • No salary stated, though New York asks most employers to post oneModerate evidence

How crowded?

5 checks

Low

In its favour3

  • In its Early Window: not on the big job boards yetStrong evidence
  • In the office in New York City: only people nearby can take itSlight evidence
  • Asks for Tableau, which only 1% of open roles doSlight evidence

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details9 facts · Role, Location, Compensation, Employment
Tech stack
  • Python
  • SQL
  • Tableau
  • Spark
  • Databricks
  • Power BI
Type
Full-time
Specialty
Data Engineering
Region
United States
Pay period
Annual
Show 4 more factsShow less

Role

Category
Data & Analytics
Specialty
Data Engineering
Tech stack
  • Python
  • SQL
  • Tableau
  • Spark
  • Databricks
  • Power BI

Location

Work model
Office
Region
United States
Office
  • New York City, United States

Compensation

Salary
Salary by agreement
Pay period
Annual

Employment

Type
Full-time

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason