Data Analyst, Administration & Finance

UMass President's Office; Boston (MA); Hybrid; USD 60,000 - 75,000; Full time

Job summary

UMass President's Office is seeking a Data Analyst to develop analysis, reporting, and dashboard capabilities that support operational and strategic decision-making across Administration & Finance.

The role collaborates with data teams, translates business requirements into analytics solutions, ensures data quality, and designs dashboards that communicate KPIs and trends to leadership. Hybrid work from Westborough, MA with occasional campus travel.

Qualifications

• BS degree in mathematics, economics, computer science, information management or statistics.
• 1-3 years' experience as a data analyst or business data analyst.
• Proficiency in SQL, Excel, and at least one data visualization tool (Tableau/Power BI).
• Knowledge of data governance, compliance, and reporting best practices.

Responsibilities

• Design, develop, maintain, and enhance interactive dashboards and data visualizations communicating KPIs, trends, and insights.
• Analyze complex datasets to identify trends, anomalies, and opportunities.
• Acquire, integrate, and prep data from multiple sources for analysis and reporting.
• Validate data for accuracy and consistency; resolve issues with IT partners.
• Develop KPI calculations, business rules, and reporting methodologies.

Skills

SQL

Excel

Python

Tableau

Power BI

Data governance

Analytical thinking

Education

BS in Mathematics, Economics, Computer Science, Information Management or Statistics

Master's degree in a related field

Tools

Tableau

Power BI

SQL Server

Job description

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.

Additional Details:

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