Associate Director of Data Warehouse & Data Architect

Virginia Community Colleges
Vienna, VA, United States
11 days ago
Apply on www.careerjet.com
Prepare application

Role details

Contract type
Temporary to permanent
Employment type
Part-time / full-time
Experience level
Expert
Compensation
$105,000.0 - $125,000.0
Working hours
Regular working hours

Tech stack

Microsoft Excel Data Analysis Microsoft Azure Cloud Computing Data Architecture Data Governance Data Integration Extract Transform Load (ETL) Data Systems Data Visualization Data Warehousing Relational Databases
+22 more
Linux Data Flow Control Microsoft SQL Server Windows Servers Oracle (Applications) Power BI Standard Sql SAS (Software) Software Engineering SQL Databases Oracle Fusion Middleware Tableau (Software) Technical Data Management Systems Workflow Management Systems Enterprise Data Management Data Processing Scripting Freeform SQL Snowflake People Soft Tools for Reporting Data Pipelines

Job description

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, 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., * * Do you have experience supervising and leading technical professionals responsible for any of the following: data, reporting, analytics, or software development functions?

  • Yes
  • No
    • Do you have experience developing in SQL and relational database platforms in support of reporting and analytics environments?
  • Yes
  • No
    • Do you have experience designing, implementing, or supporting complex data products or business intelligence solutions?
  • Yes
  • No
    • Do you have experience communicating technical concepts and recommendations to both technical and non-technical audiences?
  • Yes
  • No

Applicant Documents Required Documents * Resume Optional Documents * Cover Letter/Letter of Application

  • Other Document
  • Alternative Hiring Process Letter
  • SF-50 (Documentation of involuntary separation from Federal Agency), Overview: We are looking for seasoned Data Architect to work with our team and our clients to architect and develop data models, data warehouses, lakes, and lakehouses, data gove…
  • 1 month ago +

Requirements

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

Benefits & conditions

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 . 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 our website at . The security of our students, faculty, and staff is very important at NOVA. Please take a moment to review 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: 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 Supplemental Questions Required fields are indicated with an asterisk (*). * * 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
    • I understand that this position is not telework eligible and I will be required to attend work in-person.
  • Yes
  • No
    • I understand this position is located in Virginia and I will be required to reside in the DMV metro area.
  • Yes
  • No
    • Do you now or in the future require visa sponsorship to work in the United States?

About the company

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., + Vienna, VA

  • $180,000-190,000 per year Halvik Corp delivers a wide range of services to 13 executive agencies and 15 independent agencies. Halvik is a highly successful WOB business with more than 50 prime contracts and…

  • 1 month ago

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com
Prepare application

Good distractions

Loading talks and stories from around this role…