The New York State Office of the State Comptroller (“OSC”) intends to procure an Extract Transform Load (“ETL”) Developer/Data Warehouse Architect (“Consultant”) to assist with its ongoing data analytics initiative pursuant to its discretionary purchasing authority under State Finance Law § 163(6). This procurement opportunity is limited to businesses certified pursuant to Article 15-A of the New York State Executive Law and businesses certified pursuant to Article 17-B of the New York State Executive Law.

BACKGROUND

OSC has commenced a data analytics initiative to support OSC’s audit planning and analysis activities. The initiative increases recoveries from fraud, waste, and abuse using new protocols established under the Enterprise Fraud Prevention Act (Chapter 566) and increases operational efficiencies using performance analysis. One aspect of this initiative is the development of an analytics data warehouse based on a formally architected framework to build an environment for OSC examiners, auditors, and analytics staff to fully realize the benefits of business intelligence and data analytics tools. OSC requires the services of the Consultant to assist with these efforts.

STATEMENT OF WORK

The Consultant shall work with staff from the Data Analytics & First New York units within OSC’s Division of the Chief Information Officer (the “Division”) to assist with the build-out of the current OSC environment for both infrastructure and tools as they relate to data analytics and the necessary supporting technologies, such as data warehousing, business intelligence, statistical analysis, and data exchanges with external agencies/entities. Tasks include:

• Reviewing and analyzing existing data analytics ETL processes as well as external sources in order to design and architect a system communicating this information to Division staff and other OSC staff as necessary;
• Assisting with the implementation of data analytics architecture design to accept structured and unstructured datasets as they are acquired through the Division;
• Assisting with the implementation and migration of ETL environments, including fact and dimensional models as defined through user story business requirements;
• Assisting in Tableau/Oracle Business Intelligence Enterprise Edition (“OBIEE”) dashboard design as defined by user story business requirements;
• Assisting with ETL processes of newly identified/acquired data into OSC’s secure data analytics environment; and
• Providing other data analytics development services as requested.

MINIMUM QUALIFICATIONS

The Consultant must possess the following minimum qualifications:

1. A Bachelor of Science Degree, or equivalent four-year degree, in computer science or related information technology field. A Masters or Doctorate in computer science or related IT field may be used to satisfy this requirement;

2. A minimum of four years of experience developing and maintaining a data interchange system interfacing with a wide array of varying data sets including flat file, direct database connection, and eXtensible Markup Language (“XML”) transactions;

3. A minimum of four years of experience working with ETL tools;

4. A minimum of four years of experience data modeling;

5. A minimum of four years of experience developing a data analytics ETL environment to support data analytics; and

6. A minimum of four years of experience with Structured Query Language (“SQL”).

PREFERRED QUALIFICATIONS

OSC will give preference to candidates with the following qualifications:

1. Three years of experience using scripting languages such as Python;

2. One year of experience in Tableau Server Administration;

3. Two years of experience working with customers in data validation, troubleshooting, or collecting business requirements;

4. Two satisfactorily completed statistics courses from an accredited college or one year of professional experience using statistics;

5. Seven years of experience performing database development using SQL or Procedural Language/Structured Query Language (“PL/SQL”);

6. One year of experience developing a data analytics ETL environment to support Tableau visualizations; and

7. One year of experience using ETL techniques to support a data analytics program for a government entity.

ADDITIONAL INFORMATION

The Consultant shall:

• Work a 40-hour workweek during regular OSC business hours, between 8:00 a.m. and 5:00 p.m. ET Monday through Friday, excluding State holidays. While unlikely, Consultant may occasionally be required to work more than the regular 40-hour work week and/or outside regular business hours to support the completion of critical project objectives.
• Work remotely during the term of the Agreement. However, the Consultant must also be able to work on-site at 110 State Street in Albany, NY, as directed by OSC.
• Report directly to the manager of Data Analytics & First New York or their designee.

OSC will provide the Consultant with all necessary IT equipment.

SUBMISSION REQUIREMENTS

Interested vendors may submit no more than one candidate in response to this solicitation.

Interested vendors should submit a resume for the candidate and a completed and signed Candidate Submission Sheet (“CSS”) to RFP@osc.ny.gov (preferred) or via hard copy mail to:

Director of Finance

Office of the State Comptroller

110 State Street, Stop 13-2

Albany, NY 12236-0001

The CSS is a one-page document on which the vendor will provide the candidate’s name and hourly rate along with the contact information for the vendor.

The CSS and all other documents related to this procurement are available on the OSC website at: https://www.osc.state.ny.us/procurement .

The CSS and resume must be received by OSC no later than the deadline contained in this advertisement.

The resume should clearly demonstrate that the candidate submitted meets all minimum qualifications.

The proposed hourly rate must be inclusive of all labor, licenses, insurance, administration, overhead, travel, and any other applicable expenses required to meet the applicable project requirements.

During the qualification process, candidates will be interviewed via video conference. Telephone interviews will not be permitted.

The proposer must be willing to enter into an agreement substantially in accord with the terms of the Draft Contract posted to the OSC website should the proposer be selected for contract award.

NOTE: Procurement documents may, from time to time, be amended or addenda issued. It is the Proposer’s responsibility to become aware of any such amendments and/or addenda prior to submission of a response. All amendments and/or addenda to procurements will be posted to the OSC website at https://www.osc.state.ny.us/procurement .

Proposers should review the OSC website prior to submission of a response to ensure that they have all information required to submit a complete response.

This procurement is subject to, and shall be conducted in accordance with, the OSC Executive Order on Procurement Integrity and OSC’s Procurement Integrity Procedures, both of which are available in full on the OSC website noted above, or upon email request. All inquiries concerning this procurement must be addressed to the Contracting Officer or designee(s) at OSC, via email (preferred) to RFP@osc.ny.gov or via hard copy mail to:

Director of Finance

Questions for Contract #C001171

Office of the State Comptroller

110 State Street, Stop 13-2

Albany, NY 12236-0001

Questions regarding this procurement opportunity must be received by OSC by at 4:00 p.m. ET on 04/11/23. The comprehensive list of questions and responses will be posted to the OSC website on or about 04/25/23. This listing will not include the identities of the vendors submitting the questions; those vendors will remain anonymous to the extent allowed by law.