Position provides technical expertise within the research department to produce specifications, documentation, and training in development and structure of the data warehouse, the business intelligence decision support system, and other technical solutions. Serves as the lead department liaison with information technology in implementing and maintaining department technology. Position extracts, transforms, analyzes, and reports institutional data using various software tools and processes to meet reporting needs of the institution. Responsible for the validation of department reports and developing/maintaining reporting standards to ensure data accuracy and report functionality. Collaborates with functional units of the college to improve efficiency, effectiveness, and integrity with regards to data gathering, reporting systems, and analysis.
PRIMARY DUTIES PERFORMED:
Serves as department technical expert by maintaining expertise on current database, business intelligence tools, and other software used within the department.
Provides analysis, solutions, and training for the department on use of software and other technology.
Provides department leadership in identifying technical solutions to address current needs and to increase department efficiency and effectiveness.
Responsible for the extraction and transformation of data using programming techniques from multiple data sources for use as research data sets.
Creates, designs, modifies, and presents dynamic reports to support college and department level planning, enrollment management, compliance, accreditation, and decision making.
Provides leadership in projects that support the comprehensive online reporting systems and web-based communication tools.
Validates department reports before they are published to maintain and improve access to the reporting system and availability of accurate reports.
Develops and maintains standard operating guides for department report development and validation.
Develops, manages, coordinates, and completes research and data analysis with regard to academic and institutional policy analysis.
Works collaboratively with college stakeholders to analyze specifications and design reports using report writing tools and other data reporting methods.
Collaborates with Information Technology to develop and maintain the technical architecture necessary for report writing.
Provides leadership in the evaluation and preparation of solutions to address data quality based on requirements for data accuracy and completeness.
Explores additional uses for data that allow College departments to work more effectively and to support the College’s commitment to data-informed decision making.
Develops, maintains, and updates queries and reports to fulfill recurring data needs for internal and external reporting requirements. Responsible for monitoring, maintaining, and updating historical analytical reports. When necessary, converting historical static analytical reports into dynamic web-based reports using report writing tools.
Provides technical expertise to develop and provide training to faculty and staff with regard to the College’s business intelligence system.
Collaborates with functional area experts to automate current data gathering and reporting systems.
Responsible for maintaining confidentiality and professionalism when dealing with sensitive employee data.
Conducts research and analysis of external conditions that impact the College.
Performs other job related duties as assigned.
Any combination of education and experience that provides the required knowledge and abilities. Examples: A bachelor’s degree and five (5) years of relevant full-time experience or a Master’s degree and two (2) years of relevant full-time experience.
Ability to lead development and implementation of projects to support the comprehensive online reporting systems.
Ability to analyze operational data requirements and to create and develop database specific requirements.
Ability to evaluate data quality and prepare solutions based on requirements for data accuracy and completeness.
Demonstrated knowledge of technical documentation requirements.
Demonstrated knowledge of current software and technical solutions in database and research areas.
Experience in report development using business intelligence tools (e.g., Brio/Hyperion/Oracle, Crystal Reports, SAS, IBM Cognos, Argos).
Demonstrated history of knowledge and skill improvement through continuing education, training, and/or self-directed learning in related technology areas.
Strong knowledge of database construction and management.
Ability to draw conclusions and make recommendations based on research data and findings.
Ability to gather and analyze statistical data and generate reports.
Skill in collecting, analyzing, verifying, and manipulating research data.
Excellent project management, communication, teamwork, and interpersonal skills.
Ability to work effectively with a wide range of constituencies in a diverse community.
Ability to work with minimum direction in a complex environment, quickly solving problems and learning new skills as technical challenges arise.
Experience with Oracle and writing complex queries using SQL.
Expertise with IBM Cognos 10/11.
Experience with Enterprise Resource Management systems (e.g., Banner,
Experience in higher education with an emphasis on institutional reporting
and/or institutional research.
Excellent understanding of business intelligence and data warehousing
Special Instructions to Applicants
This position will be located at the Forest Park campus.