What are the responsibilities and job description for the ETL Developer/Data Warehouse Architect (Hybrid Role) position at Elegant Enterprise Wide Solutions?
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.