Job Details
Associate Director of Data Warehouse & Data Architect
Associate Director of Data Warehouse & Data Architect
Northern Virginia Community College
General Description: The Associate Director will serve as the college's senior technical data expert, providing direct SQL modeling and development, data warehouse engineering, and supervising business analysis support to administrative and academic departments. The position will work closely with functional offices, including Budget, Finance, Institutional Resources, and Enrollment Management, to translate business requirements into data solutions, develop complex SQL queries and datasets, and deliver data products that support institutional decision-making. Duties and Tasks:- Supervise, mentor, develop, and evaluate a team consisting of a Business Analyst, Data Quality Manager, SAS Programmer, and SQL Developer.
- Manage departmental workload, resource allocation, and project portfolios to ensure timely delivery of data and reporting solutions.
- Provide strategic leadership for data warehouse, business intelligence, and data governance initiatives.
- Manage stakeholder expectations and communicate project status, risks, and resource needs to leadership.
- Design and maintain enterprise data architectures that support key stakeholder requests and expanding and supporting existing Budget and Finance data warehouse solutions.
- Evaluate existing data systems and identify opportunities for modernization, consolidation, and improved data accessibility.
- Provide technical oversight for enterprise ETL processes, data pipelines, data warehouse structures, and reporting environments.
- Guide the design, development, and optimization of SQL-based solutions supporting institutional reporting and analytics.
- Review technical designs, data models, SQL code, ETL processes, and reporting solutions developed by team members.
- Lead troubleshooting efforts for critical data integration, data quality, and reporting issues.
- Make regular requests from employees for updates and input on college decisions and share feedback with supervisors for inclusion in the NOVA Brief
- Experience supervising and leading technical professionals responsible for any of the following: data, reporting, analytics, or software development functions.
- Experience developing in SQL and relational database platforms in support of reporting and analytics environments.
- Experience designing, implementing, or supporting complex data products or business intelligence solutions.
- Experience communicating technical concepts and recommendations to both technical and non-technical audiences.
