IT Specialist IV – Senior Business Intelligence Analyst

JOB SUMMARY

Starting Salary: $69,513/yr – $106,766/yr depending on the level of education and experience.

MINIMUM REQUIREMENTS & ESSENTIAL FUNCTIONS

The IT Specialist IV - Senior Business Intelligence Analyst is a key member of the IMS Solutions Delivery data team. This role supports data analytics, operational reporting, efficiency projects, and problem resolution. This individual will address complex operational challenges by analyzing and defining strategic and operational improvements within our workgroups. This team member will also interface with other organizational teams to recommend solutions and efficiencies, manage the agency data warehouse environment, and develop solutions to create efficiencies within existing agency reporting requirements.

The Senior Business Intelligence Analyst transforms data into actionable insights that inform the organization's strategic decisions and drive business value. Possesses a combination of business and technical knowledge, enabling the identification of opportunities for process improvement in support of strategic initiatives and surfacing actionable information out of large complex systems. This position reports to an IT Supervisor. #oj

Minimum Requirements

• At least 18 years of age.
• U.S. Citizen or possess a current permanent resident card.
• Accredited high school or GED diploma.
• Must be able to comprehend and communicate fluently in verbal and written English.
• Good work history.
• Clean criminal history; any arrest history will be individually evaluated.
• No illegal drug usage within the last year. Other usage will be evaluated on a case by case basis.
• High school diploma or general education degree (GED) AND four (4) years of development experience in the following: Microsoft SQL Server Administration, SSRS, and SSIS products as well as using other Business Intelligence tools such as Tableau or Microsoft Power BI. OR Bachelor's degree (B.A. or B.S.) in Computer Science, Management Information Systems, or related field AND three (3) years of development experience in the following: Microsoft SQL Server Administration, SSRS, and SSIS products as well as using other Business Intelligence tools such as Tableau or Microsoft Power BI.
• Must have a valid Florida driver's license. Must attend and successfully complete the agency sponsored Law Enforcement Vehicle Operations (LEVO) Training if assignment includes driving an agency vehicle. Use of agency vehicle would require appropriate driving history and passing agency biennial driver's physical exam.
• Depending on assignment, may be required to be FCIC/NCIC certified within one (1) year of accepting position.
• Ability to develop and manage the agency's SQL data warehouse.
• Ability to extract, transform and load business appropriate data into agency data warehouse.
• Ability to perform data mining, queries and extractions to acquire, aggregate, cleanse, organize and manage large complex datasets from multiple sources.
• Ability to gather and analyze large amounts of information quickly and problem solve effectively. Prioritize analysis work, applying critical thinking and objectively interpreting results, providing meaningful data-driven insights and improvement recommendations, supporting business stakeholders in making strategic decisions.
• Ability to design, develop and maintain reports, scorecards, and dashboards that effectively tell the story of the data and highlight anomalies in a manner that customers can easily understand and act upon.
• Ability to develop, track, and report on key operational metrics in partnership with business leaders.
• Ability to prepare effective presentations and articulately communicate findings and results.
• Ability to document work processes and produce training materials to train co-workers and customers. Actively monitors daily business results (reporting) and anticipates developing trends and potential impacts to future results.
• Ability to interpret results autonomously using a variety of techniques ranging from simple data aggregation via statistical analysis to complex data mining.
• Ability to strategically analyze reports across all departments to identify gaps or opportunities that drive business improvement.
• Ability to work both independently and in groups in a variety of situations requiring analytical-interpretive, evaluative, and constructive thinking.
• Ability to understand data-management controls and business process intelligence.
• Ability to understand and translate business requirements into system requirements incorporating timing, contingencies, and limitations.
• Ability to exercise sound judgment and critical decision making within approved guidelines on business- process and system requirements.
• Ability to clearly document workflows and processes.
• Ability to identify areas for process improvement and standardization.
• Ability to assist in the development of key operational metrics with the goal of developing executive-level dashboards.
• Ability to promote, engage, and demonstrate intuitive and visual analytics tools to all partners.
• Ability to regularly ensure that reporting delivered to internal customers is accurate, useful, and actionable. Support ad hoc analysis and special projects on an as-needed basis.
• Must have advanced computer skills and advanced proficiency in Microsoft Office.
• Ability to read, analyze, and interpret common scientific and technical journals, and financial reports.
• Ability to respond to common inquiries or complaints from citizens, regulatory agencies, or members of the business community.
• Ability to effectively present information to top management and other employees.
• Must have the ability to use creative and original thinking.
• Must also have ability to use judgment and discretion.
• Ability to focus and complete assignments in a timely manner.
• Ability to meet with stakeholders to identify business requirements and translate these objectives into an acceptable technological solution that is cost effective and consistent with agency policy.

Preferred Qualifications:

• Experience with Data Science, Data Analytics and Artificial Intelligence and Python programming and using Tableau.
• Advanced skills in one or more of the following: web development tools, database administration tools, and business intelligence tools.

PROCESSING & TRAINING

ADDITIONAL PROCESSING:

• Some positions, depending on the responsibilities, may require the candidate to successfully pass a physical or other selection processes when needed.
• Please upload a copy of your resume that is no longer than two (2) pages in length to your application

PHYSICAL DEMANDS & WORK ENVIRONMENT

PHYSICAL DEMANDS

While performing the duties of this job, the employee is regularly required to talk, hear, and also sit and work on the computer for long periods of time. The employee is occasionally required to stand and reach with hands and arms. The employee is occasionally required to walk, stoop, kneel, crouch, crawl, or use hands to handle or feel. The employee may occasionally lift and/or move up to 25 pounds and may have to assist someone lifting up to 50 pounds. Specific vision abilities required by this job include close vision and the ability to adjust focus.

WORK ENVIRONMENT

Work is generally performed in a standard office setting. The employee must be able to work in remote locations within Orange County and possibly outside of Orange County. The employee will be working with computer related equipment and may occasionally be exposed to the risk of electrical shock. The noise level in the work environment is usually moderate. Depending on assignment, may be required to occasionally work evenings and/or weekends. The employee is required to support the agency's emergency operations during a critical incident and may be recalled. The employee may also be assigned to a technical team in order to support the agency during a critical incident. The employee will need to be available to be on call as determined by their supervisor.

The Orange County Sheriff's Office is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, the Orange County Sheriff's Office may provide reasonable accommodations to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer.