Data Analyst

Job Requisition: JR101823 Data Analyst (Open) Job Posting Title: Data Analyst Department: CC00880 VIMS1 | Office of ITNS Job Family: Staff - Software Programming & Applications Worker Sub-Type: Regular (benefited) Job Requisition Primary Location: Davis Hall Primary Job Posting Location: Posting Location - VIMS Gloucester Job Description Summary: The Virginia Institute of Marine Science (VIMS) has a three-part mission of research, education, and advisory service. Our over-arching goals are to: Make seminal advances in understanding marine systems through research and discovery. Translate research findings into practical solutions to complex issues of societal importance. Provide new generations of researchers, educators, problem solvers, and managers with a coastal and marine sciences education of unsurpassed quality. Unit Mission Statement VIMS Information Technology equips the Institute's research, education, and advisory mission with secure, innovative, and sustainable technology. We empower faculty, staff, and students by delivering reliable infrastructure, modern data and collaboration tools, and responsive support. Through proactive partnership and continuous improvement, we transform technology into a strategic asset that accelerates discovery, learning, and institutional resilience. The Data Analyst supports institutional operations and administrative decision-making through the collection, preparation, analysis, reporting, and visualization of data from enterprise systems and operational data sources. Working under the guidance of senior data and information technology staff, the position transforms data into actionable information that supports planning, management, compliance reporting, and operational effectiveness across the Institute. The Data Analyst assists in developing reports, dashboards, visualizations, and analytical products that help leadership and departments make informed decisions. The position supports data governance initiatives, data quality improvement efforts, metadata management, and reporting processes while ensuring compliance with institutional policies related to privacy, security, and data stewardship. The position serves as a collaborative partner with administrative and academic units to improve data accessibility, reporting capabilities, and business processes through effective use of institutional data resources. Job Description: Required Qualifications Education Bachelor's degree in Information Systems, Data Analytics, Business Analytics, Statistics, Finance, Public Administration, Computer Science, Mathematics, Economics, or a related quantitative field; or an equivalent combination of education, training, and experience. Experience Experience working with structured data, spreadsheets, reports, or administrative datasets through academic, professional, internship, or applied project experience. Experience using Microsoft Excel or similar tools for data analysis and reporting. Experience organizing, validating, and documenting information from multiple data sources. Knowledge, Skills, and Abilities Knowledge of basic analytical and quantitative methods. Ability to collect, organize, validate, and analyze data from multiple sources. Strong attention to detail and commitment to data accuracy. Ability to identify trends, inconsistencies, and opportunities for process improvement. Ability to communicate analytical findings to both technical and non-technical audiences. Strong written and verbal communication skills. Strong organizational and problem-solving abilities. Ability to document business processes, reporting requirements, and data definitions. Ability to work independently and collaboratively in a team environment. Commitment to maintaining confidentiality and safeguarding sensitive institutional data. Preferred Qualifications Education Master's degree in Data Analytics, Business Analytics, Information Systems, Statistics, Public Administration, Higher Education Administration, or related field. Experience Experience using Power BI, Tableau, SQL, Microsoft Fabric, or similar business intelligence and reporting tools. Experience working with administrative, financial, human resources, student, research administration, or enterprise resource planning (ERP) data. Experience in higher education, research institutions, government, nonprofit organizations, or similarly complex organizations. Experience developing dashboards, reports, visualizations, and performance metrics. Experience supporting data governance or data quality initiatives. Knowledge, Skills, and Abilities Familiarity with data dictionaries, metadata management, and data governance concepts. Knowledge of statistical analysis, forecasting, and business intelligence methodologies. Familiarity with SQL query development and relational databases. Knowledge of data visualization best practices. Understanding of institutional reporting and decision-support processes. Salary: Up to $70, 000 commensurate with experience Conditions of Employment This position is funded through continuing Educational & General (E&G) funds and is not term-limited. Hybrid work arrangement may be available in accordance with university and departmental policies. This position is not designated as safety-sensitive. This position is not designated as essential personnel during emergency operations. Duties and Responsibilities Operational and Administrative Data Analysis & Reporting – 45% Analyze operational and administrative datasets to support institutional planning, reporting, and decision-making. Develop recurring and ad hoc reports, dashboards, visualizations, and analytical products. Create summaries, trend analyses, performance indicators, and decision-support materials. Review report outputs for completeness, consistency, and accuracy. Present findings and recommendations in formats appropriate for both technical and non-technical audiences. Support leadership, departments, and project teams by responding to data and reporting requests. Data Collection, Preparation, and Quality Assurance – 30% Collect, compile, clean, validate, and organize data from enterprise systems, databases, spreadsheets, and other institutional sources. Perform data quality reviews and identify inconsistencies, duplicates, missing values, and formatting issues. Support data reconciliation, transformation, and integration activities. Maintain analytical datasets and documentation in accordance with departmental standards. Apply established quality assurance procedures to improve data reliability and usability. Maintain reproducible analytical workflows and supporting documentation. Data Query, Dashboard, and Reporting Tool Support – 20% Develop and maintain basic queries, reports, dashboards, forms, and analytical tools. Assist with testing and validation of new or modified reporting solutions. Gather and document business requirements for reporting and dashboard development. Support maintenance of reporting assets and analytical products. Assist end users in understanding available reports, metrics, and data resources. Develop repeatable procedures and documentation supporting effective use of institutional data tools. Other Duties – 5% Participate in special projects and institutional initiatives. Support continuous improvement efforts related to data management and reporting. Attend training and professional development activities. Perform other duties as assigned by the supervisor. Additional Job Description: Job Profile: JP0109 - Information Technology Specialist II - Exempt - Salary - S10 Qualifications: Compensation Grade: S10 Recruiting Start Date: 2026-06-09 Position Restrictions: Restricted Funds EEO is the Law. Applicants can learn more about William & Mary’s status as an equal opportunity employer by viewing the "Know Your Rights" poster published by the U.S. Equal Employment Opportunity Commission. Background Check: 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. 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. William & Mary and the Virginia Institute of Marine Science (VIMS) are vibrant, innovative and engaged communities and we are delighted about your interest in a career with us. Please be aware Workday has weekly downtimes and will be unavailable Fridays starting at 9:00 p.m. through Saturdays at noon (ET) for scheduled maintenance. During this time, the portal will be closed and will not accept applications. William & Mary offers a competitive range of benefits that support employee well‑being and professional growth, including access to on‑campus fitness facilities, university libraries, and other wellness resources. Educational assistance, professional development opportunities, and a robust holiday schedule are also available. Learn more and explore our comprehensive benefits website.