ETL Developer

Within NYC Opportunity, the Enterprise Data Solutions team takes innovative approaches to integrate data across agencies to improve the delivery of social services, expand service outreach and inform public sector analytics and research. EDS views data as a valued asset that can be leveraged responsibly to increase equity and opportunity for all New Yorkers.

The ETL Developer will be part of the Integration Services of the EDS team, primarily responsible for providing timely and accurate data that enable data analytics and research that drive long-term policy and program development. Our back-end stack includes Oracle DB, IBM DataStage/QualityStage ETL and IBM Master Data Management.


  Responsibilities

  • Contribute to the design, implementation, support and ongoing enhancement of our data warehouse and data mart environments.
  • Develop appropriate load and transformation processes to ensure data is loaded correctly into data infrastructure(s).
  • Design processes to test, measure and ensure data quality.
  • Establish the long-term strategy and technical architecture for data warehousing efforts.
  • Define and implement technical requirements and data architectures for the data warehouse.
  • Create and maintain documentation of the physical and logical data models; data dictionaries; and ETL processes via process flow diagrams.
  • Design and manage the information access and security requirements for the data warehouse.
  • Define and implement production release requirements and sustainment architecture.
  • Produce high quality technical documentation.
  • Support the team directors and fellow team members as needed.
  • Other duties as assigned.

  Education and Experience

Bachelor's or Master's degree in information systems, technology or equivalent with 5+ years of work experience in as a lead developer or architect in Data warehouse design and development

If you're a recent graduate of a developer bootcamp, we recommend you check out our UI Development Fellow position.

This position may require applicants to take a civil service exam. To learn more about the civil service process, visit the NYC Department of Citywide Administrative Services

  Skills We're Seeking

Commitment to the mission of advancing greater equality and opportunity.

Proficient knowledge of most common relational databases including Oracle, Microsoft SQL Server, MySQL, MongoDB, CouchDB, etc.

Knowledge of Data Warehousing, dimensional data modeling and OLAP principles.

Ability to identify and diagnose database related issues, perform root cause analysis, and recommend corrective actions.

Ability to handle confidential and highly sensitive information in a professional manner.

Experience working with Data Stage and Quality Stage or IBM MDM is a plus.

Experience working with cloud computing integration such AWS, Azure

Excellent communication and presentation skills, both verbal and written.

Work experience in as a lead developer or architect in Data warehouse design and development

  How to Apply

Please fill out the application form. The form will prompt you to upload a resume and portfolio.

Applications are due on a rolling basis and successful candidates will be invited for an initial phone screen.

Due to the volume of applications received we may not be able to respond to every application.