General Information
| Payroll Title | PROGR ANL 3 | Title Code | 007275 | Grade/Step | 10 | Working Title | Senior Programmer Analyst |
|---|---|---|---|---|---|---|---|
| Department Name | Advancement Services | Supervisor | Watson, Lisa L | Department Head | Peter A Hayashida |
Special Requirements and Conditions
| Critical Position |
Level of Supervision Received
| - |
Items Used
Position Purpose
| Under general direction of the Executive Director of Advancement Services, the incumbent of this position will work in a team environment with other Constituent Management & Technologies (CMT) programmers to analyze, maintain, document, test, and deploy application programming solutions, including web forms, ETL (Extract Transform Load) processes, reports, and custom API programming for applications used by University Advancement. Make efficient use of technologies such as SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Blackbaud's VBA/API for Raiser's Edge (RE), ASP.NET, and other technologies.
Provide technical support as well as assist in developing and conducting database programmer training; create, compile, and distribute programming standard documentation as it relates to ETL, reporting, web interfaces. |
Essential Functions
| Essential Function | % Time |
|---|---|
| Programming | 100 |
| This is a full-time programming position. Involves managing/executing customer requests.
Design, create and implement custom reports from several resources using Crystal Report, SSRS, or similar tools. Program simple to moderately complex solutions using languages such as ASP.NET, SQL, VBA, VB scripting. Program data extract and report requests received from campus customers using tools such as Crystal Reports, SSRS/BIDS, SSMS, SSIS. Engage with Lead programmer in database design and implement business rules, customize applications to provide additional capabilities by creating new objects (tables, views, functions, indexes, roles, stored procedures and packages, database triggers, etc). Database technologies include, but are not limited to, SQL Server and Oracle. Develop, maintain, implement, and support complex SQL programs, including queries, stored procedures, views, functions, jobs, and SSIS packages. Maintain, upgrade, or develop software applications, including the preparation of Return on Investment (ROI) and feasibility analysis per management's direction. Design and develop test plans and procedures. Prepare system test data and program documentation utilizing design specifications and test plans. Debug programs and reports utilizing design specifications and test plans. Manage, maintain and support web pages and develop web-based programs as assigned. Gather business requirements and develop or enhance COM API / stand-alone applications, client server applications, and web applications, ETL solutions. Make configuration, code table changes and user option modifications in applications supported by CMT. Develop and maintain custom VBA/API solutions for Blackbaud's Raiser's Edge. Serve as a technical expert for data conversions. Programming projects as assigned. |
|
Minimum Requirements
| Minimum Requirement | Display Ranking |
|---|---|
| 10 | |
| Bachelor's degree in computer science or a related field or an equivalent combination of education and experience.
Minimum of 2-3 years recent experience working as a programmer. Recent experience working with data warehouses and developing complex ETL processes using SQL Server Integration Services (SSIS). Recent experience in SQL programming and an understanding of relational databases (i.e., SQL Server or Oracle). Recent experience in report writing via crystal reports or SQL Server Reporting Services (SSRS). Recent experience in web programming, particularly HTML, JavaScript, classic ASP, and ASP.NET. Working knowledge of structured programming techniques and terminology, including the ability to analyze, design, code, test, debug, and document complex computer programs. Demonstrated ability to work both independently and in a team and to set/adjust priorities. Ability to work effectively in a strong service-oriented environment under time pressures subject to rapidly shifting priorities. Experience and technical proficiency in configuring, testing and troubleshooting problems. Strong interpersonal skills. Demonstrated knowledge of Microsoft Internet Information Systems. Knowledge of office procedures, office equipment, telephone etiquette, basic arithmetic, and rules of proper English usage, grammar, punctuation and spelling. Ability to create and maintain program libraries, user manuals, and technical documentation. Ability to provide useful, effective, and respectful support to users in order to accomplish the goals of the unit. |
|
Preferred Qualifications
| Preferred Qualification | Display Ranking |
|---|---|
| 8 | |
|
Advanced degree in computer science or a related field or an equivalent combination of education and experience.
Experience troubleshooting and maintaining IIS related services. Experience with Ajax, Flex/Flash, XML/JSON or emerging Internet technologies. Experience using Microsoft Team Foundation Server for source control as well as a ticketing/project management system. Experience with the Blackbaud RE VBA/API. Experience giving presentations to both technical and non-technical audiences. Knowledge of philanthropy and fundraising techniques. Knowledge of business administration concepts within an academic institution. |
|
| Posted Position Purpose |
|---|
| With a diverse student body and a faculty devoted to teaching, world-class research and community service, UCR has achieved a national academic reputation. UCR's division of University Advancement (UA) builds deep, lasting relationships to advance the campus and generate financial resources. The unit includes development, strategic communications, alumni & constituent relations/event management, UCR Foundation, and the Vice Chancellor's office. The technological infrastructure for these front-line units is provided by a combination of Advancement Services and campus IT (Computing & Communications). The division has a total of 90 FTE working collaboratively to tell the UCR story and promote and encourage support for faculty, students, programs, and facilities. Under direction of the Executive Director of Advancement Services, this incumbent will work in a team environment with other Constituent Management & Technologies (CMT) programmers to analyze, maintain, document, test, and deploy application programming solutions, including web forms, ETL (Extract Transform Load) processes, reports, and custom API programming for applications used by University Advancement. Make efficient use of technologies such as SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Blackbaud's VBA/API for Raiser's Edge (RE), ASP.NET, and other technologies. Incumbent will provide technical support as well as assist in developing and conducting database programmer training; create, compile, and distribute programming standard documentation as it relates to ETL, reporting, web interfaces.
|
| Posted Minimum Requirements |
| Bachelor's degree in computer science or a related field or an equivalent combination of education and experience.
Minimum of 2-3 years recent experience working as a programmer. Recent experience working with data warehouses and developing complex ETL processes using SQL Server Integration Services (SSIS). Recent experience in SQL programming and an understanding of relational databases (i.e., SQL Server or Oracle). Recent experience in report writing via crystal reports or SQL Server Reporting Services (SSRS). Recent experience in web programming, particularly HTML, JavaScript, classic ASP, and ASP.NET. Working knowledge of structured programming techniques and terminology, including the ability to analyze, design, code, test, debug, and document complex computer programs. Demonstrated ability to work both independently and in a team and to set/adjust priorities. Ability to work effectively in a strong service-oriented environment under time pressures subject to rapidly shifting priorities. Experience and technical proficiency in configuring, testing and troubleshooting problems. Strong interpersonal skills. Demonstrated knowledge of Microsoft Internet Information Systems. Knowledge of office procedures, office equipment, telephone etiquette, basic arithmetic, and rules of proper English usage, grammar, punctuation and spelling. Ability to create and maintain program libraries, user manuals, and technical documentation. Ability to provide useful, effective, and respectful support to users in order to accomplish the goals of the unit. |
| Posted Preferred Qualifications |
| Advanced degree in computer science or a related field or an equivalent combination of education and experience.
Experience troubleshooting and maintaining IIS related services. Experience with Ajax, Flex/Flash, XML/JSON or emerging Internet technologies. Experience with the Blackbaud RE VBA/API. Experience giving presentations to both technical and non-technical audiences. Knowledge of philanthropic techniques. Knowledge of business administration concepts within an academic institution. |