The ETL Developer will report directly to the IT Principal Engineer (Data Warehouse Architect) in the Decision Support Services (DSS) unit within the Division of Information Technology (DIT). This is an opportunity to join a newly formed unit (DSS) and contribute to a strategic initiative to improve data-driven decision-making on campus. The ETL Developer will be responsible for the design, implementation and maintenance of a new ETL process to support the creation of a new Enterprise Data Warehouse (EDW) and data platform. This includes using cloud-based technologies, establishing best practices and procedures for ETL development, implementing ETL processes, and documentation. The ETL Developer will collaborate with the DSS team on a day-to-day basis and receive technical guidance from the Data Warehouse Architect.

The emphasis of this position is the technical hands-on activities for the creation and evolution of a new ETL process. Of utmost importance is the ability to select and implement the appropriate ETL or ELT techniques and storing all data as structured files for subsequent usage in a data warehouse or Big Data analysis; prior successful ETL implementations and experience are essential, as is SQL experience. Clear communication, demonstrated organizational skills, and the ability to collaborate with non-technical stakeholders, create clear and concise technical documentation, and make critical decisions are requirements to be successful in this position.