Data Engineer
Onsite Tampa FL
Hillsborough County Sherrif Office
Its 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 Industrys 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.
Data Engineer Onsite Tampa FL Hillsborough County Sherrif Office Its 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...
Data Engineer
Onsite Tampa FL
Hillsborough County Sherrif Office
Its 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 Industrys 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.
View more
View less