Rice University
Systems Analyst
Rice University, Houston, Texas, United States, 77246
Job Description
Position Summary
Reporting to the Senior Director, Development Information Services, the Systems Analyst works at an experienced level supporting Rice University's alumni/development system (OwlConnect, powered by Blackbaud CRM) and related applications, including the integrations to and from other campus systems. The Systems Analyst has expertise in a combination of technical and business application areas and actively participates in new technology initiatives. This position is responsible for working with OwlConnect users to develop queries, reports, automated business processes, integrations to third party systems and data warehouse solutions to support their business.
The ideal candidate is comfortable working in a fast-paced environment managing multiple tasks and has strong verbal and written communication skills and analytical skills, as well as strong attention to detail, especially regarding data quality.
RequirementsBachelor's Degree in Computer Science, Engineering, Management Information Systems, or a related field
In lieu of the education requirement, additional related experience, above and beyond what is required, on an equivalent year-for-year basis may be substituted
Three years of related experience in application administration and support, including experience utilizing SQL and related SQL management tools (SSMS, SSAS, SSIS and SSRS)
In lieu of the experience requirement, additional related education, above and beyond what is required, on an equivalent year-for-year basis may be substituted
Skills Required
Knowledge of computer system capabilities, business processes and workflowExperience with enterprise applications and understanding of database driven applicationsExperience with SQL scriptingStrong understanding of the software development life cycleExcellent communication skills, both written and verbal, including the ability to bridge functional and technical resources by communicating effectively with individuals of varying systems expertise and business needsProven problem solving and analytical thinking and ability to approach problems logically and systematicallyAbility to maintain good customer relations with clients and external vendors and partners
Essential Functions
Builds ad hoc queries, reports and business processes using standard Blackbaud CRM features/functionalityBuilds custom business process and data integrations using SQLSupports system users with issues, new requests and system upgradesCollaborates with team members and individuals across the Development and Alumni Relations division to develop best practices, re-usable objects and effective documentationAnalyzes and documents user needs, existing and new policies, processes, procedures and operational methods to consider possible improvements to new and existing systemsUtilizes elicitation techniques to understand business processes and translate into system requirements and/or development of systems solutionsDefines and documents business requirements, technical specifications and test cases for system developmentsMay include the writing of all or a portion of functional and technical specificationsCoordinates with business and technology teams, ascertaining system requirements, such as program functions, output requirements, input data acquisition, and system techniques and controlsProblem solves in areas such as system design, input/output requirements and procedural flow between departments and/or business systemsPerforms configuration of enterprise application softwarePerforms testing of new systems, upgrades and patching of existing systemsPlans, conducts and documents results of testingPerforms all other duties as assignedAdditional Functions
Has frequent contact with division staff and other university officesOpen office environmentMany hours spent in front of a computerEvening/weekend and on call work as required to meet project deadlines and/or maintain system availabilityPreferences
Four or more years of related experience in application software supportProgramming experience utilizing SQL and related SQL tools, and report development tools using SSRS, PowerBI and/or TableauC# programming experienceExperience developing business intelligence solutionsExperience building SSIS (SQL Server Integration Services) packagesExperience with project management methodologiesExperience with REST APIsExperience with alumni/development database systems, preferably Blackbaud CRMExperience in non-profit or higher education settingThorough understanding and working knowledge of alumni relations and/or fundraisingSkills
Excellent organizational skillsStrong attention to detailHigh levels of overall organization, accuracy and time managementGoal oriented with the ability to prioritize a heavy workloadWillingness to take charge of assignments and follow through with minimal supervisionAbility to work with high level of confidentialityProficiency in Microsoft Office Suite
Rice University HR | Benefits
https://knowledgecafe.rice.edu/benefits
Rice Mission and Values
Mission and Values | Rice University
Rice University is an Equal Opportunity Employer with commitment to diversity at all levels, and considers for employment qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national or ethnic origin, genetic information, disability or protected veteran status.
About Us
Boasting a 300-acre tree-lined campus in Houston, Rice University is ranked among the nation's top 20 universities by U.S. News & World Report. Rice has a 6-to-1 undergraduate student-to-faculty ratio, and a residential college system, which supports students intellectually, emotionally and culturally through social events, intramural sports, student plays, lectures series, courses and student government. Developing close-knit, diverse college communities is a strong campus tradition, which is why Rice is highly ranked for best quality of life and best value among private universities.
Position Summary
Reporting to the Senior Director, Development Information Services, the Systems Analyst works at an experienced level supporting Rice University's alumni/development system (OwlConnect, powered by Blackbaud CRM) and related applications, including the integrations to and from other campus systems. The Systems Analyst has expertise in a combination of technical and business application areas and actively participates in new technology initiatives. This position is responsible for working with OwlConnect users to develop queries, reports, automated business processes, integrations to third party systems and data warehouse solutions to support their business.
The ideal candidate is comfortable working in a fast-paced environment managing multiple tasks and has strong verbal and written communication skills and analytical skills, as well as strong attention to detail, especially regarding data quality.
RequirementsBachelor's Degree in Computer Science, Engineering, Management Information Systems, or a related field
In lieu of the education requirement, additional related experience, above and beyond what is required, on an equivalent year-for-year basis may be substituted
Three years of related experience in application administration and support, including experience utilizing SQL and related SQL management tools (SSMS, SSAS, SSIS and SSRS)
In lieu of the experience requirement, additional related education, above and beyond what is required, on an equivalent year-for-year basis may be substituted
Skills Required
Knowledge of computer system capabilities, business processes and workflowExperience with enterprise applications and understanding of database driven applicationsExperience with SQL scriptingStrong understanding of the software development life cycleExcellent communication skills, both written and verbal, including the ability to bridge functional and technical resources by communicating effectively with individuals of varying systems expertise and business needsProven problem solving and analytical thinking and ability to approach problems logically and systematicallyAbility to maintain good customer relations with clients and external vendors and partners
Essential Functions
Builds ad hoc queries, reports and business processes using standard Blackbaud CRM features/functionalityBuilds custom business process and data integrations using SQLSupports system users with issues, new requests and system upgradesCollaborates with team members and individuals across the Development and Alumni Relations division to develop best practices, re-usable objects and effective documentationAnalyzes and documents user needs, existing and new policies, processes, procedures and operational methods to consider possible improvements to new and existing systemsUtilizes elicitation techniques to understand business processes and translate into system requirements and/or development of systems solutionsDefines and documents business requirements, technical specifications and test cases for system developmentsMay include the writing of all or a portion of functional and technical specificationsCoordinates with business and technology teams, ascertaining system requirements, such as program functions, output requirements, input data acquisition, and system techniques and controlsProblem solves in areas such as system design, input/output requirements and procedural flow between departments and/or business systemsPerforms configuration of enterprise application softwarePerforms testing of new systems, upgrades and patching of existing systemsPlans, conducts and documents results of testingPerforms all other duties as assignedAdditional Functions
Has frequent contact with division staff and other university officesOpen office environmentMany hours spent in front of a computerEvening/weekend and on call work as required to meet project deadlines and/or maintain system availabilityPreferences
Four or more years of related experience in application software supportProgramming experience utilizing SQL and related SQL tools, and report development tools using SSRS, PowerBI and/or TableauC# programming experienceExperience developing business intelligence solutionsExperience building SSIS (SQL Server Integration Services) packagesExperience with project management methodologiesExperience with REST APIsExperience with alumni/development database systems, preferably Blackbaud CRMExperience in non-profit or higher education settingThorough understanding and working knowledge of alumni relations and/or fundraisingSkills
Excellent organizational skillsStrong attention to detailHigh levels of overall organization, accuracy and time managementGoal oriented with the ability to prioritize a heavy workloadWillingness to take charge of assignments and follow through with minimal supervisionAbility to work with high level of confidentialityProficiency in Microsoft Office Suite
Rice University HR | Benefits
https://knowledgecafe.rice.edu/benefits
Rice Mission and Values
Mission and Values | Rice University
Rice University is an Equal Opportunity Employer with commitment to diversity at all levels, and considers for employment qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national or ethnic origin, genetic information, disability or protected veteran status.
About Us
Boasting a 300-acre tree-lined campus in Houston, Rice University is ranked among the nation's top 20 universities by U.S. News & World Report. Rice has a 6-to-1 undergraduate student-to-faculty ratio, and a residential college system, which supports students intellectually, emotionally and culturally through social events, intramural sports, student plays, lectures series, courses and student government. Developing close-knit, diverse college communities is a strong campus tradition, which is why Rice is highly ranked for best quality of life and best value among private universities.