Data Analyst II

Primary Responsibilities /Accountabilities/ Essential Functions:

• 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/metadata 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.
•  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.
• Other duties as assigned.

Equipment Used and Responsibility

• 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.

Supervisory Responsibilities

• None

Experience/ Education

• Previous experience and/or education as a Data Analyst Level I.
• Bachelor’s degree from a regionally accredited institution in a related field.
• A minimum of 3 years progressively responsible work experience (1 year Level I plus 2 years’ additional work experience) using CRM preferably in a MS Dynamics or other MS environment, working on increasing more difficult projects, reports, queries utilizing SQL. 
• Java and JavaScript experience is helpful but not required.
• Must successfully pass a background check.

Physical Requirements:

• Sitting:      6-7 hours a day
• Standing:  1-2 hours a day
• Walking:   1-2 hours a day
• Lifting:      Occasionally
• Carrying:   Rarely
• Pushing:    Rarely
• Bending:   Rarely
• Squatting: Rarely
• Kneeling:     Rarely
• Climbing:    Rarely
• Reaching:    Occasionally
• Grasping:     Frequently
• Fine Eye to Hand Coordination:  Continuously
• Driving:       Rarely
• Work Environment:  Office building on site.  Work is performed primarily inside, subject to variations in temperature and weather, equipment noise and dust.