Data Warehouse Architect

We have an urgent opportunity for a Data Warehouse Architect to support a government data analytics program. Please check and revert if interested.

Position: Data Warehouse Architect
Location: Remote (Consultant must work onsite in Albany, NY for approximately one week per year if required)
Type : Contract

Key Responsibilities

• 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 the client’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:

1.    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;
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 transactions;
3.    a minimum of four years of experience working with ETL tools (e.g., Qlik and Informatica); 
4.    a minimum of four years of experience performing 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 coding in Structured Query Language (“SQL”).

PREFERRED QUALIFICATIONS

1.  Experience scripting in Python; 
2.  Experience in Tableau Server Administration;
3.  Experience working with customers in data validation, troubleshooting, or collecting business requirements.
4.  Two or more satisfactorily completed statistics courses from an accredited college or one or more year of professional experience using statistics;

5. Experience performing database development using SQL or Procedural Language/Structured Query Language (“PL/SQL”);
6. Experience developing a data analytics ETL environment to support Tableau visualizations; and 
7.  Experience using ETL techniques to support a data analytics program for a government entity.