The Senior Data Solutions Analyst is part of the Office for Planning and Institutional Effectiveness (PIE) at Vanderbilt University and is a key contributor, utilizing institutionally designated approaches and technologies to ensure successful delivery of high-quality and relevant data solutions to meet consumer needs. Reporting directly to the Associate Director, the position is responsible for performing complex project and analytical work in a wide range of business intelligence activities that ensure the uniformity, accuracy, and semantic consistency of enterprise data through the application of effective data management, security, stewardship, and governance processes.
The Senior Data Solutions Analyst works in partnership with other team members as well as the broader PIE Team. They are highly proficient in utilizing Business Intelligence (BI) tools and knowledgeable of university data; performing assigned activities such as defining data requirements, designing data models, building dashboards, writing BI reports, and performing ad-hoc analysis to assist consumers in achieving operational and strategic goals. They provide less experienced analysts guidance and mentoring in all aspects of BI development and solutions. The position also partners closely with information technology to build out our data warehouse and create metadata reporting solutions. The position may also employ predictive modeling and analytics techniques to aid decision making in areas of strategic interest to the university administration.
The Office for Planning and Institutional Effectiveness (PIE) partners with leaders in Academic Affairs and beyond to support decision-making, planning, and action based on high-quality and relevant data, information, and analysis. The Office comprises four teams: Partnering; Institutional Research and Analysis; Assessment; and Data Governance and Solutions.
The Senior Data Solutions Analyst is part of the Data Governance and Solutions team. Data Governance and Solutions is a key driver in efforts to improve and enhance data quality and analytics in support of data-driven decisions that affect students, both current and future.
Duties and Responsibilities
Business Intelligence Tools: Uses BI tools such as Oracle Business Intelligence, Tableau, and SQL Developer to provide complex reporting solutions to meet consumer data needs.
Develop new analytics solutions; support and maintain existing solutions.
Perform testing and evaluation of new BI analysis and reporting solutions, tool upgrades, enhancements, and change requests.
Identify existing solutions or design new solutions that satisfy information requests.
Develop and maintain database tables for use in reporting.
Recommend standardized practices in developing data solutions.
Explore new techniques and technologies in BI to generate new ideas and insightful analytics.
Support other team members through organized training and on-going knowledge transfer.
Fulfill Report Requests:Successfully delivers reporting solutions through detailed analyses of reporting needs.
Participate in requirements gathering and analysis, technical design, building, testing, and documentation of data solutions.
Develop and adhere to official definitions and PIE standards in reporting.
Present information in a clear, concise, and understandable format.
Contribute to the compliance of Federal reporting (IPEDS) and external agency reporting (e.g. College Board, U.S. News and World Report).
Assist with updating publicly available data such as the VU Factbook and Common Data Set annually.
Data Analysis: Designs logical data models of moderate complexity. Identifies redundant data objects and data items that can be re-used across applications. Identifies gaps in data or object models, recommends appropriate changes, and creates transformation requirements.
Develop an in-depth understanding of the functional data environment.
Thinks beyond the obvious when analyzing data.
Use reports and analyses to identify potentially problematic data and recommend possible solutions.
Collaborate with consumers to improve data quality and consistency.
Use knowledge of data systems to provide highly accurate and timely data solutions.
Use analytic techniques to develop test cases for report, analysis, and data warehouse changes.
Maintain data confidentiality and observe all FERPA regulations.
Internal Number: 2001063
About Vanderbilt University
Vanderbilt University is a center for scholarly research, informed and creative teaching, and service to the community and society at large. Vanderbilt will uphold the highest standards and be a leader in the quest for new knowledge through scholarship, the dissemination of knowledge through teaching and outreach, and the creative experimentation of ideas and concepts. In pursuit of these goals, Vanderbilt values most highly intellectual freedom that supports open inquiry, equality, compassion, and excellence in all endeavors.