We are seeking a detail-oriented and analytical Data Analyst to support our Faculty Services team by ensuring the integrity, accuracy, and effective use of critical data across systems. In this role, you will develop reports, dashboards, and data processes, while partnering cross-functionally with teams such as IT, Finance, and Marketing to drive data-informed decisions and improve workflows. You will play a key role in maintaining data quality, supporting CRM systems, and translating complex data insights into actionable recommendations that enhance operational performance. This position is ideal for a proactive problem-solver with strong technical skills and a passion for continuous improvement in a collaborative environment.
ESSENTIAL DUTIES and RESPONSIBILITIES: Include, but are not limited to, the following:
Retrieves data from internal and external systems and ensures accuracy through the development of reports, data analysis and resolution of issues prior to submission/transfer for processing.
Develops queries, reports, dashboards and processes to continuously monitor data/meta data quality and integrity.
Audits and maintains data quality/business processes/process documentation within various corporate databases and applications.
Assesses the business requirements for Faculty Services, automates processes and workflows and expands or modifies software to serve new purposes or improve workflow or fit-for-use.
Analyzes, interprets and communicates data performance metrics and feedback collection.
Reviews and controls data to ensure ongoing accuracy and consistency within Faculty Services.
Designs and integrates business processes and data flows between CRM/xRM and other applications.
Assists in designing operational dashboards for management.
Implements and deploys various applications as identified by management to maximize value.
Works with stakeholders, faculty support groups, business development, legal, finance, IT and marketing/management teams on multiple projects, defining business requirements, coordinating system builds / customizations, reporting and data clean up.
May use or rely on SQL tutorials for adjusting software and writing queries.
Works on less complex projects and issues.
Has a basic understanding of and proficiency with MS Dynamics/MS CRM and related developer tools.
Has a basic understanding of department processes and policies and processes of related departments including Faculty Development.
Learning to add value in order to operate independently.
Works under limited supervision.
Provides expertise to other teams including data administration and source based data analysis.
Works independently on regular duties under general supervision, referring issues beyond scope of authority to management.
Performs root case analysis on data and identifies approaches to resolve.
Performs complex data analysis and report creation.
Takes the lead in customizing reports and software user needs and refers software programming issues to xRM department.
Has a greater understanding and knowledge of departmental policies and processes, related department programs and University policies.
SUPERVISORY RESPONSIBILITIES: None
QUALIFICATIONS: The requirements listed below are representative of the knowledge, skills, and/or abilities required to successfully perform the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Knowledge, Skills and Abilities:
Must be highly proficient at Microsoft Excel with ability to manipulate delimited files using T-SQL.
Analyst skills using SQL, MS Excel, MS Access.
Basic math aptitude and understanding and an understanding of statistics.
Well versed in creating meaningful reports and dashboards.
Good understanding of end to end business processes.
Highly detail oriented with strong analytical and planning abilities
Self-motivated and results oriented.
Good interpersonal skills with ability to work well in a team environment.
Familiarity with Customer Relationship Software and developer tools.
Must pass a pre-employment background investigation.
Education and/or Experience:
Bachelor’s degree from a regionally accredited institution in a related field.
Work experience in higher education preferred.
An equivalent combination of education and relevant work experience and education may be substituted upon supervisor’s approval.
A minimum of 1 year related work experience involving data manipulating, data governance, query and report writing, SQL, database administration or similar.
Experience with supporting/launching/configuring/testing a CRM-based system is helpful.
#INDLOPESUP
