SQL Programmer/Data Manager

SQL Programmer/Data Manager

Benefits of working at VCU

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 .

Job Code 24222
Recruitment Pool All Applicants
Posting Number req6316
Unit VP Research MBU
Department Office of the Vice President for Research & Innovation
Department Website Link https://research.vcu.edu/rams-systems/
Location VCU
Address 907 Floyd Ave, Richmond, VA 23284 USA
Duties & Responsibilities

Welcome to Virginia Commonwealth University (VCU) … a world UNLIKE any other!
At VCU, we are UNCOMMON and UNLIKE any other university. A premier, urban, public research university nationally recognized as one of the best employers for diversity, VCU is a great place to work. It’s a place of opportunity where your success is supported and your career can thrive. VCU offers employees a generous leave package, career paths for advancement, competitive pay, and an opportunity to do mission-driven work.

VCU's Office of the Vice President for Research and Innovation and it's Research Computing Division invites all interested candidates to apply for our new SQL Programmer/Data Manager!

Our impact is measured one student and patient at a time. VCU’s unequaled combination of excellence, diversity, research and creativity makes success possible for every one of our 300,000+ “RAMily” members. And that makes us one of the most innovative universities in the country. A premier, urban, public research university nationally recognized as one of the best employers for diversity, VCU is a great place to work. It's a place of opportunity, where your success is supported and your career can thrive.

All full-time staff are eligible for our generous benefits package that includes choices for health, vision, and dental coverage, life-insurance, short and long-term disability coverage, retirement planning, tax-deferred annuity and cash match programs, flexible spending accounts, tuition benefits, significant paid-time off,12 paid holidays, and more. Explore our benefits further here: https://hr.vcu.edu/current-employees/benefits/



Primary Purpose and General Responsibilities:

The SQL Programmer/Data Manager will be responsible for the day-to-day development and maintenance of data structures and queries for the electronic research administration systems. They will develop databases, tables, views, stored procedures and any other database structure in support of the data reporting and analytics for the OVPRI. They will also develop database integrations between the research administration system and other external data destinations, like ODS, SOM data warehouse, etc. Finally, the data manager will monitor and optimize query performance and access control.

Typical Duties:

Maintain reporting database environment
Create and augment tables, reporting views, and stored procedures to
Create and maintain integrations with other systems
Monitor and optimize application query performance
Maintain database access control
Create datasets to support Tableau visualizations
Write ad hoc SQL queries
Monitor and optimize application query performance

Qualifications

Minimum Qualifications:
Database development experience
Query development using SQL Server Management Studio
Knowledge of ETL and data manipulations languages
Problem solving skills
Good verbal and written communication skills
The candidate should have demonstrated experience working in and fostering a diverse faculty, staff, and student environment or commitment to do so as a staff member at VCU.

Preferred Qualifications:
SQL development using SQL Server
ETL tool usage using SSIS
Reporting or visualization tool usage using either SSRS or Tableau

FLSA University Employee
Job FTE 1.0
Exemption Status Exempt
Restricted Position Yes
E-Class UF - University Employee FT
Job Category University Employee
ORP Eligible No
Salary Range Commensurate with experience up to $75,000
Compensation Type Salaried
Target Hire Date 11/10/2024
Contact Information for Candidates

Documents Needed to Apply resume, letter of interest