Special 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, provides support for all facets of DOF's computer systems, including hardware, software, applications, and data security. The FIT division delivers world-class information and technology solutions that DOF needs, in order to achieve results in collecting revenue for the City of New York.

FIT seeks 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. This includes but is not limited to: Requirements Gathering, Analysis, Design, Development, Testing, Implementation and Support. The developer will collaborate with peers, users, business analysts and business intelligence developers to ensure the success of those projects.

The core responsibilities of this individual will include:

• 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.

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.

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.

As a current or prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. Please review the notice to see if you may be eligible for programs and how to apply at nyc.gov/studentloans.

Click the "Apply Now" button.

While we appreciate every applicant's interest, only those under consideration will be contacted.

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.

Unless otherwise indicated, all positions require a five-day workweek.

59 Maiden Lane
(Current location but could be subject to change)

New York City Residency is not required for this position