Data Analyst, Administration & Finance

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

Data Analyst, Administration & Finance

Job no: 530239
Position type: Staff Full Time
Campus: UMass President's Office
Campus Location: Westborough
Department: A&F Support Services Team
Categories: Business & Financial Services, Analytics/Programming/Data, Procurement
Advertised: Sep 04 2026 Eastern Daylight Time
Applications close:

Pay Range:

The UMass President’s Office expects to pay within an approximate hiring range between $60,000 - $75,000 for this position. The specific pay for this position will be determined by the University based on consideration of all relevant factors when and if it decides to extend an offer of employment.

Primary Work Location:

Westborough, MA. Hybrid schedule.

Job Summary:

Reporting to the Assistant Vice President of Administration & Finance Support Services (Access) Team, the Data Analyst is responsible for developing analysis, reporting, and dashboard capabilities that support operational and strategic decision-making across Administration & Finance.

The Data Analyst will collaborate with data and analytics professionals across the Administration & Finance function, as well as product owners/stakeholders, and A&F leadership, to understand business requirements and translate them into effective analytics solutions. The position will monitor data quality and performance, validate data for accuracy and consistency, and identify opportunities to strengthen reporting processes and controls.

Working closely with IT and other technical partners, the Data Analyst will support the development of data models and the automation of data workflows and reporting processes to improve efficiency, scalability, and reliability. The position is also responsible for designing and developing intuitive, insightful dashboards, reports, and presentations that effectively communicate key performance indicators (KPIs), trends, and actionable insights to stakeholders and leadership.

Essential Functions:

• Design, develop, maintain, and enhance interactive dashboards and data visualizations that effectively communicate key metrics, trends, and insights.
• Analyze complex datasets to identify trends, patterns, anomalies, and opportunities, and translate findings into meaningful and actionable insights.
• Acquire, integrate, and prepare data from multiple sources for analysis and reporting.
• Perform data validation and quality assurance to ensure the accuracy, completeness, and consistency of data; investigate discrepancies and collaborate with IT and other technical partners to resolve data issues.
• Develop and maintain KPI calculations, business rules, and reporting methodologies to ensure consistent and accurate reporting.
• Identify opportunities to streamline and automate data preparation, validation, and recurring reporting processes to improve efficiency and reduce manual effort.
• Collaborate with cross-functional teams and stakeholders across Administration & Finance to understand business requirements and develop appropriate analytical solutions.
• Conduct ad hoc analyses and prepare reports, presentations, and analytical summaries that clearly communicate findings to managers and leadership.
• Maintain documentation of data sources, calculations, business rules, reporting processes, and identified data issues and resolutions.
• Perform testing and validation of new data sources, data models, system enhancements, and reporting solutions to ensure accuracy and alignment with business requirements.
• Perform other related duties and support special projects and initiatives as assigned.

Other Functions:

Perform other duties as may be assigned.

Minimum Qualifications (Knowledge, Skills, Abilities, Education, Experience):

• 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 the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Adept at queries, report writing, and presenting findings.

Preferred Qualifications (Knowledge, Skills, Abilities, Education, Experience):

• Master’s degree in a related field

Working Conditions:

• Hybrid work environment. Primarily located at the UMass President’s Office located at 50 Washington St., Westborough, MA with remote work.
• Must be able to travel occasionally to all UMass campuses and the Boston central office.

All offers are contingent on the successful completion of a background check.

The University of Massachusetts President’s Office welcomes all qualified applicants and complies with all state and federal anti-discrimination laws.