Job Description

Data Engineer

Onsite Tampa, FL

Hillsborough County Sherrif Office

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.

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

Job Tags

Similar Jobs