Data Analyst, Administration & Finance

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

Job summary

The Data Analyst at UMass President's Office will develop analytics, dashboards, and reporting capabilities to support operational and strategic decisions across Administration & Finance. You will collaborate with data professionals, stakeholders, and leadership to translate requirements into scalable analytics solutions.

You will monitor data quality, validate accuracy, and design data models and automated workflows to improve efficiency and communicate KPIs and trends clearly to managers.

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 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.

Responsibilities

• 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.

Skills

SQL

Excel

Python

R

Data analysis

Communication

Education

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

Tools

Tableau

Power BI

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.