Business Intelligence Analyst

Aurora, IL, United States

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 OVERVIEW OF POSITION / DEPARTMENT

The Business Intelligence Analyst will be pivotal in enhancing the efficiency and scalability of database applications, emphasizing data optimization, ETL operations, and the development of reports and BI dashboards. Your collaborative efforts with department members and IT analysts will contribute to the design and implementation of tools for seamless 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 Metabase, Tableau, Sisense, Power BI, or SSRS. 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. The salary range for this position is $96,884.17 - $121,105.21 annually. The deadline to submit applications is Friday, March 23rd, 2024. Initial review of submitted applications will commence on Monday, March 26th 2024 but may be subject to review as applications come in. However, it is subject to close at any time without prior notice once a sufficient pool of qualified applicants is obtained. Develops data visualization utilizing tools such as Metabase, Tableau, PowerBI, SSRS, etc.

Creates reports and dashboards to support the business needs of the organization.

Maintains high user expertise in department’s 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 for data within the report and dashboards.

Identifies and plans complex operational and administrative trend studies based on multiple data sources such as crime data, response time, and staffing.

Collaborates with IT staff to identify process improvements, and technology upgrades.

Coordinates with internal and external stakeholders to advance the department’s strategic plan.

Plans and conducts specialized, complex, and multi-dimensional analytic studies that impact all functions of the department.

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: At least 3 years progressively responsible related experience in SQL database management

Knowledge: Knowledge of data visualization tools such as Tableau, PowerBI, etc.

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

Occasional Standing/Walking- Occurs up to 31 minutes to 2.5 hours per shift

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 and drug screening. Employment references will be conducted on finalists for City of Aurora vacancies.

#J-18808-Ljbffr