Lead BI Developer - Data Warehouse & ETL Specialist

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 $99,903.24-$Starting Salary Range.
05

Job Description Summary Build and maintain business intelligence solutions for 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 & Abilities Knowledge of building automated data validation and reconciliation checks to ensure data accuracy, integrity, and completeness.

Knowledge of designing data warehouses and data marts that support analytics, ML, and dashboard reporting.

Knowledge of dimensional modeling and star/snowflake schemas.

Basic understanding of secure coding principles and CJIS data protection guidelines.

Working knowledge of office policies and procedures.

Proficiency in C# or Python.

Proficient in writing optimized SQL queries, functions, and stored procedures for SQL Server and Postgre

SQL.Experience designing and maintaining ETL / ELT pipelines using frameworks such as Apache Airflow, DBT (Data Build Tool), or equivalent orchestration systems, with the ability to schedule, monitor, and recover complex multi-stage jobs.

Proficiency in cleaning, merging, and reshaping data using Pandas, Polars, or SQL.Strong debugging and troubleshooting skills in both application and database layers.

Effective communication and interpersonal skills for interacting with users and technical staff.

Ability to dissect complex problems, experiment methodically, and find practical, innovative solutions.

Ability to prioritize and manage multiple tasks in a dynamic environment.

Ability to perform exploratory data analysis to detect trends, anomalies, and data quality issues.

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.

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

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

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

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…