Enterprise Data Architect

All full-time university staff are eligible for VCU’s robust benefits package that includes: comprehensive health benefits, paid annual and holiday leave granted up front, generous tuition benefit, retirement planning and savings options, tax-deferred annuity and cash match programs, employee discounts, well-being resources, abundant opportunities for career development and advancement, and more. Learn more about VCU’s benefits here.

As a member of the Office of Institutional Research and Decision Support, this position will develop content in current and new Business Intelligence and Data Warehousing applications. In order to accomplish this responsibility the position will focus on project planning consisting of initial business requirement gathering, conducting design sessions, and ensuring the applications are maintained throughout the product lifecycle. Working closely with academic and administrative stakeholders, ERP and other Management Information Systems’ technical staff, this position will conduct needs assessments and document requirements to inform the development of data sources and dashboards. This position will participate in an institution-wide data warehousing effort by collaborating with data stewards, subject matter experts, data custodians, etc. across campus to define and integrate a wide array of university data from a variety of sources.

Key Responsibilities:

• work closely with the Business Intelligence team to elicit data and reporting requirements from data trustees, data stewards, and academic unit leaders via interviews, document analysis, and requirement gathering sessions.

• Provide technical and architectural subject matter expertise to the various development teams including communicating architectural decisions and mentoring other team members within Institutional Research and Decision Support.

• Profile data to ensure consistency and accuracy in reporting. Design, create and manage processes to deliver information through VCU information delivery platforms.

• Improve performance and efficiency of existing reports/dashboards and maintain accuracy against changes in business processes.

•  Develop data visualizations to tell a compelling visual story for decision making.

• Design, create, and management data warehouse solutions, or work with third party vendors for development and deployment of technology to support University warehousing efforts. 

• Work with campus stakeholders on University data governance initiatives. 

• Special projects and other related duties as assigned.
  
  
  

Preferred Qualifications:

• Master’s degree in computer science, information systems, mathematics, statistics, or equivalent work experience in database administration, data warehousing, data modeling and integration.
  

• ETL proficiency.
  

• Experience with unstructured data as it relates to cleansing, extraction, and integration.

Minimum Qualifications:

• Bachelor degree in computer science, information systems, mathematics, statistics, or equivalent work experience in database administration, data warehousing, data modeling and integration.

• Experience in designing and implementing data warehouse solutions and/or Business Intelligence solutions.

• Proficiency in SQL and/or PL/SQL required using data modeling/ETL tools, with preference for SAS technologies, including SAS Data Integration Studio.

• Experience working with stakeholders to gather business and technical requirements.

• Experience in working with Business Intelligence platforms such as the SAS EBI platform developing information delivery solutions utilizing SAS Stored Processes, and SAS Macro technologies.

• Strong understanding of data structures, database design, relational and dimensional data modeling.

• Experience with data visualizations data visualization products including SAS Visual Analytics or Tableau.

• Written and oral communication skills, including the ability to communicate effectively and professionally with all levels of community leadership and university administration.
  
  
  

Rebekah Jewers
jewersrl@vcu.edu