To aggregate data from multiple sources in an efficient data warehouse and deliver reports, dashboards, and analytics for Institutional Advancement. Provide support to the Director of Advancement Services in fulfilling the technical needs of the department, including application support, server maintenance, and provisioning of personal hardware systems. Reports to the Manager, Advancement Business Intelligence.
Additional Basic Function – if applicable:
Examples of Duties:
Duties/essential functions may include, but not be limited to, the following:
Plan, design, and implement Business Intelligence (BI) solutions. Gather and analyze requirements utilizing technical skills and functional expertise. Ensure deployed solutions meet performance and development standards, and are scalable to meet future demands.
Create and deploy reports, dashboards, and cubes. Provide support for user facing analytical tools such as SSRS, Tableau, and SSAS.
Debug, monitor and troubleshoot BI solutions. Identify root causes of problems, research new solutions, and implement changes in the ETL, data warehouse, and deliverables.
Develop policies and implement controls with the Advancement Data Quality Assurance Analyst to ensure data accuracy, security, and regulatory compliance.
Design and implement complex SQL/MDX that supports the necessary ETL and Data Warehouse processes.
Design, implement, and maintain relational (ROLAP) and multi-dimensional database (MOLAP) models that represent Institutional Advancement's business rules and data.
Configure, deploy and maintain database servers, software, and the appropriate level of access and security.
Champion the use of Business Intelligence tools within the Division. Provide education for functional staff on use, best practices, and self service solutions.
Stay current with new BI tools and trends. Investigate their potential use as time permits.
Design, build, implement and maintain standalone web applications that support workflows within Institutional Advancement.
Manage the selection, purchase, and distribution of personal hardware systems for Institutional Advancement staff, staying within the allocated budget.
Perform other related duties as assigned.
Additional Examples of Duties – if applicable:
Bachelor's Degree in Computer Science, Information Technology or a relevant field of study; two to three years prior work experience providing support in multiple areas of Development and Business Intelligence; database maintenance and design, ETL development, report writing, analytics, server maintenance, and/or web applications development.
Basic understanding of one or more of the following:* Warehouse design and reporting methodologies MVC development methodology Basic database administration tasks including creation, backups, performance management, and security Microsoft SQL Server Administration Server hardware maintenance
Contribute to multiple projects/assignments in a team environment* Identify areas for improvement, participate in problem-solving discussions, and suggest ideas as opportunities arise* Take direction from management in implementing solutions Work from high level requirements through detailed specifications, prototype, deploy, and provide on-going support* Adapt to changing priorities and responsibilities Communicate effectively with both technical and non-technical staff* Apply knowledge of business goals and processes to delivered solutions* Learn and apply new technologies and skills*
Preferred Qualifications – if applicable:
Experience with the Microsoft suite of BI and reporting tools such as SQL Server Reporting Services, SQL Server Analytical Services, Microsoft SQL Server DBMS and Windows Server management. Some experience with Higher Education Institutional Advancement.
Asterisk (*) indicates knowledge, skills, abilities which require assessments
Working Conditions / Physical Requirements:
Light work-Exerting up to 20 pounds of force occasionally, and/or up to 10 pounds of force frequently to move objects. Incumbent must be able to communicate with others. Incumbent may be required to travel from building to building frequently and off campus occasionally.
THIS IS A TERM POSITION AND WILL BE RE-EVALUATED AT THE END OF THE TERM.
Please apply online at jobs.kent.edu and include a resume and cover letter. You will find additional information about the division and a list of current open positions in Institutional Advancement, by visiting our website at:
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.
Kent State University will become a Smoke-Free, Tobacco-Free University effective July 1, 2017. Smoking and tobacco use will not be permitted on any of Kent State's campuses or other locations and properties that are owned, operated, or leased by Kent State, both domestic and international. For additional details, visit www.kent.edu/smoke-free<http://www.kent.edu/smoke-free>.
The intent of this description is to illustrate the types of duties and responsibilities that will be required of positions given this title and should not be interpreted to describe all the specific duties and responsibilities that may be required in any particular position. Directly related experience/education beyond the minimum stated may be substituted where appropriate at the discretion of the Appointing Authority. Kent State University reserves the right to revise or change job duties, job hours, and responsibilities.
Internal Number: 495062
About Kent State University
Kent State University's eight-campus system, among the largest regional systems in the country, serves both the development of a true living/learning approach at the Kent Campus and the regional needs on seven other campuses throughout Northeast Ohio.The Kent Campus provides the resources and facilities of a large, diverse Ohio university, while the Regional Campuses – Kent State University at Ashtabula, Kent State University at East Liverpool, Kent State University at Geauga, Kent State University at Salem, Kent State University at Stark, Kent State University at Trumbull and Kent State University at Tuscarawas - offer the friendly, casual atmosphere of small liberal arts colleges. Today, Kent State has become an engine for economic, cultural and workforce development locally and internationally as one of the premiere Ohio universities. Kent State is ranked among the nation's 77 public research universities demonstrating high-research activity by the Carnegie Foundation for the Advancement of Teaching. The Liquid Crystal Institute, for example, conducts research that translates into technologies used globally in laptops, calculators and flat screen televisions.