Senior Data Process Systems Analyst (Information Systems)

Boston; Boston (MA); On-site; USD 90,000 - 120,000; Full time

Job summary

The City of Boston Assessing Department seeks a Senior Data Processing Systems Analyst to lead technical administration and improvements for its CAMA, Abatement/Exemption Workflow, and 3ABC Online Filing applications. The role emphasizes data integrity, reporting, and reliable analytical solutions for annual tax billing and valuation processes.

The ideal candidate will have strong SQL Server, Access, and Excel skills, with demonstrated ability to translate business requirements into effective

Qualifications

• Bachelor's degree or equivalent professional experience in IT.
• 4 years of full-time (or equivalent) experience in systems analysis, database administration, or related IT role.
• Proficiency with Microsoft SQL Server, Microsoft Access, and Microsoft Excel.
• Excellent accuracy, attention to detail, and problem-solving skills.
• Strong organizational, written, and verbal communication abilities.
• Ability to manage multiple priorities and provide outstanding customer support.

Responsibilities

• Maintain, support, troubleshoot, and enhance the department's business applications including the CAMA system and related applications.
• Support lifecycle activities: requirements gathering, configuration, testing, upgrades, documentation, and training.
• Develop test plans, perform system testing, identify defects, and coordinate resolution before production.
• Collaborate with vendors, DBAs, and IT staff to implement new functionality and integrations.
• Analyze workflows and recommend technology solutions to improve efficiency and accuracy.
• Provide advanced technical support and resolve issues in a timely manner.
• Assist with data preparation for annual property tax billing and public reporting.

Skills

SQL Server

Microsoft Access

Excel

Data analysis

Troubleshooting

Education

Bachelor's degree in computer science, information technology, or related field

Tools

CAMA system

Abatement/Exemption Workflow

3ABC Online Filing Application

Job description

The mission of the City of Boston Assessing department is to accurately collect data, assess property at its full and fair cash value, and provide prompt and courteous service to the public. The Assessing department is a leader in municipal valuation and seeks to maintain that status by attracting talented, experienced staff to our core staffing.

The Senior Data Processing Systems Analyst reports to the Director of Information Systems and serves as the department's key technical resource responsible for the administration, support, enhancement, and continuous improvement of the Assessing department’s business applications, databases, and technical infrastructure.

This position provides technical support for the Department's Computer-Assisted Mass Appraisal (CAMA) system, Abatement/Exemption Workflow application, 3ABC Online Filing Application, and related enterprise systems. The analyst works closely with business users, vendors, and IT staff to improve business processes, modernize applications, ensure data integrity, support annual tax billing operations, and deliver reliable reporting and analytical solutions.

The ideal candidate should have strong expertise in SQL Server, Microsoft Access, Excel, and data analysis, with the ability to translate business requirements into effective technical solutions while providing exceptional customer support.

Application & Systems Management:

• Maintain, support, troubleshoot, and enhance the Assessing Department's business applications, including the CAMA system, the Abatement/Exemption Workflow application, the 3ABC Online Filing Application, and any other mission-critical systems.
• Support application lifecycle activities including requirements gathering, configuration, testing, implementation, documentation, upgrades, and user training.
• Develop test plans, perform system testing, validate software enhancements, identify defects, and coordinate issue resolution prior to production deployment.
• Collaborate with software vendors, developers, database administrators, and City IT staff to implement new functionality, system integrations, and technology initiatives.
• Analyze departmental workflows and recommend technology solutions that improve efficiency, accuracy, and business processes.
• Provide advanced technical support to department staff and resolve application and system issues in a timely manner.

SQL Development, Reporting & Data Analysis:

• Monitor and maintain Microsoft SQL Server databases to ensure data integrity, reliability, and performance.
• Troubleshoot database, application, and data-related issues, and recommend improvements to enhance system performance and scalability.
• Design, develop, and maintain SQL queries, database objects, and automated processes supporting departmental operations.
• Develop recurring and ad hoc reports using SQL Server, Microsoft Access, Excel, and other reporting tools.
• Analyze large datasets related to property valuation, assessments, exemptions, tax billing, appeals, and departmental operations to support business decision-making.
• Develop statistical analyses and analytical reports supporting valuation studies, exemption programs, tax policy initiatives, and operational planning.

Assessing Data Projects:

• Support annual property tax billing for Real Estate, Personal Property, Motor Vehicle Excise, and Boat Excise by preparing data, validating calculations, resolving data issues, and supporting departmental users.
• Prepare, validate, and distribute assessment and tax data for public reporting, publications, and information requests.
• Support the Residential Exemption Compliance Program and other annual assessment initiatives.
• Generate reports, perform data analysis, and provide technical assistance to the Executive Secretary and departmental staff.
• Perform other related duties as assigned.

• Bachelor’s degree in computer science, information technology, or a related field; equivalent professional experience may be substituted.
• Four (4) years of full-time (or equivalent part-time) professional experience in systems analysis, database administration, application support, or a related information systems role.
• Demonstrated proficiency with Microsoft SQL Server, Microsoft Access, Microsoft Excel, and SQL development.
• Exceptional accuracy and attention to detail.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent organizational, written, verbal, and interpersonal communication skills.
• Ability to manage multiple priorities, work independently, collaborate across departments, and provide outstanding customer support.
• Ability to exercise sound judgment and maintain confidentiality when handling sensitive information.

BOSTON RESIDENCY REQUIRED

Terms:

Union/Salary Plan/Grade: SENA/MM1-8

Hours per week: 35