Analyst I - Sales Tax

City-of-Colorado-Springs,-C; Colorado Springs (CO); On-site; USD 48,000 - 62,000; Full time

Job summary

The City of Colorado Springs is seeking an Analyst I in the Sales Tax Office to support financial reviews, reconciliations, and data reporting. You will use Excel, SQL, and other tools to analyze invoices, project costs, tax payments, refunds, and exemptions, and you will prepare timely reports for management.

Responsibilities include month-end validation, reviewing amended returns and adjustments, and maintaining documentation.

Qualifications

• 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.
• Desirable qualifications include experience reviewing construction-related financial records, accounting/finance/reporting, and Excel proficiency.
• Experience with SQL, database queries, or related reporting tools is desirable.

Responsibilities

• Conduct construction-related financial reviews by analyzing invoices, contracts, project costs, tax payments, refunds, exemptions, and supporting documentation.
• Gather, organize, validate, and reconcile financial and tax data from databases, systems, spreadsheets, and taxpayer records.
• Prepare and analyze recurring and ad hoc financial, statistical, and operational reports to identify trends, variances, and anomalies.
• Support month-end financial reporting by validating information and preparing supporting schedules and variance explanations.
• Review amended returns, refund requests, account adjustments, and supporting documentation for accuracy and compliance.
• Perform data-integrity and QA reviews and support testing and validation of system reports and changes.
• Maintain organized workpapers and respond to routine data requests; suggest improvements to reporting and processes.
• Other duties as assigned.

Skills

Financial analysis

Data analysis

Reconciliation

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.

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

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.

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.

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