Business Systems Analyst-Police Department

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:

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