Business Intelligence Developer

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