Database and Data Analyst

Description

At Westminster College, we believe in immersive and enriching experiences that inspire creative thinking and problem solving. We believe in creating opportunities for several different paths to success over a lifetime and the potential to make an impact from wherever you are. For our students, we do this by providing real-world, hands-on learning opportunities, small class sizes, and talented professors dedicated to the individual. Our employees often remark that our tight-knit community creates an atmosphere fostering campus involvement that adapts to all interests. As a result, Westminster continues to be recognized for its excellence in higher education as one of the best small liberal arts colleges in the Midwest.

The Database and Data Analyst oversees day-to-day operations for the Jenzabar administrative computing system, PowerFAIDS financial aid system, and other SQL Server applications used by various campus departments. Working closely with the Director of Enterprise Research & Data Applications and other IT professionals, the Database and Data Analyst performs directed tasks to maintain SQL Server-based applications through script and report development. The Database and Data Analyst will also be responsible for providing data driven solutions to help make evidence-based solutions at the institution. 

Requirements

Essential Functions:

• Perform scheduled transfers of data between servers, automating systems as possible 
• Assist with all software (Jenzabar, PowerFAIDS, etc.) installations, upgrades, and work orders
• Develop and maintain forms, workflow, and automations to enhance departmental processes 
• Develop and deliver documentation and training for all relevant systems and end users
• Develop, troubleshoot, and maintain Enterprise Reports using InfoMaker and SQL Server Reporting Services 
• Develop, and maintain stored procedures, triggers and batch files 
• Create Reports and Dashboards to develop and present actionable insights
• Assist in gathering and preparing data for various mandatory and internal reporting.
• Collaborate with a variety of stakeholders to gather requirements and deliver relevant solutions
• Other duties as assigned

Job Requirements:

Education: Bachelor’s degree required. Degree in computer science, data analytics, or related degree is preferred. Combination of education degree and years of relatable experience may be considered.

Experience:   

• Two or more years of experience with MS SQL Server and SQL applications
• Strong interpersonal, verbal, and written communication skills 
• Ability to work independently while meeting well-defined deadlines 
• Familiarity with Jenzabar or a similar administrative computing system 
• Experience writing SQL queries and/or reports 

Additional Experience Preferences: 

• Two years of experience with Jenzabar
• One year of experience with Infomaker/SSRS report writing 
• One year of experience with Power BI or other visualization software
• Two years of experience in an academic environment 
• Previous experience developing user documentation 

Skills:

•  Proficient in MS SQL Server 
• Strong interpersonal, verbal, and written communication skills
• Strong analytical, problem-solving skills and attention to detail
• Familiarity with data visualization tools such as Power BI or SSRS
• Strong aptitude for learning new tools and technologies

Benefits:

• Medical, dental, and vision options
• Health Savings Account and/or Flex Spending Account
• Supplemental options: Short-term disability, Hospitalization, Accident, and Critical Illness
• Stand-alone EAP program
• Life, AD&D, and long-term disability
• Retirement 403(b) plan
• Tuition remission or exchange programs
• Sick and Vacation time
• Paid Holidays (15+ each year)

Westminster College encourages and gives full consideration to all applicants for admission, financial aid, and employment. The College is committed to creating a diverse environment and is proud to be an equal opportunity employer. The College does not discriminate in access to, treatment of, or employment in, its programs and activities on the basis of race, color, age, religion, sex, gender, sexual orientation, gender identity or expression, national or ethnic origin, citizenship, veteran status, marital status, disability, or genetic information.

Inquiries about compliance with this prohibition should be directed to:

Associate Vice President & Chief HR Officer/Title IX Coordinator

501 Westminster Ave, Washington West, 2nd floor

Fulton, MO 65251

HR@Westminster-mo.edu

573-592-5226