DATA ENGINEER I
for each section heading.
We need to use - for any list of duties/requirements/benefits, and
for prose.
We need to preserve all substantive information, not invent or summarize away detail. Remove boilerplate like EEO etc. Also remove duplicated lines, cookie/navigation etc. The posting includes a lot of EEO boilerplate at end; we must remove that.
Also remove "Post End Date" etc metadata; we can fold minor metadata into short
or drop it. The dates maybe not needed; we can drop.
We need to output only HTML fragment.
Let's extract content:
About the role: "Responsible for the design, development, maintenance, and documentation of data programming objects, reports, and ETL processes within the Jacksonville Sheriff’s Office."
That's a prose sentence.
Responsibilities: list of duties from "Examples of Work Essential Duties and Responsibilities:" then bullet-like sentences:
- 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.
We should keep each as
- .
Requirements: maybe education and experience: "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."
Also Additional Requirements list: many statements like "Must be available to work during limited emergency declarations...", "Must be available to respond to telephone calls...", "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."
We could combine Requirements and Qualifications sections. The instruction: Use headings for About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to decide what goes where.
We have:
- About the role: prose.
- Responsibilities: list.
- Requirements: education/experience maybe.
- Qualifications: maybe technical skills list.
- Skills: maybe abilities list.
But we have overlapping content. We need to avoid thin sections; prefer few substantive sections. Could combine Requirements and Qualifications into one? But we must follow headings only if posting has real specific content for it. We could include Requirements (education/experience) and Qualifications (technical skills) and Skills (abilities). That's three sections; each has content.
Let's extract:
Requirements (education/experience):
- 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.
Qualifications (maybe technical skills list from "Knowledge, Skills And Abilities Required Candidate Technical Skills, Knowledge, and Proficiencies :" includes:
- 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
That seems like qualifications.
Skills (maybe the Additional Requirements list of soft skills/behaviors):
- 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.
We could also include "Must maintain existing knowledge and skills through continuing education." etc.
Pay: fixed $92,800 per year.
We should not include Benefits or Schedule.
Now format.
We need to output only HTML fragment, no /, no markdown.
We'll produce something like:
About the role
Responsible for the design, development, maintenance, and documentation of data programming objects, reports, and ETL processes within the Jacksonville Sheriff’s Office.
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.
Requirements
- 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
Qualifications
- 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
Skills
- 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
Pay
USD $92,800.00 per year (both minimum and maximum)
We need to ensure we didn't include any boilerplate like EEO. We removed that.
Check for any duplicated lines: none.
Check for any placeholder like "commensurate with experience" - none.
Check for any "N/A" etc - none.
for prose. We need to preserve all substantive information, not invent or summarize away detail. Remove boilerplate like EEO etc. Also remove duplicated lines, cookie/navigation etc. The posting includes a lot of EEO boilerplate at end; we must remove that. Also remove "Post End Date" etc metadata; we can fold minor metadata into short
or drop it. The dates maybe not needed; we can drop. We need to output only HTML fragment. Let's extract content: About the role: "Responsible for the design, development, maintenance, and documentation of data programming objects, reports, and ETL processes within the Jacksonville Sheriff’s Office." That's a prose sentence. Responsibilities: list of duties from "Examples of Work Essential Duties and Responsibilities:" then bullet-like sentences: - 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. We should keep each as
About the role
Responsible for the design, development, maintenance, and documentation of data programming objects, reports, and ETL processes within the Jacksonville Sheriff’s Office.
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.
Requirements
- 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
Qualifications
- 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
Skills
- 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
Pay
USD $92,800.00 per year (both minimum and maximum)
We need to ensure we didn't include any boilerplate like EEO. We removed that. Check for any duplicated lines: none. Check for any placeholder like "commensurate with experience" - none. Check for any "N/A" etc - none.