Job Description

Position Summary:

The Data Analyst will have strong technical and financial understanding to handle data preparation and integration, develop custom calculations, and implement best practices for optimal dashboard performance and user experience. Strong data interpretation and problem-solving skills are required. Proficiency in SQL, Alteryx, Tableau Prep, Tableau, and Excel is essential.

Additionally, the analyst will:

• Translate data insights into clear, actionable recommendations
• Develop technical and functional documentation
• Stay updated with the latest trends and best practices in data management and analytics
• Develop reports and dashboards
• Provide training and support to team members

This position requires effective communication and collaboration skills to work across university organizations and deliver data solutions to drive impactful insights for University Finance and Administration. Strong interpersonal skills, including teamwork, adaptability, and the ability to communicate complex data concepts to non-technical stakeholders, are essential.

Data Collection and Cleaning:

• Gather data from various sources, including databases, disparate systems, and external datasets.
• Combine these into meaningful datasets and develop analytical workflows to optimize data acquisition, analysis, and reporting processes.
• Collaborate with subject matter experts (SMEs) to identify key information in raw data and create solutions to extract this information from formats like SQL tables, Tableau datasets, and other structured metadata sources.
• Ensure data quality by removing inaccuracies, duplicates, inconsistencies, and prepare datasets ready for reporting and analytics.

Data Analysis :

• Use statistical methods and tools to analyze data, identifying trends, patterns, and correlations.
• Develop and present reports, dashboards, and visualizations to communicate findings to stakeholders.

Data Interpretation:

• Translate complex data into understandable insights to inform business decisions.
• Develop lasting technical solutions using tools like Alteryx, Tableau Prep, Tableau, and Excel, focusing on effective integration, sustainability, and scalability.

Collaboration and Consultation:

• Work with teams across Rutgers University, such as OIT, CLUs, Business Managers, and Campus Leaders, to understand their needs and provide relevant datasets and insights.
• Collaborate closely with University Finance stakeholders on data analysis, including confidential data, and offer recommendations for gathering, analyzing, interpreting, and reporting data.

Data Management:

• Maintain databases and ensure data security and integrity.
• Design data modeling and analysis services to mine various systems and applications, build, deploy, and maintain data support tools, metadata inventories, and database file/table creation definitions.
• Develop data models that will increase the efficiency and usability of data for dashboards and related analytic tools.

Predictive Analysis:

• Use data modeling techniques to forecast future trends and outcomes.
• Develop and implement statistical, machine learning, and heuristic techniques to create descriptive and predictive analytics.

Continuous Improvement:

• Stay updated on the latest trends and best practices in data analytics and higher education.
• Continuously seek opportunities to improve data processes and tools to better support Rutgers University and the Finance and Administration team.
• Provide and update technical and non-technical documentation.

Someone who has worked in a Higher Education setting within a Finance department would be perfect for this role.

Job Tags

Similar Jobs