Business Intelligence Analyst - Police Department

City of Aurora; Aurora (IL); On-site; USD 74,000 - 94,000; Full time

Job summary

The City of Aurora is seeking a Business Intelligence Analyst for the Police Department. The role involves collaborating on data integration and visualization using tools like Power BI and SQL. Candidates should possess strong analytical and communication skills, with a dedication to fostering safety in the community. This full-time position offers competitive compensation and benefits, ensuring an impactful work environment.

Benefits

Competitive total compensation package

Well-Funded General Employees Retirement Plan

On-site fitness center

Access to innovation workspaces

Qualifications

• Bachelor's degree in a related field required.
• 1 year experience in SQL management and PowerBI desired.
• Knowledge of law enforcement practices and data analysis principles.

Responsibilities

• Develop data visualization using PowerBI and SSRS.
• Create reports and dashboards to meet organizational needs.
• Ensure accuracy and integrity of data within reports.

Skills

Strong interpersonal skills

Analytical skills

Communication skills

Problem-solving skills

Education

Bachelor’s degree in computer science, Information Systems, statistics, or related field

Tools

Power BI

SQL

SSRS Report Builder

Job description

Business Intelligence Analyst - Police Department

Join to apply for the Business Intelligence Analyst - Police Department role at City of Aurora

Business Intelligence Analyst - Police Department

Join to apply for the Business Intelligence Analyst - Police Department role at City of Aurora

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

JOB LOCATION

15001 E Alameda Pkwy Aurora, Colorado 80012-1554

City of Aurora, Colorado

It is an exciting time to work for the City of Aurora, we're growing and looking for dedicated and collaborative individuals to join our team of talented and valued employees. Excellent organizations have a set of principles, or core values, that are used to implement their mission and vision. Those values represent the touchstone for the organization, guiding the decisions of the individuals and the organization. At the City of Aurora, we demonstrate our excellence by modeling the CORE 4 Values of: Integrity, Respect, Professionalism, and Customer Service, and we welcome all who share these values to apply.

Why Work for Aurora?

• Make a difference in the lives of real people every day
• Diverse community
• Competitive total compensation package
• Well-Funded General Employees Retirement Plan
• Light rail station minutes away
• On-site fitness center and overall employee well-being programs Internal educational programs to assist with career advancement
• Access to innovation workspaces
  
  

Primary Duties & Responsibilities

The hiring salary for this position is $74,480 - $93,100/annually.

This position will close on Tuesday, July 8, 2025. This position may close unexpectedly if we receive a sufficient pool of candidates.

Overview Of Position / Department

The Business Intelligence Analyst will collaborate with the Business Intelligence Analyst, department members and IT analysts to design and implement tools required for data integration and reporting. The position also entails ensuring the accuracy and integrity of data within reports and dashboards. With 3+ years of experience in SQL you will bring your expertise to the forefront, utilizing data visualization tools like Power BI, SSRS and SSMS. Effective communication, organizational skills, and a commitment to diversity and inclusion align with the dynamic and fast-paced nature of this role, supporting Aurora Police Department’s overarching goal of improving safety in the community.

• Develops data visualization utilizing tools in PowerBI and SSRS.
• Creates reports and dashboards to support the business needs of the organization.
• Maintains evolving user expertise in department databases and reporting requirements.
• Processes and mines complex multi-source data, including data cleaning and editing.
• Reviews all reporting to ensure the accuracy and integrity of data within the report and dashboards.
• Assists in the Identification and planning of complex operational and administrative trend studies based on multiple data sources such as crime data, response time, and staffing.
• Performs other duties as assigned.
  
  

This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice.

Education

MINIMUM QUALIFICATIONS & WORKING CONDITIONS

• Bachelor’s degree in computer science, Information Systems, statistics, or related field
  
  

Experience

• 1 year of related experience in SQL database management and PowerBI
  
  

Knowledge

• Knowledge of PowerBI
• Experience with Microsoft products, SQL and SSRS Report Builder
• Understanding of law enforcement practices and data analysis principles
  
  

Skills

