Associate Director of Data Warehouse & Data Architect

Virginia Community Colleges

• $105K — $125K *
Education, Government & Non-Profit
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in data management and architecture roles.
  • Proficient in SQL and relational database platforms for reporting and analytics.
  • Experience leading teams of technical professionals in data or software development functions.
  • Strong knowledge of data warehousing, business intelligence, and data governance.
  • Ability to communicate technical concepts clearly to diverse audiences.

Responsibilities

  • Supervise and mentor a technical team, ensuring professional development and performance evaluations.
  • Manage project resources and departmental workload for timely delivery of data solutions.
  • Provide strategic oversight for data warehouse and business intelligence initiatives.
  • Communicate project status and manage stakeholder expectations effectively.
  • Design and maintain enterprise data architectures to support financial systems and reporting needs.
  • Evaluate and modernize existing data systems for better accessibility and performance.
  • Lead technical oversight for ETL processes and data integration initiatives.

Benefits

  • Generous paid leave and vacation policy.
  • Health insurance options including medical, dental, and vision.
  • Retirement plan with employer matching contributions.
  • Professional development opportunities and tuition assistance.
  • Supportive work environment fostering collaboration and innovation.
Full Job Description
Posting Details

Posting Summary

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

Does this position have telework options? -Telework options are subject to change based on business needs-
No

Does this position have a bilingual or multilingual skill requirement or preference?

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.

KSA's/Required 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.


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

Position End Date (if temporary)

Job Open Date
09/29/2026

Job Close Date
10/29/2026

Open Until Filled

Agency Website
www.nvcc.edu

Contact Name

Email

Phone Number

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 this link: https://www.dars.virginia.gov/drs/cpid/PWContact.aspx or call DARS at 800-552-5019, or DBVI at 800-622-2155

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

Similar Jobs

More Jobs at Virginia Community Colleges

More Education, Government & Non-Profit Jobs

  • Director of Finance
    $80K — $150K + 100% employer paid medical, dental and vision coverage - 4 weeks *
    Kingman Academy of Learning
    Kingman, AZ 86409 (Mohave County)
  • Chief People Officer (CPO)
    Stowers Institute for Medical Research
    Kansas City, MO 64110 (Jackson County)
  • Accounting Manager
    $120K — $140K + 25% *
    MetaStar, Inc.
    Madison, WI 53713 (Dane County)
  • Senior Analyst, Business Development
    $95K — $100K *
    Columbia University Irving Medical Center
    New York, NY 10032 (New York County)
  • Communications Director
    $80K — $95K *
    Charlotte Center City Partners
    Charlotte, NC 28269 (Mecklenburg County)

Find similar Associate Director of Data Warehouse & Data Architect jobs: