Data Analyst I

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