• Strong interpersonal, analytical, and oral and written communication skills
• Strong assessment and problem-solving skills.
• Advanced skill in the use of personal computers, including spreadsheets, database management and word processing.
• Skill in SQL to support query needs and report writing.
  
  

Abilities

• Establish and maintain effective working relationships with other employees, customers, and other City departments.
• Handle situations with tact and diplomacy.
• Communicate effectively both orally and in writing.
• Establish and fulfill goals and objectives.
• Proactively research, analyze, present recommendations and when appropriate, implement computer system changes and upgrades that may be initiated by a variety of sources including staff, management, and vendors.
  
  

Licenses And Certifications Required

• None
  
  

Essential Personnel

• When a local announcement of emergency or disaster is declared by the city, all City of Aurora employees may be required to work as essential personnel.
  
  

Physical Demands

• Light work that involves moving no more than 20 pounds at a time.
• Occasional Standing/Walking- Occurs up to 31 minutes to 2.5 hours per shift.
• Occasional lifting 10 pounds overhead, carrying, walking, and standing.
• Frequent hand/eye coordination for operation of a computer keyboard and other office equipment
• Vision for reading and interpreting reports and data analysis and preparation
• Frequent speech communication, hearing and listening to maintain communication with employees and citizens.
  
  

Work Environment

• Normally works in a clean, comfortable environment.
• System support issues may require working outside of the office environment and in or around emergency response vehicles.
  
  

Equipment Used

• Frequently uses computer keyboard and telephone, fax machines, copiers, and microfilm equipment.
• This position may require the incumbent to occasionally use personal equipment (e.g. vehicle, cell phone, tools, etc.) in the course of their employment.
  
  

For Veterans preference: Please show all of your employment history, including military service and related documentation (DD214) on the application.

The City of Aurora is an equal opportunity employer. We are required by state and federal agencies to keep certain statistical records on applicants. It will not be used in any way to discriminate against you because of your sex, race, age, sexual orientation, creed, national origin, disability or military status, gender identity, unless related to a bona fide occupational qualification as defined by the Colorado Civil Rights Commission and the Equal Opportunity Commission.

Despite the changes in Colorado law, the City of Aurora maintains a drug-free workplace. A positive test of marijuana is grounds for disqualification and ineligibility for employment with the city for one year or termination once hired.

Drug Testing, Thorough Criminal Background Check, And Employment References

As a condition of employment, all applicants selected for employment with the City of Aurora must undergo a thorough criminal background check.

Applicants selected for safety-sensitive positions are required to complete and pass a drug screening as a condition of employment. Safety sensitive positions include Civil Service positions within Police and Fire Departments and positions where their job responsibilities have direct and substantial responsibility that would impact the health and safety of others.

Employment references will be conducted on finalists for City of Aurora vacancies.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Research, Analyst, and Information Technology

• Industries

  Government Administration

Referrals increase your chances of interviewing at City of Aurora by 2x

Sign in to set job alerts for “Business Intelligence Analyst” roles.

Business Intelligence Analyst - Financial Firm - Denver, CO

Denver, CO $75,000.00-$120,000.00 1 month ago

Sr Business Intelligence Analyst, Broadband Performance Reporting

Denver, CO $80,600.00-$145,500.00 3 days ago

Denver, CO $67,000.00-$92,000.00 18 hours ago

Denver, CO $90,000.00-$110,000.00 18 hours ago

Denver, CO $170,000.00-$180,000.00 4 days ago

Denver, CO $102,890.67-$139,637.34 1 month ago

Greenwood Village, CO $67,100.00-$107,300.00 13 hours ago

Business Analyst - Growth Strategy & Analytics

Denver, CO $132,288.00-$191,082.67 1 month ago

Denver, CO $93,000.00-$105,000.00 2 days ago

Senior Analyst – Business Development & Corporate Development

Denver Metropolitan Area $60.00-$64.00 1 day ago

Denver, CO $135,100.00-$148,600.00 1 day ago

Denver, CO $75,000.00-$85,000.00 17 hours ago

Operations Business Analyst-Denver, Colorado

Lakewood, CO $71,400.00-$89,200.00 3 weeks ago

Business Analyst, application via RippleMatch

Englewood, CO $63,150.00-$80,000.00 1 week ago

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