Analyst I - Sales Tax

City of Colorado Springs; Colorado Springs (CO); On-site; USD 60,000 - 90,000; Full time

Job summary

The City of Colorado Springs is seeking an Analyst I - Sales Tax to support construction-related financial reviews, analyze project costs, invoices, tax payments, refunds, exemptions, and supporting documentation using Excel and SQL. This role involves reconciliations, recurring and ad hoc reporting, data validation, and trend analysis to support accurate tax administration.

Under general direction, the analyst conducts routine to moderately complex analyses, documents findings, and escalates

Qualifications

• Bachelor's degree in a related field.
• 1 year of professional experience in a related field.

Responsibilities

• Conduct construction-related financial reviews by analyzing invoices, contracts, project costs, tax payments, refunds, exemptions, and supporting documentation; perform reconciliations, identify discrepancies or missing information, and document findings.
• Gather, organize, validate, and reconcile financial and tax data from databases, financial systems, spreadsheets, bank information, and taxpayer records; research and document discrepancies.
• Prepare and analyze recurring and ad hoc financial, statistical, and operational reports using Excel, SQL, database queries, reporting tools to identify trends, variances, anomalies, and summarize findings for management.
• Support month-end financial reporting by validating information, researching differences, and preparing supporting schedules and variance explanations.
• Review amended returns, refund requests, account adjustments, and supporting financial documentation for accuracy and compliance with procedures.
• Perform data-integrity and quality-assurance reviews and support testing and validation of system reports, data corrections, and procedural changes.
• Maintain organized workpapers and documentation, respond to routine financial and data requests, and recommend improvements to reporting and processes.
• Other duties as assigned.

Skills

Accounting

Financial analysis

Data reporting

Attention to detail

Education

Bachelor's degree in related field

Tools

Microsoft Excel

SQL

Job description

Analyst I - Sales Tax The Sales Tax Office is seeking a detail-oriented Analyst I with a strong foundation in accounting, financial analysis, and data reporting. This position primarily handles construction-related financial reviews, including analyzing project costs, invoices, tax payments, refunds, exemptions, and supporting documentation. Additional responsibilities include financial reconciliations, recurring and ad hoc reporting, data validation, trend and variance analysis, and review of tax and financial records.

Description / Position Overview

Analyst I - Sales Tax The Sales Tax Office is seeking a detail-oriented Analyst I with a strong foundation in accounting, financial analysis, and data reporting. This position primarily handles construction-related financial reviews, including analyzing project costs, invoices, tax payments, refunds, exemptions, and supporting documentation. Additional responsibilities include financial reconciliations, recurring and ad hoc reporting, data validation, trend and variance analysis, and review of tax and financial records. The Analyst I works within established procedures and under general direction, using Microsoft Excel, SQL or database query tools, and other analytical applications to support accurate financial reporting and tax administration. The position performs routine to moderately complex analytical assignments, documents findings, and escalates more complex issues to higher-level staff as appropriate. This position is subject to budget required furloughs to be implemented in the 2026 calendar year.

As An Analyst I, You Will

• Conduct construction-related financial reviews by analyzing invoices, contracts, project costs, tax payments, refunds, exemptions, and supporting documentation; perform reconciliations, identify discrepancies or missing information, and document findings.
• Gather, organize, validate, and reconcile financial and tax data from databases, financial systems, spreadsheets, bank information, and taxpayer records; research and document discrepancies involving tax returns, payments, deposits, receivable activity, and related financial information.
• Prepare and analyze recurring and ad hoc financial, statistical, and operational reports using Microsoft Excel, SQL, database queries, reporting tools, and other analytical applications to identify trends, variances, anomalies, and unusual activity, and clearly summarize findings for management and other City departments.
• Support month-end financial reporting by validating financial information, researching differences, and preparing supporting schedules and variance explanations.
• Review amended returns, refund requests, account adjustments, and supporting financial documentation for accuracy and compliance with established procedures.
• Perform data-integrity and quality-assurance reviews and support testing and validation of system reports, data corrections, and procedural changes.
• Maintain organized workpapers and documentation, respond to routine financial and data requests, and recommend practical improvements to reporting, reconciliation, and operational processes.
• Other duties as assigned.

Learn more about this job by reviewing the class specification on the City of Colorado Springs Class Specifications page

Minimum Qualifications

We value a diverse range of qualifications and experiences. Our organization views each year of further education as equivalent to each year of relevant work experience, and each year of additional relevant work experience as equivalent to each year of required education.

• Bachelor's degree from an accredited college or university with major coursework in a related area of study.
• One year of full-time, professional experience in a related field.

Preferred Qualifications

The following qualifications are not required, but they are considered desirable. If you possess any of the preferred qualifications, please include specific details in your application. This information may be used to identify a top group of applicants.

• Experience reviewing construction-related financial records, such as invoices, contracts, project costs, payment documentation, refunds, exemptions, or reconciliations.
• Professional experience in accounting, finance, financial analysis, or financial reporting.
• Experience preparing reports, performing reconciliations, and analyzing financial data for trends, variances, discrepancies, or unusual activity.
• Intermediate or advanced proficiency with Microsoft Excel, including formulas, lookup functions, PivotTables, filters, or similar analytical features.
• Experience using SQL, database/query tools, or other analytical/reporting tools; experience in a governmental, tax, regulatory, compliance, construction accounting, or project-based financial environment is desirable.

Additional Information

Please contact Katie McLaughlin at [e-mail] for any questions about this position.

The City's job classifications, including physical demands and descriptions, can be found on the Colorado Springs Class Specifications page.

You can view the status of your application on the City of Colorado Springs Careers page.

To be notified of future career opportunities sign up for job alerts on the Job Alerts page.

Equal Opportunity Employer

The City of Colorado Springs is committed to a welcoming culture that values our employees' unique individual qualities and fosters a welcoming environment where people want to be.

The City of Colorado Springs offers additional compensation depending on the position, area of assignment, and specific job assignments, including shift differential, pay differential, acting or lead, special assignment, hazard pay, longevity, cell phone allowance, uniform allowance, relocation, awards, standby, call out, compensatory time off, tuition, overtime, extra duty, incentive, holiday premium, proficiency, and vacation sell back.

NOTE: This job announcement is not intended to include a complete listing of all responsibilities, knowledge, skills, and abilities associated with the position.

The City does not sponsor applicants for work visas of any kind (including but not limited to F-1, H-1B or TN visas). Applicants must be currently authorized to work in the United States on a full-time basis.

Working for the City of Colorado Springs is Rewarding!

Please visit the City of Colorado Springs' Total Rewards Site for additional benefits information.

The City of Colorado Springs is a place where people want to come to work each day. We have a culture of excellence, and we strive to provide our employees with the very best overall career experience and Total Rewards. We are proud to offer a comprehensive and competitive benefits program to meet the needs of our employees and their families.