Data Engineer

Date Engineer


Hillsborough County Sherrif Office


6-12 month contract to hire


Onsite


Tampa, FL


USC only

It's better to think of this job as more Date Engineer and some Data Analyst. Major focus is designing and implementing data pipelines for structured and unstructured data using Python. We currently use Microsoft tools like SSIS, but we want to go PYTHON for that.


Python-based data pipeline development, ETL/ELT (Airflow/DBT), SQL (SQL Server/PostgreSQL), data modeling (star/snowflake), data warehousing, BI/reporting, and data validation using Pandas/Polars.


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

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.