Job Description :
The Consultant shall work with the Data Analytics Bureau and the Division of the Chief Information Officer staff to assist with the build-out of the current 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, but are not limited to:

Reviewing and analyzing the existing data warehouse and new Data Analytics data warehouse environments and other external sources in order to design and architect a system communicating this information to Data Analytics Bureau staf;

Assisting with the implementation of Data Analytics architecture design to accept structured and unstructured datasets as they are acquired through the Data Analytics Bureau;

Assisting with the implementation and migration of Pentaho and Attunity ETL environments, including fact and dimensional models as defined through user story and use case development from business analysis teams;

Assisting in the design of Tableau/OBIEE dashboards and reporting as defined through user story and use case development from business analysis teams: and

Assisting with the extraction, transformation and loading of newly identified/acquired data into a secure Data Analytics environment.

The Consultant must possess the following minimum qualifications:

A computer science or information technology related Bachelor’s Degree (4-year degree);

Five 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 XML transactions;

Five years of experience working with ETL tools;

Five years of experience working with business intelligence and data visualization tools, such as OBIEE and Tableau;

Five years of experience with SQL and;

Three years of experience with technical user documentation for knowledge transfers.


Preference to candidates with the following qualifications:

Strong communication skills working with both technical and non-technical staff, including:

Strong presentation and verbal skills demonstrating the ability to communicate complex technical information to a non-technical audience,

Strong written skills with the ability to document technical designs,

Strong instructional skills for mentoring and knowledge transfer through
hands-on training; and

Experience working with Pentaho and Attunity ETL tools.