Job ID: NY-ETL (90091205)4P
Tableau ETL Developer with OBIEE, data modeling/analytics, PL/SQL, AWS and BI/DW experience
Location: Albany NY (OSC)
Duration: 12 months
Positions: 1 (1/1)
MINIMUM QUALIFICATIONS
A Bachelor’s of Science Degree, or equivalent four-year degree, in Computer Science or related information technology field. A Master’s or Doctorate in Computer Science or related IT field may be used to satisfy this requirement;
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;
A minimum of four years of experience working with ETL tools;
A minimum of four years of experience data modeling;
A minimum of four years of experience developing a data analytics ETL environment to support data analytics; and
A minimum of four years of experience with Structured Query Language (“SQL”).
PREFFERRED QUALIFICATIONS
One year of experience accessing XML files from Amazon Web Services;
One year of experience in Tableau Server Administration;
Two years of experience working with customers in data validation, troubleshooting, or collecting business requirements;
Two satisfactorily completed statistics courses from an accredited college or one year of professional experience using statistics;
Seven years of experience performing database development using SQL or Procedural Language/Structured Query Language (“PL/SQL”); and
One year of experience developing a data analytics ETL environment to support Tableau visualizations.
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 through the use of 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 will work with the Data Analytics Bureau (the “Bureau”) and the Division of the Chief Information Officer staff 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 will include:
Reviewing and analyzing data analytics ETL environments and other external sources in order to design and architect a system communicating this information to Bureau 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 Bureau;
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.