Assistant Director, Data Warehouse & Integration

The Division of Information Technology (it.gwu.edu) is the chief provider of technology infrastructure, services and applications at GW. The Division partners with stakeholders across GW to equip students, staff and faculty with the technology know-how and tools necessary to achieve academic excellence. Reporting to the Director of Business Intelligence, the Assistant Director, Data Warehouse & Integration works primarily within the Division’s Business Intelligence Services Department as a critical member of the Data as a Service effort.

The Assistant Director, Data Warehouse & Integration is responsible for undertaking multiple engagements, working with different teams and business stakeholders, focusing on multiple aspects of strategic data architecture, data modeling, ETL, BI, and data integrations. The Assistant Director manages a team of Data Warehouse & Integration Architects that works with multiple business lines within the organization to define industry best practices and implement solutions architecture for the University Data Warehouse and enterprise data integrations. The Assistant Director, Data Warehouse & Integration is responsible for:

• Leading a team of Data Warehouse & Integration Architects and Sr. Data Warehouse & Integration Architects responsible for providing Data Warehouse Architecture, Data Integration Platform management and delivery & Business Intelligence support for the University. Acts as a team Product Owner, constructing and prioritizing team backlog. 

• Acts as a key point of contact for internal and external customers to identify, refine, and organize needs and priorities.

• Manages the architecture, business analysis, design, and implementation of the University’s data warehouse and integration platform initiatives. Works stakeholders to map business requirements into conceptual, logical, and physical models and working integrations while ensuring conformance of all design and analytical deliverables to enterprise standards. Serves as the subject matter expert for business and technical users in interpreting and applying laws and policies governing protection of confidential, sensitive, and proprietary information.

• Oversees the management and maintain of a repository of cross-referenced metadata of information requirements, data definitions, data relationships, naming and formatting standards, and stakeholder organizations to be used for impact analysis, change management purposes, and to support new application development.

• Enhances professional knowledge and skills by attending conferences and advanced training in required areas of expertise.

• Enhances the professional knowledge and skills of team members by providing innovative work opportunities and by helping to identify conferences and advanced training in required areas of expertise.

The position is based at GW’s Virginia Science & Technology campus in Ashburn, VA but may require travel to the Foggy Bottom campus located in Washington, DC. The incumbent may perform other related duties as assigned. The omission of specific duties does not preclude the supervisor from assigning duties that are logically related to the position.

Qualified candidates will hold a Bachelor’s degree in an appropriate area of specialization plus 6 years of relevant professional experience, or, a Master’s degree or higher in a relevant area of study plus 4 years of relevant professional experience. Degree must be conferred by the start date of the position. Degree requirements may be substituted with an equivalent combination of education, training and experience.

- Experience owning end-to-end data analysis, modelling and development tasks for at least 3 to 4 very large data integration or warehousing projects.

- Data modeling experience building enterprise data models for multiple purposes (conceptual, logical and physical) such as Star Schema, Operational Data Store, Graph

- Database design, application design/development, and hands on programming experience in: Database Tables, Graph Nodes and Relationships, JSONSchemas

- Experience with ETL technologies and data movement for various purposes: The University Data Warehouse, The University Operational Data Store/Data Lake, NoSQL/Graph, Application Integration

- Data integration and data delivery experience in: Flat file Creation and Distribution, API Development and Management, Hosted Direct SQL

- Data visualization and analytics experience in: Dashboard development, Search based analytics, Predictive analytics

- Strong familiarity with: Data Architecture best practices (including approaches, related tools, design best practices, standards and principles), Data Warehousing Solution Architecture, Database tuning and data application optimization & Big-Data concepts

- Business process analysis, project management, stakeholder management experience.

- Exceptional communication skills