Business Intelligence Specialist

Posted Nov 08
Oklahoma City Police Department in Oklahoma City, OK
CategoryBusiness & Management
Work At:On-Site

The qualification preferences for the position are:

• Bachelor’s degree or higher in Engineering Technology, Information Technology, Business Management, Analytics, or similar.

• Two years of experience in related analytical or data management field, or a combination of experience, training, and education that provides the necessary knowledge, skills, and abilities for the position.

• Experience in statistical programs such as Python, R, and/or GRETL as well as visualization tools Tableau and/or Power BI. Proficiency with SQL is expected as well as familiarity with Microsoft Office Products.

• Experience in translating business problems into requirements, prototyping the solutions and translating business requirements to business partners including department executives and IT.

JOB SUMMARY AND ESSENTIAL JOB FUNCTIONS: This position is located in several departments and is responsible for gathering complex business data, using statistical methods to analyze data, identifying trends and patterns in datasets and making recommendations, and creating models and presentations of findings. Work is performed on an independent basis, requiring a previous knowledge of development and/or support for commercial and custom applications serving a broad range of business needs. Essential job functions include: Leadership and oversight of various programs dealing with the management and analysis of data; identifying and developing new ways to introduce data into the current system, as well as develop and maintain new systems for monitoring efficiency of work and evaluations. Specific tasks include but are not limited to pulling existing data from multiple databases, analyzing data, and creating annual reports and projected outcomes; Assembling gathered data to present to executive staff for annual reports and evaluations; Working closely with IT to communicate design, alignment, and implementation of technical standards to address appropriate business solutions.


Knowledge and skill in analysis and data management understanding how data relates and is relevant to current business functions and future interfaces. Knowledge and skill with software related to programming and data gathering, mining, analysis and presentation using charts, graphs, or tables. Skill in accurately performing mathematical computations. Skill in data governance ensuring data quality exists throughout the entirety of the data life cycle, monitoring the availability, usability, and consistency of data integrity. Skill in research coordination planning activities, such as, identifying problem areas, proposing alternative solutions to those problem areas, developing plan implementation and statistical analysis, and accurate research findings. Skill in research analysis inquiring, examining, and revising current facts, to prepare reports. Skill in organizing, recording, and working accurately with large quantities of information and data. Skill in technical thinking and writing. Strong oral and written communication skills. Ability to recall and retain information. Ability to work with minimum supervision.


Primarily indoors, subject to sitting, standing, walking, using a telephone, keyboard, visual display terminal, etc. for extended periods of time. Primarily inside in a climate-controlled environment. Subject to frequent low-level noise from data processing equipment. Occasionally required to work beyond normal working hours or to change working hours when conducting training or systems analysis. Occasional local and out-of-town travel.


Arm/hand steadiness enough to demonstrate and operate computing equipment such as calculators, keyboards, and other computer operating devices. Manual and finger dexterity enough to operate equipment such as personal computers, audio visual, and other training aids. Near vision enough to read, write, develop training materials, and systems documentation, etc. Speech and hearing enough to communicate clearly and distinctly by telephone and in person.