Business Intelligence Developer

Why choose HCSO?  We have a history of stability and excellence.  We continue to maintain and cultivate the highest level of standards and professionalism.  We are unlike any other.  Join the HCSO family!

Compensation Range

$98,187.61-$160,121.33

Starting Salary Range

98187.61-129154.47

Job Description Summary

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.

Job Description

Duties & Responsibilities

Duties may vary based on assignment.

• 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

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

• Stand/sit at a keyboard or workstation for prolonged periods.

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

• Work standard business hours.

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

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

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 nec