What are the responsibilities and job description for the Data Analyst position at William & Mary?
Position Information
Position Number
00684W
Position Title
Data Analyst
Employment Category
Full Time Operational
Location
William & Mary
Department
3L2000 School of Business - Administration
Unit Mission Statement
The mission of the Mason School of Business at William & Mary is to serve the Commonwealth, the nation, and the global community both by offering high-quality educational programs at the undergraduate, graduate, and professional levels and by creating and communicating new knowledge.
Position Summary
Reporting to the Director of Financial Planning and Data Analysis, the Data Analyst is an integral part of the Finance and Administration Team responsible for data gathering, analysis, modeling, and reporting design that yields solutions to support the Raymond A. Mason School of Business’s data-driven decision-making. The Data Analyst will focus on data quality and data governance while working closely with leadership and nontechnical colleagues to implement predictive modeling, reporting, and data integrity policies and procedures that inform data-driven strategies across the school.
The Data Analyst will work to develop and enhance new predictive models from databases including those pertaining to CRM systems, academic programs, and financial databases. These models will inform decisions for enrollment and program strategies across the school. The Data Analyst is also responsible for updating and maintaining code, developing and documenting data methodologies and metrics, and promoting process and data improvement.
Responsibilities include but are not limited to:
Responsibilities include but are not limited to:
- Gathering and analyzing data requirements and data flows across systems and transforming data requirements into data models.
- Translating and architecting gathered requirements into visualizations.
- Developing dashboards and reporting methodologies and training end-users in their use.
- Developing and presenting reports that are understandable by non-technical users, enabling stakeholders to make important decisions based on facts and trends.
- Recommending re-engineered business processes and/or system modifications and supporting data governance strategies.
- Teaching data management and data governance best practices across all Mason School of Business units.
Conditions of Employment
- This position may require additional hours beyond the typical work week, including occasional overnight and weekend work, and/or overnight travel, as needed to meet the business needs of the operation.
- Information Security: This position requires administrative access to the University’s information systems and/or sensitive University data. The incumbent is expected to be aware of and adhere to the Information Security policies of the University as well as all applicable federal, state, and local laws. Additionally, the incumbent is expected to follow information security best practices applicable to their job area and to pursue information security training and awareness opportunities when possible.
Essential Designation
No
FLSA
Exempt
Position Restricted?
No, this is a continuing E&G funded position and not term-limited
Position Term
12 month - Continuing
Position Months
Faculty or Staff: 12 month
Required Qualifications
- Bachelor’s degree or an equivalent combination of education, training, and experience.
- Knowledge of applied statistics, business intelligence, and information systems; advanced practical/applied experience with relational data structures, databases, and data management principles, and knowledge of SQL programming, and standard data management operating processes and expectations.
- Demonstrated ability to provide reporting, predictive analytics, and other data solutions to answer questions or offer forecasting data for enrollment and other operational performance metrics.
- Experience in building and using relational databases and large data sets, using query tools to create and improve reports.
- Experience conducting and documenting needs assessments related to data requests.
- Experience with converting data results into data stories to ensure accurate end-user interpretation of results.
- Advanced proficiency using Excel and PowerPoint for presentations.
- Strong interpersonal and communications skills and the ability to work collaboratively with technical and non-technical team members to effectively support business users in a professional manner.
Preferred Qualifications
- Master of Science in data science, data analytics, or business administration.
- Progressively responsible experience as a statistician or reporting analyst in a higher education or non-profit environment (typically 2 years).
- Experience working with the Ellucian Suite or other enterprise-wide systems. (Examples: Banner, Salesforce, Slate, Blackbaud, Learning Management Tools).
- Experience using SQL Developer; as well as Qlik, SAS, or similar enterprise reporting tools.
- Experience with data definition development, data modeling, data quality, and organizational alignment.
- Experience presenting analytics outcomes to senior management and the ability to elicit cooperation across multiple levels of an organization.
Is the position remote work eligible?
Hybrid (works remotely at least 1 day per week but not full-time)
Remote Work Disclaimer
Remote work eligibility is not guaranteed and is subject to approval. Employee eligibility depends on the likelihood of the employee succeeding in a remote work arrangement and the supervisor’s ability to manage remote workers. Departments and/or Human Resources may amend, alter, change, delete, or modify eligibility.
Advertised Pay Range
up to $75,000
Advertised Pay Range Statement
All hiring rates are commensurate with relevant experience up to the advertised amount considering internal alignment.
University Salary Range
U11
Benefits Summary Statement
William & Mary offers our employees a full array of benefits including retirement, health insurance with options for expanded dental and vision along with group and optional life insurance with coverage for spouse and children, flexible spending accounts, and an EAP (Employee Assistance Program).
Our employees enjoy additional university benefits such as educational assistance, professional development, wellness benefits, and a robust holiday schedule. All employees have access to fitness facilities on campus. Staff members also have access to the university libraries, and much more. To learn more, go to: https://www.wm.edu/offices/uhr/benefits/index.php?type=none
Our employees enjoy additional university benefits such as educational assistance, professional development, wellness benefits, and a robust holiday schedule. All employees have access to fitness facilities on campus. Staff members also have access to the university libraries, and much more. To learn more, go to: https://www.wm.edu/offices/uhr/benefits/index.php?type=none
Job Open Date
12/03/2024
Review Begin Date
01/03/2025
Job Close Date
Open Until Filled
Yes
Special Application Instructions
Background Check Statement
William & Mary is committed to providing a safe campus community. W&M conducts background investigations for applicants being considered for employment. Background investigations include reference checks, a criminal history record check, and when appropriate, a financial (credit) report or driving history check.
EEO Statement
William & Mary values diversity and invites applications from underrepresented groups who will enrich the research, teaching and service missions of the university. The university is an Equal Opportunity/Affirmative Action employer and encourages applications from women, minorities, protected veterans, and individuals with disabilities.
Salary : $75,000
