DATA ENGINEER I

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

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.

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.