Data Analyst/Database Administrator

Belmont College•St. Clairsville, OH

1d•Onsite

About The Position

The Institutional Research Data Analyst/Database Administrator is directly responsible for the Administrative Information Systems under the supervision of the Executive Vice President/COO/ALO. The Administrator plays a major role in making sure that the technologies provide users with flexibility in the management, access, retrieval, sharing and configuration of the data, systems analysis, and ensures the consistency and integrity of data. This professional staff position requires working knowledge of departmental functions with user areas being supported by the AIS and maintain SQL functions, responsibility in coordinating the computer programming and operations staff in daily application execution and development.

Requirements

Considerable experience in data analysis and reporting, general computer operations, SQL and Microsoft Access, and reporting software and implementation.
Minimum of a bachelor’s degree preferred. Any equivalent combination of certifications and education which provides the required knowledge, skills, and abilities to perform the duties.
Thorough knowledge of high-level computer programming languages and data base procedures.
Good computer operations background.
Familiar with how to back up and restore data from a server.
Understands the business processes and applications being modeled by the database management system.
Thoroughly versed in relational database design.
Knowledgeable in SQL.

Nice To Haves

Prior experience and knowledge of Jenzabar is a plus.
Experience in higher education preferred.

Responsibilities

Assume all decision-making responsibilities in the absence of the Director of IR.
Develop database solutions that satisfy the users need for high-speed access, multiple views of the same information, accuracy and security, and the sharing of information.
Set administrative information systems task completion priorities.
Oversee and produce reports/files for the data reporting to all internal users and external agencies.
Design and implement new application programs, processes, reports, or various file extracts for administrative use.
Determine best methodology to complete client projects, with limited assistance.
Conduct performance tuning of queries, reports and interfaces.
Acquire knowledge of the data to provide data conversions, data mapping, data manipulation, and data mining.
Understand key business processes and make recommendations for change based on system functionality.
Identify risks and data issues.
Provide database day-to-day maintenance, support, and troubleshooting.
Talk with appropriate administrators to determine informational needs, data flows and systems definitions.
Develop proper documentation procedures to assist the operations staff’s application program execution.
Provide database security techniques that users can only be allowed access to specific data elements that are relevant to that user’s needs.
Provide programming and systems analyst support for all Administrative Information systems.
Manage ad-hoc reporting requests and write queries to deliver the required data.
Develop and maintain stored procedures.
Database scripting.
Assist with software updates released by the Administrative System software provider. This will ensure that the college is current with all changes made to the application software.
Provide day-to-day advice to users on data structures and terminology.
Provide training and support to users as needed to effectively deploy and support applications and database functions.
Provide help in creating new tables within the database system for users as needed.
Help create and maintain user-specific views within database system in relation to institutional dashboards.
Stay up to date on required internal and external reporting responsibilities.
Maintaining and creating interfaces between the various databases to connect them to Jenzabar One.
Perform other duties and activities as assigned.