**Applicants MUST submit a cover letter with resume to be considered.
This position will require in-office presence.
Hybrid work schedules may be possible based on specific job duties and consistent with ESD policy.*
BASIC FUNCTION:
Design and build Data Warehouse structures to support ESD’s reporting and analytic needs. Work closely with Data Architects to develop a thorough understanding of the organizations data needs, ensure that all data points are correctly identified and develop processes for capturing and storing this data. Duties will include: surveying existing business functionality, designing data warehousing structures, data mapping, data mining, transformation and loading, performance monitoring, end user support, system disaster recovery, Quality of Service (QoS) testing and documentation as well as to provide technical assistance in any other area of IT as directed by department managers.
WORK PERFORMED:
- Develop Data Warehouse structures conducive to sourcing reports and analytics
- Develop ETL (Extract, Transform, Load) processes for importing data into the warehouse
- Utilize industry best Data Mining techniques to analyze large datasets for discernable trends and patterns in support of organizational business process and goals
- Author functional specifications for Data Warehouse structures
- Aid in capturing and maintaining the organizations master data
- Document Data Warehouse designs, infrastructure, interfaces, processes, workflows and security requirements
- Provide Data Analysis, establish mapping and Ad Hoc reporting as required by application users and ESD Management
- Aid in maintaining the organizations master Data Dictionary
- Manage multiple projects concurrently, meet established guidelines
- Assist in IT Disaster Recovery efforts and perform other related duties as required