ETL/DATAWARE HOUSE ARCHITECT

ETL/DATAWARE HOUSE ARCHITECT

Duration: 12 Months
Location: 100 % Remote

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

Responsibilities:

• Develop and maintain a data interchange system interfacing with flat file, direct database connection, and XML transactions.
• Work with ETL tools (e.g., Qlik and Informatica).
• Perform data modeling.
• Develop a data analytics ETL environment to support data analytics and Tableau visualizations.
• Code in Structured Query Language (SQL).
• Script in Python (preferred).
• Perform Tableau Server Administration (preferred).
• Work with customers in data validation, troubleshooting, and collecting business requirements (preferred).
• Perform database development using SQL or PL/SQL (preferred).
• Use ETL techniques to support a data analytics program for a government entity (preferred).

Required:

• Bachelor of Science degree (or equivalent four-year degree) in Computer Science or related IT field OR Master s/Doctorate in Computer Science or related IT field.
• Minimum four years of experience developing and maintaining a data interchange system interfacing with varying data sets (flat file, database connection, XML).
• Minimum four years of experience working with ETL tools (Qlik, Informatica).
• Minimum four years of experience performing data modeling.
• Minimum four years of experience developing a data analytics ETL environment.
• Minimum four years of experience coding in SQL.

Preferred:

• Experience scripting in Python.
• Experience in Tableau Server Administration.
• Experience working with customers in data validation, troubleshooting, and business requirement gathering.
• Two or more statistics courses from an accredited college OR one or more year of professional statistics experience.
• Experience performing database development using SQL or PL/SQL.
• Experience developing ETL environments supporting Tableau visualizations.
• Experience supporting a government entity data analytics program using ETL techniques.

Regards,

Vipin Tiwari
Direct No.:
Techridge Inc.