Business Intelligence Developer

  • Job Code: U8816
  • Pay Grade:UH
  • Pay Scale:$98,187.61-$160,121.33 Annually
  • Exempt:Yes

Overview

The Business Intelligence (BI) Developer is a part of the Application Development team that builds and maintains business intelligence solutions for all parts of the Sheriff’s Office to include law enforcement, detention, human resources, finance, and integration of data from agency criminal justice partners.

Duties & Responsibilities

Note: Depending on assigned responsibilities, employees may perform some or all of the duties below.

  • Design and develop BI solutions.

  • Gather user requirements, develop technical and functional requirements, produce reporting solutions, and document the design and development process, metadata, and business rules.

  • Model, implement, and maintain databases and data marts to support BI reporting.

  • Develop extract, transform, load (ETL) to support the loading of data into data marts.

  • Monitor the data quality of existing databases and data marts and recommend governance and control around self-service BI/Analytics considering the evolution of the BI Industry’s best practices.

  • Perform other related duties as required.

Knowledge, Skills & Abilities

  • Working knowledge of ETL tools preferably SQL Server Integration Services (SSIS).

  • Working knowledge of Transact-Structured Query Language (T-SQL) and database design.

  • Strong English written and verbal communication skills.

  • Ability to develop reports preferably with SQL Server Reporting Services (SSRS) or Crystal Reports.

  • Ability to analyze complex problems and suggest solutions.

Working Conditions

  • Working within an office environment within a law enforcement agency.

  • Remaining in a stationary position for extended periods of time at a keyboard, workstation, or meeting and/or training site.

  • May be required to engage in light physical exertion (e.g., lifting, carrying, pushing and/or pulling of objects and materials of light weight from 5 to 10 pounds).

  • May be required to work non-standard hours including nights, weekends, and holidays.

Minimum Education & Experience

  • A high school diploma or possession of a GED certificate.

  • Seven years of paid experience in the development of BI solutions.

  • Seven years working with ETL tools with at least four years with SSIS.

  • Seven years developing reports with at least three years with SSRS or Crystal Reports.

  • Three years of experience with T-SQL and database design.

OR

  • An associate degree from an accredited institution of higher education in a technical field.

  • Six years of paid experience in the development of BI solutions.

  • Six years working with ETL tools with at least three years with SSIS.

  • Six years developing reports with at least two years with SSRS or Crystal Reports.

  • Three years of experience with T-SQL and database design.

OR

  • A bachelor’s degree from an accredited institution of higher education in a technical field.

  • Five years of paid experience in the development of BI solutions.

  • Five years working with ETL tools with at least two years with SSIS.

  • Five years developing reports with at least one year with SSRS or Crystal Reports.

  • Three years of experience with T-SQL and database design.

OR

  • Four years of experience in a Hillsborough County Sheriff’s Office Information Services Division position.

Required Pre-Employment Testing

  • A passing score on pre-employment testing.

Additional Job Requirements

  • Attendance at the specified Sheriff's Office work location is required.

  • Depending on assignment, employees may be required to possess a valid Florida Driver License at time of employment. Driving history will be thoroughly reviewed and may be grounds for disqualification.

  • No visible tattoos on face, head, and neck. Tattoos determined to take away from the professional appearance of the Sheriff's Office must be covered with an appropriate white, black, or neutral covering.

  • No illegal drug sale within lifetime.

  • No illegal drug use within the past 36 months. No marijuana use within the last 12 months.

  • No felony convictions within lifetime.

  • No misdemeanor convictions involving perjury, false statement, or domestic violence within lifetime.

  • No dishonorable discharge from any branch of the United States Armed Forces, the United States Coast Guard, National Guard, or Reserve Forces.

  • Successful completion of a background investigation including criminal, reference, employment, and neighborhood checks; polygraph; medical evaluation; and drug screening.

  • Live within Hillsborough County or within Citrus, Hardee, Hernando, Lake, Manatee, Pasco, Pinellas, Polk, Sarasota, or Sumter County as long as the residence is located within the 60-mile parameter of Falkenburg Road Jail at the time of appointment/employment (certified only).

  • In the event of an emergency or disaster, may be required to respond promptly to duties and responsibilities as assigned by management chain, Division/District Commander, or the Sheriff (or their designee). Such assignments may be for before, during or after the emergency/disaster.

The duties and responsibilities on this job description represent the essential functions that an employee must be able to satisfactorily perform with or without reasonable accommodations. Reasonable accommodations shall be made upon request to enable employees with disabilities to perform the essential functions of their job, absent undue agency hardship. The Sheriff’s Office retains the right to change or assign other duties to this job as necessary.

Preferred Qualifications

  • Experience with dashboard visualization tools such as Tableau or QlikView.

  • Experience with programming experience in C Sharp (C#).

  • Experience with Agile software development lifecycle.

  • Knowledge of advanced data warehousing techniques.

Last updated: 12/20/2024