StateJobsNY

NY HELPNo

AgencyFinancial Services, Department of

TitleInformation Technology Specialist 3

Occupational CategoryI.T. Engineering, Sciences

Salary Grade23

Bargaining UnitPS&T - Professional, Scientific, and Technical (PEF)

Salary RangeFrom $79325 to $100342 Annually

Employment Type Full-Time

Appointment Type Permanent

Jurisdictional Class Competitive Class

Travel Percentage 0%

Workweek Mon-Fri

Hours Per Week 37.50

Workday

From 9 AM

To 5 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? Yes

Telecommuting allowed? Yes

County New York

Street Address One Commerce Plaza, Suite 301

City Albany

StateNY

Zip Code12257

Minimum Qualifications Appointment method:

List Appointment: Candidates must be reachable on the Civil Service eligible list for 26-376 or 37-675.

Transfer: Candidates must have one year of permanent competitive service in a title eligible for transfer via Sections 70.1 or 52.6 of the Civil Service Law. Information regarding transfer eligibility may be available on the Civil Service Career Mobility Office website at http://careermobilityoffice.cs.ny.gov/cmo/.

Please Note that under Civil Service Law, an employee cannot have two consecutive upward 70.1 or 52.6 transfers without an intervening eligible list appointment if such transfers would exceed two salary grades.

Duties Description The New York Department of Financial Services seeks to build an equitable, more transparent and resilient financial system that benefits New Yorkers and supports business. Through engagement, data-driven regulation, and operational excellence, DFS is responsible for empowering consumers and protecting them from financial harm; ensuring the health and stability of the financial entities we regulate; and driving economic growth through responsible innovation.

DFS is seeking to fill the position of Information Technology Specialist 3 to function as a Data Warehouse Engineer in our Information Technology Unit to be responsible for designing and implementing staging, operational data stores (ODS) and data warehouse environments using data from multiple sources through data normalization, de-normalization, flattening and enrichment for the development of the infrastructure of a data warehouse.

The incumbent will advise policy makers on issues related to databases implementation and provide expertise as to what data is needed to support policy decisions. The incumbent will be involved in confidential discussions about acquisition, publication and security of data related to DFS databases . Duties include, but are not limited to, the following:

• In consultation with policymakers, develops complex data transformations using extracting, transforming, and loading (ETL) approach for business intelligence (BI), data warehouse/data mart models;
• Manages Oracle/SQL server databases throughout the database development lifecycle, including planning, requirements gathering, design, implementation, testing & performance tuning, operation and maintenance;
• Performs ETL design, development, testing, and deployment activities; Imports, exports and moves data in different formats (such as, .cvs, .xml and .xlsx) between a variety of systems such as, relational databases, customer relationship management systems, 3rd party systems and application program interfaces;
• Designs and implements the architecture and infrastructure of enterprise systems;
• Maintains thorough understanding of the environment to ensure adherence to standards and utilizing accepted practices for enterprise design;
• Reviews current and proposed architectures to meet acceptable enterprise system practices;
• Provides technical advice and guidance for infrastructure improvements and deploying and maintaining systems in accordance with established guidelines;
• Implements enterprise information security, procedures and protocols and participating in security risk reviews and remediation activities including producing written technical reports;
• Participates in the testing of applications, such as developing test plans, test conditions, and validation testing; and
• Designs, develops, and maintains logical/physical data models, entity relationship diagrams and a common data dictionary.


?

Preferred Qualifications

• At least 5 years of experience with Data Warehouse ETL design, development and maintenance with successful implementation of Enterprise BI solutions;
• Hands-on experience implementing data migration and data processing using Azure services;
• Experience in working with relational database management system mainly SQL Server 2008/2012 and Oracle 12c;
• Strong technical experience in designing and implementing data-intensive Data Warehouse solutions;
• High proficiency writing SQL/ T-SQL;
• Strong Knowledge of logical and physical data modeling (relational, dimensional data modeling); and
• Experience with data visualization tools (e.g. PowerBI).

Some positions may require additional credentials or a background check to verify your identity.

Name Douglas Arthur

Telephone

Fax (518) 402-5071

Email Address Douglas.Arthur@dfs.ny.gov

Address

Street One Commerce Plaza, Suite 301

City Albany

State NY

Zip Code 12257

Notes on ApplyingTo Apply: Interested qualified candidates must submit a resume and letter of interest no later than July 1, 2022 to the email address listed below. Please include the Box # (Box ITS3-04117) in the subject line of your email to ensure receipt of your application. Email submissions are preferred.

Douglas Arthur
Box ITS3-04117
New York State Department of Financial Services
Office of Human Resources Management
One Commerce Plaza, Suite 301
Albany, NY 12257
Email: douglas.arthur@dfs.ny.gov
Fax: (518) 402-5071

Public Service Loan Forgiveness
Employment with New York State qualifies an individual for Public Service Loan Forgiveness (PSLF). This program forgives the remaining balance on any Direct Student Loans after you have made 120 qualifying monthly payments while working full-time for a U.S. federal, state, local, or tribal government or not-for-profit organization. To learn more about the program and whether you would qualify, please visit: https://studentaid.gov/manage-loans/forgiveness-cancellation/public-service

All candidates that apply may not be scheduled for an interview

AMERICANS WITH DISABILITIES ACT: REASONABLE ACCOMMODATIONS

Under the Americans with Disabilities Act (ADA), the Department of Financial Services is required to provide reasonable accommodation for known physical or mental limitations of an otherwise qualified applicant with a disability if an accommodation would enable the applicant to perform the essential functions of the job. If the accommodation would constitute an undue hardship on the operations of the agency, the agency is not required to provide it.

Pursuant to Executive Order 161, no State entity, as defined by the Executive Order, is permitted to ask, or mandate, in any form, that an applicant for employment provide his or her current compensation, or any prior compensation history, until such time as the applicant is extended a conditional offer of employment with compensation. If such information has been requested from you before such time, please contact the Office of Employee Relations at (518) 474-6988 or via email at info@oer.ny.gov.