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.
Characteristic Duties and Responsibilities:
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.
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.
Preferred Qualifications: 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.
Basic understanding of one or more of the following:* o Warehouse design and reporting methodologies o MVC development methodology o Basic database administration tasks including creation, backups, performance management, and security o Microsoft SQL Server Administration o Server hardware maintenance
Analyzing and organizing information and data*
Written and verbal communication
Technical writing and documentation*
Development of complex queries for relational and multidimensional databases (SQL/MDX)*
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*
Assessments: Asterisk (*) indicates knowledge, skills, abilities which require assessments.
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.