Data Engineer I

Jacksonville Sheriff's Office • Jacksonville, FL

4d

About The Position

Responsible for the design, development, maintenance, and documentation of data programming objects, reports, and ETL processes within the Jacksonville Sheriff’s Office.

Requirements

• Thorough understanding of a database language e.g. SQL.
• Understanding of client-server computing
• Experience with data management
• Knowledge of reporting and query tools
• Understanding of software development lifecycle
• Understanding of development in a multi-system environment
• Familiar with warehousing and analysis
• Basic understanding of SQL Server configuration and server environment
• Understanding of ETL processes
• 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
• Strong operational knowledge and hands-on experience with SQL programming language.
• Must be available to work during limited emergency declarations as prescribed by the City of Jacksonville Civil Service and Personnel Rules and Regulations Rules.
• Must be available to respond to telephone calls, meetings, and unexpected situations outside of normal work hours until situations are resolved.
• Must maintain existing knowledge and skills through continuing education.
• Must have a personal standard of high attention to detail in all work tasks.
• Must work well as part of a team and/or as an individual depending on the task at hand.
• Must be flexible with changing, and often unexpected, work demands to meet the operational needs of the agency.
• Must be able to adhere to the Core Values of the agency: Worthy of Trust, Respect for Each Other, Community Focused, and Always Improving.
• Must adhere to all written directives of the Jacksonville Sheriff’s Office.

Nice To Haves

• Experience with Phyton is a plus.

Responsibilities

• Build, optimize, and maintain reliable data pipelines to ingest diverse data sources (APIs, SFTPs, transactional databases, etc.) and define efficient transformation workflows.
• Design and architect small-scale databases, objects, and relational schemas, ensuring clean data models, production tables, and staging areas within the data warehouse environment.
• Write clean and performant SQL scripts to transform raw data into business-ready datasets while optimizing queries, stored procedures, and table indexes.
• Schedule, monitor, and manage automated server jobs and data workflows to ensure consistent, timely data delivery and system operational standards.
• Partner with the Database Administrator (DBA) to maintain security compliance, establish system standards, and manage ongoing administrative maintenance.
• Implement automated testing, validation checks, and monitoring systems to safeguard data accuracy, while actively debugging pipeline failures or discrepancies to minimize downtime.
• Develop and maintain standardized reports using enterprise reporting engines (e.g., SSRS/SQL Server Reporting Services) to support business needs.
• Collaboratively support application developers, data analysts, and business teams to gather requirements, deliver actionable datasets, and evaluate emerging technologies with external vendors.
• Actively participate in all phases of the database development lifecycle (DBLC), including planning, design, analysis, coding, testing, deployment, and ongoing production support.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level