ETL Developer/Data Warehouse Architect (Hybrid Role)

About this Position:

Job Title: ETL Developer/Data Warehouse Architect

Tasks include:

• Reviewing and analyzing existing data analytics ETL processes as well as external sources in order to design and architect a system communicating this information to Division staff and other staff as necessary.

• Assisting with the implementation of data analytics architecture design to accept structured and unstructured datasets as they are acquired through the Division.

• 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 dashboard design as defined by user story business requirements.

• Assisting with ETL processes of newly identified/acquired data into client's secure data analytics environment.

• Providing other data analytics development services as requested.

MINIMUM QUALIFICATIONS:

• A Bachelor of Science Degree, or equivalent four-year degree, in computer science or related information technology field.

• A Masters 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.

• A minimum of four years of experience with Structured Query Language ("SQL").

PREFERRED QUALIFICATIONS:

• Experience scripting in Python.

• One year of 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 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.