DATA ENGINEER I

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

Job Description

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

Examples of Work

Essential Duties and Responsibilities:

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

Knowledge, Skills and Abilities

Required Candidate Technical Skills, Knowledge, and Proficiencies:

• 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

Open Requirements/Supplemental Information

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 Phyton is a plus.

Additional Requirements:

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

The City of Jacksonville is an Equal Opportunity/Equal Access Employer and will provide equal opportunity to all employees and applicants in compliance with all applicable federal and state employment laws and the current interpretation of employment discrimination by the United States Equal Employment Opportunity Commission, as set forth in Directive 0528.There shall be no discrimination or harassment against any person with regard to race, color, sex (including pregnancy), sexual orientation, gender identity or expression, religion, political affiliation, national origin, disability, age, marital status, veteran status, or any other impermissible factor in recruitment, hiring, compensation, training, placement, promotion, discipline, demotion, transfers, layoff, recall, termination, working conditions and related terms and conditions of employment.

Min

USD $92,800.00/Yr.

Max

USD $92,800.00/Yr.