What are the responsibilities and job description for the ETL Developer/Data Warehouse Architect (Hybrid Role) position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Elegant Enterprise Wide Solutions, is seeking the following. Apply via Dice today!
About this Position:
Job Title: ETL Developer/Data Warehouse Architect
Tasks include:
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.
- 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").
- 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.