Data Analyst II

Boulder County Sheriff's Office; Colorado; Hybrid; USD 75,000 - 110,000; Full time

Job summary

The Boulder County Sheriff's Office is seeking a Data Analyst II to enhance data reporting and dashboard integration services. This full-time role requires strong technical skills, particularly in SQL and Python, with a focus on ensuring data integrity and supporting departmental projects. The position offers flexible/hybrid work arrangements and competitive pay, along with robust benefits.

Benefits

Health plans including vision and dental coverage

12 weeks Paid Caregiver leave

Tuition assistance

Public Service Loan Forgiveness eligibility

Flexible work environment

Qualifications

• Experience in writing SQL scripts and data quality control is critical.
• Strong proficiency in Python and Power BI is desired.

Responsibilities

• Develops and maintains internal dashboards for the Boulder County Assessors Office.
• Ensures compatibility with data integration projects and conducts troubleshooting.

Skills

SQL

Data Quality Control

Python

Power BI

Education

8 years of combined education and experience in a related field

Job description

Get AI-powered advice on this job and more exclusive features.

Pay found in job post

Retrieved from the description.

Base pay range

$75,984.00/yr - $109,488.00/yr

Salary

$75,984.00 - $109,488.00 Annually

Location

Boulder County, CO

Job Type

Full-time

Remote Employment

Flexible/Hybrid

Job Number

6412(SD4)

Department

Assessors Office

Opening Date

06/26/2025

Closing Date

7/6/2025 11:59 PM Mountain

FLSA

Exempt

• Description
• Benefits
• Questions
  
  

Description

Boulder County Assessors Office is seeking to hire a Data Analyst II. This position under general supervision, acts as technical lead who supports and creates internal dashboards, data reporting and integrations. Works to ensure compatibility and integration with Office/Department and enterprise strategies. Participates in projects than entail complex coordination of resources, logistics, systems analysis, and vendor support. Troubleshoots and resolves problems with data and technical systems. Is responsible for technical support of small Office/Departmental related projects as well as some administrative duties.

This is a full-time, benefited position that will work Monday - Thursday 7:00am - 5:30pm. This position will work remote and out of 1325 Pearl St. Boulder, Colorado. Under Fair Labor Standards Act (FLSA) guidelines, this position is exempt.

Boulder County requires its employees to reside in the state of Colorado as of the first day of work.

Hiring Salary Range: $75,984.00 - $92,736.00 Annually

Tentative Hiring Timeline

• Phone Screening: July 14th
• First Round Interviews: July 21st
• Second Round Interviews: July 28th
• Reference Check: July 28th
  
  

New employees receive an 80-hour bank (Download PDF reader) of vacation at the time of hire, in addition to 8 hours of both vacation and medical leave accruals each month (Must not have been employed at Boulder County during the 12 months prior to re-hire date to qualify). Boulder County offers bountiful benefits, including pension contributions.

Boulder County employees may qualify for Public Service Loan Forgiveness (PSLF). Visit studentaid.gov for more information.

Examples of Duties

• Using county standard software develops and maintains dashboards for internal use
• Contributes to the implementation and integration of data between office/Department and other systems
• Constantly assesses database using ad hoc SQL query development, actively searches for inconsistencies and generates clean-up reports to us in quality assurance and quality control activities
• Works closely with software providers, Analyst team and other county offices and Departments ensure the integrity of internal and online data
• Assists in producing all major reports and mailings to meet statutory or other deadlines
• Assists in writing specifications including preparation of written specification for the design, modification, upgrades and testing of applications
• Responsible for documenting data information flows
• Helps to identify methods to streamline technical processes
• Identifies cost-effective changes and creates change specifications to Office/Department information systems and presents proposals to management
• Confers with users to obtain information limitations, capabilities, and needs of existing system and capabilities required for data processing projects and projected workload
• Maintains appropriate records of research methods and results
• Designs specific databases for collections, tracking, and reporting of research data
• May provide a variety of professional, administrative, and/or clerical services to department
• Develops and implements methodology for accessing data from State and vendor systems
• Performs related work, as required
• May be reassigned during emergency situations
  
  

Required Qualifications

PLEASE NOTE: When completing your application describe all relevant education and experience, as applications are assessed based on the required qualifications listed. Resumes and other attachments are not accepted in lieu of completed applications and will not be reviewed in the initial screening process. Any personally identifiable information (PII) such as name and address will be redacted from applications that meet the minimum screening requirements and are forwarded to the hiring manager. If the hiring manager selects you to advance in the hiring process, your attachments will then be shared with the hiring team.

Education & Experience

Boulder County is looking for well qualified candidates to fill our positions. Any combination of relevant education and experience is encouraged. In this position, we are looking for a minimum of 8 years of combined education and experience in a related field.

