Business Intelligence Analyst – Police Department

Business Intelligence Analyst – Police Department

Requirements

• Bachelor’s degree in computer science, Information Systems, statistics, or related field
• 1 year of related experience in SQL database management and PowerBI
• Knowledge of PowerBI
• Experience with Microsoft products, SQL and SSRS Report Builder
• Understanding of law enforcement practices and data analysis principles
• 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
• 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

Responsibilities

• 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

Preferred Qualifications

No preferred qualifications provided.