ETL Developer / Data Warehouse Architect
Role details
Job location
Tech stack
Job description
We are seeking an ETL Developer/Data Warehouse Architect who will support our NYS client with an ongoing data analytics initiative. This role will be responsible for assisting 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., * Review and analyze existing data analytics ETL processes as well as external sources in order to design and architect a system communicating this information to staff as necessary
- Assist with the implementation of data analytics architecture design to accept structured and unstructured datasets as they are acquired through the Division
- Assist with the implementation and migration of ETL environments, including fact and dimensional models as defined through user story business requirements
- Assist in Tableau/Oracle Business Intelligence Enterprise Edition ("OBIEE") dashboard design as defined by user story business requirements
- Assist with ETL processes of newly identified/acquired data into secure data analytics environment
- Provide other data analytics development services as requested, Cloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; consistency, efficiency, and thoroughness. All hiring decisions are ultimately made by our human recruiting professionals.
How AI Is Used Our AI tools assist by:
- Analyzing resumes against job requirements
- Supporting our recruiters in candidate data evaluation
- Ensuring consistent review standards across all applications
Important: AI serves as a support tool only. As noted above, all candidate selection and hiring decisions are made by experienced human recruiters. Your unedited resume will be processed by our AI tools as part of this evaluation.
Requirements
- Bachelor of science degree or higher in computer science or related information technology field
- 4+ 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
- 4+ years of experience working with ETL tools (e.g., Qlik and Informatica)
- 4+ years of experience performing data modeling
- 4+ years of experience developing a data analytics ETL environment to support data analytics
- 4+ years of experience coding in Structured Query Language ("SQL"), * Experience scripting in Python;
- 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 1+ 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
Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race,?color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws.
Benefits & conditions
This is an exempt position. Salary commensurate with experience
