Business Intelligence Analyst

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 Monday, March 31, 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. 

MINIMUM QUALIFICATIONS & WORKING CONDITIONS

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: