City of Worcester · 10 hours ago
DATA ANALYST
Worcester, MA
Full-time
Onsite
Mid, Senior Level
$81K/yr - $106K/yr
5+ years expThe City of Worcester is seeking qualified applicants for a Data Analyst position in the Innovation and Technology Department. The Data Analyst supports city-wide efforts in transparency, data-driven decision-making, and operational efficiency.
Customer ServiceFinanceGovernmentNon Profit
Responsibilities
Design and implement data models and analysis services to support city-wide initiatives
Develop and maintain dashboards and reports using BI tools (e.g., Power BI, ArcGIS Dashboards)
Collaborate with departments to identify opportunities for data-informed decision-making
Support the development and enforcement of data governance and privacy policies
Manage and maintain spatial and non-spatial datasets, including ETL processes
Support and expand the City’s Open Data Portal and ArcGIS Hub
Support delivery of ArcGIS-based services
Automate data workflows and ensure data quality, consistency, and integrity
Coordinate with IT and non-IT staff to integrate data solutions with existing systems
Monitor and optimize database performance, including stored procedures and execution times
Work with stakeholders to define data needs and translate them into technical solutions
Provide training and documentation to ensure effective use of data tools
Communicate findings clearly through visualizations, reports, and presentations
Qualification
Required
Strong understanding of data modeling, database structures, and data management practices
Proficiency with Esri software (ArcGIS Desktop, ArcGIS Online, ArcGIS Portal)
Proven ability to consult with key business stakeholders to develop meaningful metrics leading to actionable operational insights
Ability to automate data workflows and ensure data quality, consistency, and integrity
Ability to monitor and optimize database performance, including stored procedures and execution times
Strong communication, problem-solving, and documentation skills
Ability to translate stakeholder needs into technical solutions
May occasionally do presentations in meetings as needed
Regular onsite attendance is required
Ability to work collaboratively across departments and technical teams
Valid Driver's License and access to reliable transportation
Bachelor's degree in Computer Science, Statistics, Geography, or a related field; OR an equivalent combination of education, training and five (5) years of related experience which provide the required knowledge, skills and abilities to perform the required duties of the position will be considered in lieu of the above-mentioned requirements
Three (3) years of experience with business intelligence tools
Experience with Esri software (ArcGIS Desktop, ArcGIS Online, ArcGIS Portal)
Two (2) years of experience designing and implementing ETL (Extract, Transform, Load) workflows using Python, including data cleaning and transformation
Two (2) years of experience with BI platforms such as Power BI or Tableau
Excellent communication skills
Preferred
Master's degree in Computer Science, Statistics, Data Analytics, Geography, or a related field
Knowledge of JavaScript or Esri API toolkits
One (1) year of experience with data privacy, governance, and metadata management
Project management experience and ability to lead cross-departmental data initiatives
Direct professional experience within the past two (2) years developing complex ETL processes using tools such as SSIS or Azure Data Factory
Direct professional experience within the past two (2) years, and proficiency in creating advanced analytics solutions, such as dashboards, from disparate data sources, including predictive modeling and trend analysis, using Power BI or equivalent platforms
Experience in designing data models and ensuring data quality and governance standards
Benefits
Excellent benefits package
Company
City of Worcester
Since its incorporation as a city in 1848, the City of Worcester is governed by a Council-Manager, or Plan E, form of government with a popularly elected Mayor, 11 City Council Members and a City Manager.
1001-5000 employees
H1B Sponsorship
City of Worcester has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)
2023 (1)
Funding
Current Stage
Late StageLeadership Team
Timothy McGourthy
Chief Financial Officer
Andrew Taylor
Assistant Chief Development Officer - Grants Management & Compliance
Recent News
2025-11-08
Company data provided by crunchbase