Associate Director of Data Warehouse & Data Architect

Virginia AG; Fairfax (VA); On-site; USD 105,000 - 125,000; Full time

Job summary

Northern VA Community College seeks an Associate Director of Data Warehouse & Data Architect to lead SQL modeling, data warehouse engineering, and analytics support for Budget and Finance. The role directs a team responsible for enterprise reporting, data governance, and data integration, translating complex requirements into scalable data solutions.

The Associate Director will collaborate with offices across the college, supervise the team, guide ETL processes, and ensure timely delivery of

Qualifications

• Experience in SQL and data manipulation for reporting and analytics.
• Experience designing and supporting data warehousing and BI solutions.
• Experience communicating technical concepts to technical and non-technical audiences.

Responsibilities

• Supervise and develop a team including a Business Analyst, Data Quality Manager, SAS Programmer, and SQL Developer.
• Manage workload, resources, and project portfolios to deliver data and reporting solutions on time.
• Provide strategic leadership for data warehouse, BI, and data governance initiatives.
• Communicate project status, risks, and resource needs to leadership.
• Design and maintain enterprise data architectures to support Budget and Finance data warehouse solutions.
• Evaluate existing data systems for modernization and improved data access.
• Oversee ETL processes, data pipelines, warehouse structures, and reporting environments.
• Guide design and development of SQL-based solutions for institutional reporting and analytics.
• Review technical designs, data models, and code produced by team members.
• Lead troubleshooting for data integration and reporting issues.
• Solicit input from employees for college decisions and share with NOVA Brief.

Skills

SQL

Data warehousing

ETL

Data governance

Power BI/Tableau/Excel

Data modeling

SaaS data integration

Linux/Windows servers

SQL Server/Snowflake/Azure

Tools

Oracle

SQL Server

Snowflake

Azure

Job description

Title: Associate Director of Data Warehouse & Data Architect

Agency: Northern VA Community College

Location: Fairfax County - 059

FLSA: Exempt

Hiring Range: $105,000 - $125,000

Full Time or Part Time: Full Time

Additional Detail

Job Description:

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.

The position supervises a team consisting of a Business Analyst, Data Quality Manager, SAS Programmer, and SQL Developer responsible for delivering enterprise reporting, analytics, data governance, and data integration services across the college.

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

Minimum Qualifications:

Required KSAs:

• Knowledge and ability in SQL, scripting languages and data tools for data manipulation and transformation.
• Knowledge of data pipeline and workflow management tools.
• Knowledge in architecting data warehousing and business intelligence solutions.
• Knowledge of Software as a service (SaaS) applications, and their integration from a dataflow perspective.
• Knowledge of industry trends and standards
• Ability to create data visualizations using Power BI, Tableau, and/or Excel.
• Working knowledge of Linux and Windows Server, as well as cloud technologies.
• Excellent analytical and problem-solving skills, with the ability to translate complex requirements into practical data solutions.
• Ability to keep up to date knowledge of industry trends and standards.
• Ability to deliver quality systems within a management-approved schedule, and to work on technical teams as needed.
• Ability to lead/manage projects and be accountable for project development and execution; manage the details of a project while remaining aware of the overall application/business requirements.

Minimum Qualifications:

• 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.

Additional Considerations:

Additional Considerations:

• Experience supervising Business Analysts, Data Engineers, SQL Developers, Reporting Developers, or Data Quality professionals.
• Experience supporting budgeting, finance, or human resources systems
• Experience in a higher education organization.
• Experience with Oracle, SQL Server, Snowflake, Azure, or similar enterprise data platforms.
• Experience with PeopleSoft, Oracle Fusion Cloud or other ERP systems.
• Experience implementing data governance and data quality programs.
• Experience leading enterprise reporting, analytics, and institutional data initiatives.
• Experience overseeing ETL development, reporting architecture, and data integration initiatives.