Analyst I - Sales Tax

City of Colorado Springs • Colorado Springs, CO

12d

About The Position

The Sales Tax Office is seeking a detail-oriented Analyst I with a foundation in accounting, financial analysis, and data reporting. The position primarily conducts construction-related financial reviews, including analysis of project costs, invoices, tax payments, refunds, exemptions, and supporting documentation. It also performs financial reconciliations, recurring and ad hoc reporting, data validation, trend and variance analysis, and reviews of tax and financial records.

The Analyst I works under general direction and within established procedures, using Microsoft Excel, SQL or database query tools, and other analytical applications to support accurate financial reporting and tax administration. The role performs routine to moderately complex analytical assignments, documents findings, and escalates more complex issues to higher-level staff as appropriate. The position is subject to budget-required furloughs to be implemented in the 2026 calendar year.

Requirements

• 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.
• Relevant education and experience are treated as equivalent year for year: each year of further education may substitute for one year of relevant work experience, and each year of additional relevant work experience may substitute for one year of required education.

Nice To Haves

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

Responsibilities

• Conduct construction-related financial reviews of 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 Excel, SQL, database queries, reporting tools, and other analytical applications; identify trends, variances, anomalies, and unusual activity and 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.
• Perform other duties as assigned.

Benefits

• Additional compensation may be available depending on the position, assignment area, and specific job assignments. Listed forms include shift differential, pay differential, acting or lead pay, special assignment pay, hazard pay, longevity, cell phone allowance, uniform allowance, relocation, awards, standby, call out, compensatory time off, tuition, overtime, extra duty, incentive, holiday premium, proficiency pay, and vacation sell back.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level