Data Analyst, Admin & Finance — Hybrid Dashboards

University of Massachusetts; Westborough (MA); Hybrid; USD 60,000 - 75,000; Full time

Job summary

The University of Massachusetts President’s Office in Westborough, MA is seeking a Data Analyst to develop analysis, reporting, and dashboard capabilities that support operational and strategic decisions across Administration & Finance.

You will collaborate with data and analytics professionals across the Administration & Finance function to translate requirements into analytics solutions, monitor data quality, and design intuitive dashboards that communicate KPIs and insights to

Qualifications

• BS in Mathematics, Economics, Computer Science, Information Management or Statistics.
• 1-3 years' experience as a data analyst or business data analyst.
• Technical expertise regarding data models, database design development, data mining, and segmentation techniques.
• Experience with data visualization tools (Tableau, Power BI, etc.).
• Advanced skills in creating interactive and visually compelling dashboards and reports that communicate data insights and findings clearly to business stakeholders.
• Strong proficiency in SQL, Excel (Pivot Tables, VLOOKUP, Power Query), Python, or R.
• Knowledge of data governance, compliance, and reporting best practices.
• Strong analytical and problem-solving skills with attention to detail and accuracy.

Responsibilities

• Design, develop, maintain, and enhance dashboards and data visualizations communicating key metrics and trends.
• Analyze complex datasets to identify insights and opportunities for action.
• Acquire, integrate, and prepare data from multiple sources for analysis and reporting.
• Validate data quality and resolve discrepancies with IT and analytics partners.
• Develop KPI calculations, business rules, and reporting methodologies.
• Automate data preparation and recurring reporting processes.
• Collaborate with cross-functional teams to translate requirements into analytics solutions.
• Prepare ad hoc analyses and present findings to managers and leadership.
• Document data sources, calculations, and reporting processes.
• Test new data sources, models, and reporting solutions for accuracy.
• Support special projects and initiatives as assigned.

Skills

SQL

Excel

Python

R

Tableau

Power BI

Data viz

Education

Bachelor's degree in Math/Stats/IT

Master's degree preferred

Tools

Tableau

Power BI

Job description

The University of Massachusetts President’s Office in Westborough, MA is seeking a Data Analyst to develop analysis, reporting, and dashboard capabilities that support operational and strategic decisions across Administration & Finance.

You will collaborate with data and analytics professionals across the Administration & Finance function to translate requirements into analytics solutions, monitor data quality, and design intuitive dashboards that communicate KPIs and insights to