Vanderbilt School of Nursing needs to improve its data collection, processing, visualization, and reporting capabilities to support enrollment management operations and provide insights for institutional decision-making.
Requirements
- Proficiency in SQL and data visualization tools required
- Expertise in Tableau required, including a deep understanding of front-end usage, configuration, integration, and functional optimization.
- Experience with higher ed ERPs/SIS (PeopleSoft preferred) is required.
- Experience with CRM systems (Slate preferred) for data management and reporting is preferred.
- Experience with Snowflake is preferred
- Knowledge of machine learning and data mining techniques is preferred.
- Proven experience in developing and managing analytical dashboard.
Responsibilities
- Extract, transform, and load (ETL) data from various sources, ensuring accuracy and consistency.
- Develop scripts and workflows to automate data collection and processing tasks.
- Write complex queries and extract data sets from various systems including CRM, SIS, and financial aid systems using query management and ensuring efficient database management and optimization.
- Creates enrollment models, using predictive analysis and descriptive statistics.
- Provide direct, hands-on CRM configuration and troubleshooting through testing, and adjustments to ensure alignment with institutional processes.
- Create visually appealing and interactive dashboards, reports, and presentations using tools such as Slate, Power BI and Tableau, Snowflake.
- Work autonomously to create and manage reports and visualizations in Tableau and Slate, ensuring data integrity through sound data storage technologies.
Other
- Maintain data confidentiality and observe all FERPA regulations while managing data security principles.
- Document progress and evolving needs while managing updates to project plans under the guidance and approval of supervisor, ensuring scope, timelines, and resources remain aligned with organizational expectations.
- 3-5 years of professional experience in data analysis or related field required
- Strong analytical and problem-solving skills, with keen attention to detail.
- Excellent communication and interpersonal skills, with the ability to work collaboratively and independently.