Want to know if this job is worth applying to?
Portland, Oregon, United States
Onsite
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-$149,854.86Starting Salary Range
99903.24-124879.05Job 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 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.
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.
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).
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.
The Hillsborough County Sheriff's Office is an Equal Opportunity Employer, we believe that diversity and inclusion among our applicants and employees is critical to our success as a community partner. We seek to offer employment opportunities without regard to race, color, religion, sex, pregnancy, national origin, age, physical/mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information, and military/veteran status.