Associate Director, Data Management
Reporting to the Director, Data & Analytics, the Associate Director is a member of the Data & Analytics Management Team within the department of Data Strategy & Innovation (DS&I). DS&I is dedicated to housing, managing, analyzing and disseminating information and data to inform Advancement Office strategy; foster strong relationships with donors, volunteers and campus partners; and promote effective integration.
The Associate Director manages a Data Systems Engineer, and performs a variety of tasks to deliver technology improvements to the Data Warehouse environment. The specific responsibilities of this position include developing and testing extraction, transformation, and load (ETL) processes; defining and capturing metadata and rules associated with ETL processes; adapting ETL processes to accommodate changes in source systems and new business user requirements; working with both technical staff and business constituents to translate business requirements into technical solutions; maintaining technical and user documentation.
This is a hybrid role.
Responsibilities
Data Warehouse Development and Strategy:
- Lead the design, implementation, and ongoing enhancement of the Advancement Data Warehouse platform.
- Develop and maintain conceptual, logical, and physical data models supporting reporting, analytics, and operational intelligence.
- Design and oversee ELT pipelines that ingest and transform data.
- Establish standards for data modeling, business rules implementation, and warehouse development practices.
- Lead development of curated reporting and analytic data structures that balance usability, performance, and long-term maintainability.
- Maintain technical documentation, source-to-target mappings, and data lineage associated with warehouse assets.
Cross-Team And Departmental Collaboration
- Partner with reporting analysts and business stakeholders to translate information needs into scalable warehouse solutions.
- Serve as the primary technical authority on Advancement reporting data structures and warehouse design.
- Collaborate with ana...
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis.