Preferably local to NY
Position: ETL Developer/Data Warehouse Architect Location: Remote - (Albany, NY Travel 1 Week/Year) Duration: Long Term Contract
Job Description:
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. The proposed candidate must have:
Either a) a bachelor of science degree, or equivalent four-year degree, in computer science or related information technology field or b) a masters or doctorate in computer science or related information technology field;
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 transactions;
A minimum of four years of experience working with ETL tools (e.g., Qlik and Informatica);
A minimum of four years of experience performing 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 coding in Structured Query Language ( SQL ).
Preferred Qualifications: OSC will give preference to candidates with the following qualifications:
Experience scripting in Python;
Experience in Tableau Server Administration;
Experience working with customers in data validation, troubleshooting, or collecting business requirements;
Two or more satisfactorily completed statistics courses from an accredited college or one or more year of professional experience using statistics;
Experience performing database development using SQL or Procedural Language/Structured Query Language ( PL/SQL );
Experience developing a data analytics ETL environment to support Tableau visualizations
Experience using ETL techniques to support a data analytics program for a government entity.
Thanks & Regards
Mahesh