Reporting Analyst, Advancement
Rochester, New York
Employer: University of Rochester
Industry: Nursing-RN
Salary: $59197 - $82888 per year
Job type: Full-Time
Opening
Full Time 40 hours Range URG 110 Ofc Sr Vice Pres Advancement
Schedule
8 AM-4:30 PM; SOME WKNDS/HOLS
Responsibilities
GENERAL PURPOSE:
The Programmer Analyst has a primary responsibility to develop, implement and manage systems and reports for Advancement at the University of Rochester.
In addition, this position will:
JOB DUTIES AND RESPONSIBILITIES:
Report Design and Development (65%)
Verify the data displayed on reports is accurate and conforms to the business rules as stated the Advancement Information Services Policies and Procedures document. Test data integrity within reports for accuracy. Work with the OASIS Team; communicating any data oddities/discrepancies discovered in the process of testing. Review code written by Reporting Team members to ensure their queries will result in displaying accurate information.
Innovation (5%)
Assist in developing solutions to address Advancement's evolving reporting needs. New ideas/solutions are needed for additional training, preferred types of reports, documentation, reporting structures, etc. Attend conferences, professional development and conduct meetings with peers to keep Advancement current with best practices in reporting.
Documentation (5%)
Organize, document and streamline the various reporting methods utilized by Advancement Services which includes SSRS, Tableau and Crystal Reports. Perform other duties as assigned.
Other duties as assigned
QUALIFICATIONS:
How To Apply
All applicants must apply online.
EOE Minorities/Females/Protected Veterans/Disabled
Pay Range
Pay Range: $59,197 - $82,888 Annually
The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job's compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations.
Full Time 40 hours Range URG 110 Ofc Sr Vice Pres Advancement
Schedule
8 AM-4:30 PM; SOME WKNDS/HOLS
Responsibilities
GENERAL PURPOSE:
The Programmer Analyst has a primary responsibility to develop, implement and manage systems and reports for Advancement at the University of Rochester.
In addition, this position will:
- Work with the Senior Director, Advancement Information Services (AIS) to build upon the strategic vision of the Associate Vice President of Advancement Services;
- Define, implement and assist with maintaining policies and procedures in support of OASIS (Advancement's alumni, gift and prospect development platform) and reporting systems;
JOB DUTIES AND RESPONSIBILITIES:
Report Design and Development (65%)
- Design and build new SQL Server Reporting Services (SSRS) reports and Tableau visualizations. Communicate with report requestors to ensure reports are built to their specifications. (25%)
- Write SQL and/or stored procedures to query the data out of the production system to efficiently display on the report in a timely manner. Develop dynamic reporting products while working independently with minimal direction. (20%)
- Create new methods to make report design more efficient and effective, such as report templates. Research best practices for reporting tools and implement them. (5%)
- Ensure SSRS reports, Tableau visualizations and legacy systems conform to Advancement Reporting Standards. (5%)
- Assist with the creation of tables and synonyms and coordinate the migration of report objects to production. (5%)
- Ensure report security is properly assigned and working as expected. (5%)
Verify the data displayed on reports is accurate and conforms to the business rules as stated the Advancement Information Services Policies and Procedures document. Test data integrity within reports for accuracy. Work with the OASIS Team; communicating any data oddities/discrepancies discovered in the process of testing. Review code written by Reporting Team members to ensure their queries will result in displaying accurate information.
Innovation (5%)
Assist in developing solutions to address Advancement's evolving reporting needs. New ideas/solutions are needed for additional training, preferred types of reports, documentation, reporting structures, etc. Attend conferences, professional development and conduct meetings with peers to keep Advancement current with best practices in reporting.
Documentation (5%)
Organize, document and streamline the various reporting methods utilized by Advancement Services which includes SSRS, Tableau and Crystal Reports. Perform other duties as assigned.
Other duties as assigned
QUALIFICATIONS:
- Bachelor's Degree in Business or Management Information Systems required AND/OR
- 4-5 years of relevant technical experience required.
- Experience with SSRS, Oracle, PL-SQL or T-SQL and relational databases required.
- Or an equivalent combination of schooling and experience.
- Significant experience working with Salesforce, SSRS, Oracle (PL-SQL) or SQL Server (T-SQL) and relational databases required.
- Excellent organizational and interpersonal skills needed. Ability to deal effectively with customers and to collaborate well with co-workers.
- Outstanding written and oral communication skills.
- Need to be able to construct data models and documentation.
- Demonstrated expertise with business reporting systems, database/data warehouse architectures, implementation, and maintenance.
- Proven ability to think strategically with respect to long-term information needs as well as tactically with respect to handling current needs, schedule trade-offs, etc.
How To Apply
All applicants must apply online.
EOE Minorities/Females/Protected Veterans/Disabled
Pay Range
Pay Range: $59,197 - $82,888 Annually
The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job's compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations.
Created: 2024-05-16
Reference: 252925
Country: United States
State: New York
City: Rochester
ZIP: 14608
Similar jobs:
-
Functional Analyst - UKG Advanced Scheduling (Senior Consultant MIS Lvl C), Business Applications
NYC Health Hospitals in New York, New York