Data Engineer I: Build Scalable ETL Pipelines

Jacksonville Sheriff's Office; Jacksonville (FL); On-site; USD 84,000 - 102,000; Full time

Job summary

Jacksonville Sheriff's Office is seeking a data engineer to design, develop, and maintain data programming objects, reports, and ETL processes. The role emphasizes building reliable pipelines, modeling databases, and optimizing SQL workflows to support agency operations.

You will collaborate with developers and analysts, participate in the full DBLC, ensure data quality, and provide standardized reports using SSRS or similar tools.

Qualifications

• Bachelor’s Degree in Computer Science, MIS, or equivalent work experience.
• 1-5 years IT operation with understanding of database structures, theories, principles, and practices.
• 1-5 years Microsoft SQL Server experience or comparable enterprise DB experience.
• Programming Proficiency: Strong operational knowledge and hands-on experience with SQL programming language. Experience with Python is a plus.

Responsibilities

• Data Pipeline & ETL/ELT Development: Build, optimize, and maintain reliable data pipelines and define efficient transformation workflows.
• Database Design & Data Modeling: Design and architect small-scale databases, objects, and relational schemas within the data warehouse environment.
• Data Transformation & Performance Tuning: Write clean SQL scripts to transform raw data and optimize queries, procedures, and indexes.
• Workflow Automation & Orchestration: Schedule, monitor, and manage automated server jobs and data workflows.
• Database Operations & DBA Support: Partner with the DBA to maintain security, standards and maintenance.
• Data Quality & System Troubleshooting: Implement automated tests and monitoring to safeguard data accuracy and minimize downtime.
• Reporting & Analytics Support: Develop and maintain standardized reports using enterprise reporting engines.
• Cross-Functional Collaboration: Work with developers, analysts, and business teams to gather requirements and deliver datasets.

Skills

SQL

Database design

ETL/ELT development

Data modeling

Workflow automation

SQL Server

Python

SSRS

Data warehousing

Cross-functional collaboration

Education

Bachelor's degree in Computer Science or MIS

Tools

SQL Server

Python

SSRS

Job description

Jacksonville Sheriff's Office is seeking a data engineer to design, develop, and maintain data programming objects, reports, and ETL processes. The role emphasizes building reliable pipelines, modeling databases, and optimizing SQL workflows to support agency operations.

You will collaborate with developers and analysts, participate in the full DBLC, ensure data quality, and provide standardized reports using SSRS or similar tools.