Background Check

• A job offer is contingent on passing a background investigation
  
  

Supplemental Information

Knowledge, Skills, & Abilities

• Intermediate skills and experience writing SQL scripts, stored procedures, and views.
• Experience performing data quality control.
• Experience in Python
• Experience using Power BI, and report writers such as Crystal Reports and SSRS
• Knowledge and experience with desktop applications
• Knowledge and experience with cloud-based applications and solutions
• Records maintenance skills
• Knowledge of research methodology, principles, and procedures
• Ability to communicate effectively, both orally and in writing
• Ability to prepare reports and proposals.
  
  

Boulder County is a workplace dedicated to supporting individuals and families of all types and to fostering a diverse, inclusive, and respectful environment for all employees. We prohibit unlawful discrimination against applicants and employees on the basis of race, color, religion, gender, gender identity, national origin, age, disability, socio-economic status, sexual orientation, genetic information, or any other status protected by applicable federal, state, or local law.

Benefits

As well as offering competitive pay and a caring work environment, Boulder County offers employees an array of benefits. For all FTE and Term employees, we provide:

Outstanding options of comprehensive health plans that include vision and dental coverage. Information can be found HERE.

Additional Benefits can be found HERE. (Download PDF reader)

• Including:
• Family-forming benefits- infertility treatment, adoption and surrogacy reimbursements
• 12 weeks Paid Caregiver leave
• Breast feeding friendly-work environment
• Sick child care, an infants-at-work policy
• Access to LifeMart discount hub, including discounts on childcare centers, event tickets, travel and more!
• Access to a nationally-recognized wellness program
• Employee Assistance Program
• PERA 401k
• Social Security retirement plans
• Additional Life and Disability Insurance
• Critical Illness and Accidental Insurance
• County-paid tuition assistance
• Eligible for PSLF- Public Service Loan Forgiveness
• Free EcoPass
• Hospital Indemnity
• ID Theft Protection
• Pet Insurance
• 8 Hours of Paid Public Service Leave

Generous paid time off

• Holidays
• New Year's Day January 1
• Martin Luther King's Birthday January
• Presidents' Day February
• Memorial Day May
• Juneteenth June 19
• Independence Day July 4
• Labor Day September
• Indigenous People's Day
• General Election Day November (first Tuesday after the first Monday, even years)
• Veterans' Day November 11
• Thanksgiving Day November
• Friday after Thanksgiving*
• Christmas Eve- ½ day (full day off depends on day of the week)
• Christmas Day December 25
• New Year’s Eve- ½ day (full day off depends on day of the week)
• Vacation**
• 80-hour bank of vacation at the time of hire
• Eight hours of vacation per month for the first year of continuous service, then accrue twelve hours of vacation per month after the first year of continuous service.
• Medical**
• Eight hours of medical leave for each month employed.

PERA- The County and all employees pay into both Social Security and PERA

• Employer contribution to Social Security: 7.65% of salary
• Employer contribution to PERA (Local Government Division- most county employees: 14.76%
• The District Attorney’s Office observe Francis Xavier Cabrini Day on the first Monday in October and omit the Friday after Thanksgiving
• Vacation and Medical leave are based off of full time FTE accruals. Part-time FTE/term employees accrue leave based on the percentage of time they work.
  
  

01

Please describe how you meet the required minimum qualifications of 8 years of combined education and experience.

02

What interests you about working for the Boulder County Assessor's Office?

03

Briefly explain your education/experience with writing/editing SQL queries, stored procedures and/or views.

04

At what level would you rate your Microsoft Excel skills based on the following criteria:

• none
• basic (sorting/filtering, navigation, charts/graphs)
• intermediate (basic formulas, conditional formatting, pivot tables)
• Advanced (functions, slicers, PowerQuery, PowerPivot)
  
  

05

Which of the following applications are you proficient in using (check all that apply)?

• Outlook
• Teams
• Excel
• Word
• Other (please specify)
  
  

06

If you selected 'other', please specify.

07

What experience do you have providing technical support and/or customer service?

08

What kinds of experiences have you had working with others with different backgrounds than your own?

09

In what ways do you feel you need to grow around your cultural awareness and what kind of support would you need?

Required Question

Employer Boulder County

Address 2025 14th Street

Boulder, Colorado, 80302

Phone [phone]

Website http://www.bouldercounty.org

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Law Enforcement

Referrals increase your chances of interviewing at Boulder County Sheriff's Office by 2x

Boulder, CO $124,000 - $178,000 1 week ago

Louisville, CO $94,874 - $158,124 3 days ago

Louisville, CO $94,874 - $158,124 1 day ago

GIS Product Engineer II - Roads and Highways

Apply for Future Opportunities at TrainHeroic

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.