Database Programmer/Analyst

Fairfax, VA
Commensurate with education and experience.
Dec 02, 2022
Jan 26, 2023
Full Time
Database Programmer/AnalystThe George Mason University, Office of Institutional Effectiveness and Planning invites highly qualified candidates to apply for the position of Database Programmer/Analyst. George Mason University has a strong institutional commitment to the achievement of excellence and diversity among its faculty and staff, and strongly encourages candidates to apply who will enrich Mason's academic and culturally inclusive environment.About the Position:The Office of Institutional Effectiveness and Planning (OIEP) is seeking a Database Programmer/Analyst to fulfill its on-going efforts to build data integration and warehousing solutions to support both business intelligence and analytical applications for decision making in institutional effectiveness and planning.The position provides technical expertise for the development, maintenance, and documentation of OIEP Oracle databases which are essential to support the development of dashboards and data visualizations. The goal is to provide access to easy-to-use tools for university leaders and campus partners/colleagues.The Database Programmer/Analyst will report to OIEP's Director of Business Analytics. The incumbent will work in the office on the Fairfax Campus with potential for up to two days of telework.Responsibilities:Create, maintain and organize Oracle data tables;Extract data from a variety of sources of records, including Banner, to create and maintain Oracle data tables for web report development, SAS scripts and/or other office applications;Lead in creating comprehensive datasets for use in SAS Viya and other dashboard tools;Create, update and maintain written documentation of processes and procedures used to create/update all datasets and tables maintained by OIEP;Design, automate, schedule, load jobs from source data and multi-location databases with data flows and synchronization mapping;Develop web-based applications and provide website support and maintenance as needed;Provide analytical support for research requests;Work with Information Technology Services to ensure smooth transitions with upgrades to Oracle, firewall, applications, and other IT issues in order to maintain proper functioning of OIEP website tables; andIdentify BI/analytics tools and analytical applications for developing institutional research and assessment dashboards.Required Qualifications:Bachelor's degree in Computer Science, Information Systems, Management Information Sciences, Engineering, or a related discipline, or equivalent combination of related education and experience;Experience using SAS, SQL, SPSS, or other comparable statistical program for complex analysis and decision support;Demonstrated Oracle application development experience (i.e., SQL, PL/SQL), expertise in SQL Developer or other SQL database management tools;Knowledge and understanding of RDB technology, OLAP and server tools;Knowledge of ERP e.g., Banner / PeopleSoft;Demonstrated ability to develop code to extract and merge data from multiple platforms;Demonstrated ability to develop code to validate and provide summary statistics;Demonstrated ability to develop code for web applications as well as knowledge of web development tools and programming languages (e.g., JavaScript, CSS, JQuery, Coldfusion, Python) and Content Management Systems (e.g., WordPress, Drupal);Ability to apply analytical and critical thinking skills, particularly to identify data (in)consistency, definitional clarity, etc.;Demonstrated written and verbal communication skills with various technical and non-technical audiences, including information technology groups; andMust be a self-starter with a demonstrated ability to work independently and effectively manage time and resources to maximum advantage.Preferred Qualifications:Master's degree in related field;SAS certification;Database certification;Knowledge of programming in SAS or SPSS or other comparable statistical programs;Working knowledge of front-end reporting tools such as SAS Visual Analytics and SAS Visual Statistics, and Microstrategy, for easy access to institutional data; andExperience in a Higher Education setting.

For full consideration, applicants must apply for position number 01284z at; complete and submit the online application; and upload a cover letter, resume, and a list of three professional references with contact information.

"Great Careers Begin at Mason! George Mason University is an innovative, entrepreneurial institution with national distinction in both academics and research. Mason holds a top U.S. News and World Report "Up and Coming" spot for national universities and is recognized for its global appeal and excellence in higher education.Mason is currently the largest and most diverse university in Virginia with students and faculty from all 50 states and over 135 countries studying in over 200 degree programs at campuses in Arlington, Fairfax and Prince William, as well as at learning locations across the commonwealth. Rooted in Mason's diversity is a campus culture that is both rewarding and exciting, work that is meaningful, and opportunities to both collaborate and create.If you are interested in joining the Mason family take a look at our current opportunities and catch some Mason spirit at!George Mason University, Where Innovation is Tradition."

George Mason University is an equal opportunity/affirmative action employer, committed to promoting inclusion and equity in its community. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any characteristic protected by law.

Similar jobs