IMPORTANT NOTE:
CANDIDATES WITH A PERMANENT COMPUTER SYSTEMS MANAGER OR COMPARABLE CIVIL SERVICE TITLE WITH SIMILAR DUTIES/RESPONSIBILITES ARE ENCOURAGED TO APPLY. PLEASE INCLUDE YOUR EMPLOYEE IDENTIFICATION NUMBER (EIN) WHEN APPLYING AND INDICATE IN YOUR COVER LETTER YOUR PERMANENT CIVIL SERVICE TITLE.

NYC Department of Finance (DOF) is responsible for administering the tax revenue laws of the city fairly, efficiently, and transparently to instill public confidence and encourage compliance while providing exceptional customer service.

The Finance Information Technology (FIT) Division designs, builds, and supports all facets of DOF’s computer systems, including hardware, software, applications, infrastructure, telephone, and data security. FIT delivers and administers tax-related payment programs for the City of New York by providing the information technology solutions needed to achieve its mission of collecting revenue while ensuring an efficient and improved customer experience. FIT is also responsible for the systems and websites which enable citywide payments, land records, property assessment, parking adjudications, customer service, and the Sheriff’s public safety work.

FIT is currently seeking a Data Warehouse ETL Developer for the Finance Data Integration Team (FinDIT). In this role, the candidate will be directly involved in the software development life cycle for complex Finance Data Warehouse (FDW) and Finance Data Lake (FDL) projects at an agency-wide level. The Data Warehouse ETL Developer will be responsible for Requirements Gathering, Analysis, Design, Development, Testing, Implementation and Support. The selected candidate will collaborate with peers, users, business analysts and business intelligence developers to ensure the success of those projects. Additional responsibilities include but is not limited to:

- Analyzing business requirements and assisting in translating these requirements into technical requirements (i.e. Workday data mappings).
- Designing robust, automated solutions to satisfy the business requirements using best practices.
- Developing solutions for these deliverables using IBM DataStage, SQL, KSH and other technologies.
- Testing solutions to ensure that business requirements are met and achieve the desired outcome.
- Implementing software changes to other environments and providing documentation for users if necessary.
- Supporting the FDW and FDL (outside of working hours if needed) by addressing job failures and issues raised by the users or FIT personnel.
- Collaborating and communicating with users, business analysts and business intelligence developers to ensure the success of the project. For example, this candidate may be involved in integrating data for the Workday application.
- Providing status and updates to management as required.

1. A master's degree in computer science from an accredited college or university and three (3) years of progressively more responsible, full-time, satisfactory experience in Information Technology (IT) including applications development, systems development, data communications and networking, database administration, data processing, or user services. At least eighteen (18) months of this experience must have been in an administrative, managerial or executive capacity in the areas of applications development, systems development, data communications and networking, database administration, data processing or in the supervision of staff performing these duties; or

2. A baccalaureate degree from an accredited college or university and four (4) years of progressively more responsible, full-time, satisfactory experience as described in "1" above; or

3. A four-year high school diploma or its educational equivalent, and six (6) years of progressively more responsible, full-time, satisfactory experience as described in "1" above; or

4. A satisfactory combination of education and experience equivalent to "1", "2" or "3" above. However, all candidates must have at least a four-year high school diploma or its educational equivalent and must possess at least three (3) years of experience as described in "1" above, including the eighteen (18) months of administrative, managerial, executive or supervisory experience as described in "1" above.

In the absence of a baccalaureate degree, undergraduate credits may be substituted for a maximum of two (2) years of the required experience in IT on the basis of 30 semester credits for six (6) months of the required experience. Graduate credits in computer science may be substituted for a maximum of one (1) year of the required experience in IT on the basis of 30 graduate semester credits in computer science for one (1) year of the required IT experience. However, undergraduate and/or graduate credits may not be substituted for the eighteen (18) months of experience in an administrative, managerial, executive, or supervisory capacity as described in "1" above.

- A strong background in data warehousing and SQL (Required). - Seven or more years of experience with IBM InfoSphere DataStage 11.x and higher. Experience with SSIS is a plus. - Seven or more years of experience with data warehousing, data marts, data lakes, dimensional modeling and design is required. - Strong SQL experience in a major database (i.e. Oracle, DB2, SQL Server) required (Oracle is preferred). - Experience with ETL and Database performance tuning techniques. - Experience with Database Tools such as SQL Developer, SSMS, AQT or DBArtisan. - Excellent collaboration and communications (oral and written) skills are required. - Experience in Korn and UNIX shell scripting on AIX, LINUX or UNIX. Windows scripting is a plus. - Experience with Microsoft Office tools (Word, Excel, PowerPoint, Visio, etc.). - Experience with the Workday application and the Workday data integration process is a plus. - Knowledge of Tivoli Workload Scheduler is a plus. - Experience working with the various business units within Finance is a plus.

This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

New York City Residency is not required for this position

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.