Associate Director of Data Warehouse & Data Architect

Northern Virginia Community College; Annandale (VA); On-site; USD 105,000 - 125,000; Full time

Job summary

Northern Virginia Community College seeks an Associate Director of Data Warehouse & Data Architect to serve as the college’s senior technical data expert, leading SQL modeling, data warehouse engineering, and analytics support for admin and academic departments.

You will supervise a team including a Business Analyst, Data Quality Manager, SAS Programmer, and SQL Developer, delivering enterprise reporting, data governance, and data integration across the college.

Qualifications

• Experience supervising technical professionals in 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.

Responsibilities

• Supervise and develop a team consisting of a Business Analyst, Data Quality Manager, SAS Programmer, and SQL Developer.
• Lead data warehouse, business intelligence, and data governance initiatives.
• Design and maintain enterprise data architectures that support stakeholder requests and expanding Budget and Finance data warehouse solutions.
• Oversee ETL processes, data pipelines, and reporting environments.

Skills

SQL

Scripting languages

Data tools

Power BI

Tableau

Excel

Linux

Windows Server

Cloud technologies

Data governance

Tools

ETL tools

SQL Server

Snowflake

Azure

Oracle

Job description

Associate Director of Data Warehouse & Data Architect

Working Title: Associate Director of Data Warehouse & Data Architect

Role Title: Info Technology Specialist II

Role Code: 39112-FP

FLSA: Exempt

Pay Band: 05

Position Number: 28000539

Agency: Northern VA Community College

Division: NV280-VP of College Computing

Work Location: Fairfax County - 059

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

Emergency/Essential Personnel: No

EEO Category: 1-Officials and Administrators

Full Time or Part Time: Full Time

Telework options: No

Work Schedule: Monday – Friday 8:30 am – 5 pm.

Sensitive Position: No

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.

Special Assignments: May be required to perform other duties as assigned. May be required to assist the agency or state government generally in the event of an emergency declaration by the Governor.

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

Operation of a State Vehicle: No

Supervises Employees: Yes

Required Travel: n/a

Posting Detail Information

Posting Number: CLS_4779P

Recruitment Type: General Public - G

Number of Vacancies: 1

Job Open Date: 09/29/2026

Job Close Date: 10/29/2026

Open Until Filled:

Agency Website: www.nvcc.edu

Special Instructions to Applicants: In support of the Commonwealth’s commitment to inclusion, we are encouraging individuals with disabilities to apply through the Commonwealth’s Alternative Hiring Process. To be considered for this opportunity, applicants will need to provide their AHP Letter (formerly called a Certificate of Disability) provided by the Department for Aging & Rehabilitative Services (DARS), or the Department for the Blind & Vision Impaired (DBVI). Service-Connected Veterans may also apply via the AHP if they also provide an AHP Letter. To request an AHP Letter, use the following link: https://www.dars.virginia.gov/drs/cpid/PWContact.aspx or call DARS at 800-552-5019, or DBVI at 800-622-2155.

Additional Information: Northern Virginia Community College (NOVA) is the largest public institution of higher education in the Commonwealth of Virginia and one of the largest community colleges in the nation. NOVA enrolls nearly 75,000 students on its six campuses in Alexandria, Annandale, Sterling, Manassas, Springfield, and Woodbridge, as well as through NOVA Online and high school dual enrollment programs. The College offers more than 100 affordable associate degree and certificate programs to help our students reach their academic and professional goals in some of the most in-demand careers.At NOVA, we are deeply committed to fostering an inclusive community for all students, faculty, and staff, and our diverse workforce is representative of this commitment. To this end, we encourage all applicants seeking to add value through their diverse backgrounds, experiences, and interests to consider employment opportunities with NOVA. To learn more about NOVA’s commitment to inclusive excellence, please visit At a Glance | Northern Virginia Community College. NOVA offers eligible employees a benefits package that includes a comprehensive health and dental insurance program, generous paid leave, deferred compensation plans, paid parental leave, state employee discounts, and a solid and secure retirement program.We strive to ensure our employees have tools and development opportunities to support and promote NOVA’s mission. For more information about NOVA and its programs and services, please visit www.nvcc.edu. The security of our students, faculty, and staff is very important at NOVA. Please take a moment to review NOVA’s Annual Security Reports.

Background Check Statement Disclaimer: The selected candidate’s offer is contingent upon the successful completion of a criminal background investigation, which may include: fingerprint checks, local agency checks, employment verification, verification of education, credit checks (relevant to employment). Additionally, selected candidates may be required to complete the Commonwealth’s Statement of Economic Interest. For more information, please follow this link: http://ethics.dls.virginia.gov/

EEO Statement: The Virginia Community College System (VCCS) provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, political affiliation, veteran status, sexual orientation, gender identity or other non-merit factors.

ADA Statement: The Virginia Community College System (VCCS) is an Equal Employment Opportunity employer and complies with the Americans with Disabilities Acts (ADA and ADAAA), to provide, reasonable accommodation to applicants in need of access to the application, interviewing, and selection processes when requested.

E-Verify Statement: VCCS uses E-Verify to check employee eligibility to work in the United States. You will be required to complete an I-9 form and provide documentation of your identity for employment purposes.

Quicklink for Posting: https://jobs.vccs.edu/postings/101746

Supplemental Questions

1. I understand that only information provided at the time of the application submission will be considered when determining my qualifications and only responses to Supplemental Questions that can be verified in my application and resume will be credited.
   • Yes
   • No
2. I understand that this position is not telework eligible and I will be required to attend work in-person.
   • Yes
   • No
3. I understand this position is located in Virginia and I will be required to reside in the DMV metro area.
   • Yes
   • No
4. Do you now or in the future require visa sponsorship to work in the United States?
   • Yes
   • No
5. Are you applying for this position to satisfy an OPT training requirement for your educational program?
   • Yes
   • No
6. Do you have experience supervising and leading technical professionals responsible for any of the following: data, reporting, analytics, or software development functions?
   • Yes
   • No
7. Do you have experience developing in SQL and relational database platforms in support of reporting and analytics environments?
   • Yes
   • No
8. Do you have experience designing, implementing, or supporting complex data products or business intelligence solutions?
   • Yes
   • No
9. Do you have experience communicating technical concepts and recommendations to both technical and non-technical audiences?
   • Yes
   • No

Applicant Documents

Required Documents

1. Resume

Optional Documents

1. Cover Letter/Letter of Application
2. Other Document
3. Alternative Hiring Process Letter
4. SF-50 (Documentation of involuntary separation from Federal Agency)