Business Intelligence Developer

Business Intelligence Developer

Fremont Solutions Group

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

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

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.

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.