Data Engineer

Salary : $114,736.34 - $152,981.71 Annually
Location : Administration: 300 West Third Street, Oxnard 93030, CA
Job Type: Full Time
Job Number: 3300-IT-2507-BP
Department: INFORMATION TECHNOLOGY
Opening Date: 07/24/2025
Closing Date: Continuous


Description
This recruitment is open until filled. Early submissions are encouraged as applications will be reviewed on a regular and ongoing basis.

The City of Oxnard is seeking a skilled and proactive Data Engineer to support our modernization efforts and optimize data workflows across our 300+ applications. This role will be responsible for designing, developing, and maintaining ETL pipelines, data transformations, and legacy systems integrations to ensure seamless data flow between city systems and third-party vendors. You will work closely with integration specialists, database administrators, and business stakeholders to enhance accessibility, reporting, and usability of critical data.

This role is essential in monitoring and maintaining the data health of the city and aiding decision making through analysis and visualization. Therefore, the ideal candidate will have experience in BI and working with stakeholders to create dashboards and reports.

WHAT YOU'LL DO:

• Maintain disparate datasets through ETL pipelines, improve data accessibility, ensure data integrity, and drive and enforce security compliance.
• Prepare strategies for modernizing legacy systems through database migrations or hybrid integrations.
• Collaborate with database administrators and integration specialists to streamline workflows and optimize performance.
• Work with system administrators to ensure data security and access control best practices.
• Support BI initiatives by structuring data and building dashboards for analysts.
• Help train and support business users to use BI tools effectively.
• Maintain technical documentation for data flows, integrations, and system dependencies.
• Analyze data trends, discrepancies, and vendor requests to guide informed decisions.
• Participate in evaluating and recommending software tools and platforms for data work.

Payroll Title/Classification: Business Systems Analyst, Senior
WORK SCHEDULE:

The normal work week is Monday through Friday 8:00 am-6:00 pm with every other Friday off. This position may be required to be on an on-call (stand-by) rotation and you may be required to be available to work additional hours as needed to respond to workload needs.


The City does not offer hybrid or remote work.
Please note: The Information Technology Department supports public safety personnel including the Police Department on a 24-hour, 7-day-per-week schedule, therefore, the candidate may be required to be on call on a rotating basis, subject to callback. As part of the selection process, applicants will be required to successfully complete a thorough background investigation, which may include a polygraph exam.

Essential Functions


This class specification represents only the core areas of responsibilities; specific position assignments will vary depending on the needs of the Department.

• Design, build, and maintain ETL pipelines to support data exchange between systems.
• Ensure data consistency, integrity, and compliance with governance regulations such as CJIS.
• Develop integration solutions using APIs, web services, and direct database connections.
• Optimize and transform legacy and modern data for use across applications.
• Collaborate with technical teams to structure and optimize databases for accessibility.
• Implement observability mechanisms to ensure critical data workflows and integrations are traceable, auditable, and monitored for failures or anomalies.
• Perform root cause analysis of data errors, failures, and bottlenecks.
• Write documentation for databases, workflows, custom integrations, and reports.
• Conduct unit and integration testing for pipelines and transformations.
• Research, evaluate, and recommend software tools, platforms, and third-party solutions to meet business and technical requirements.
• Work closely with business leaders, analysts, and department heads to gather requirements and ensure BI solutions align with business objectives.
• Build dashboards and interactive reports, empowering end-users to access and explore data independently.
• Work cross-functionally with stakeholders and non-technical business users.
• Other assigned duties as the role may require.

Minimum Qualifications


The following are the minimum qualifications necessary for entry into the classification:

Education :

• Bachelor's degree in Computer Science, Business Administration, Information Technology, or a related field.

Experience :

• Minimum of 5 years of hands-on experience in Data Engineering, Integration Engineering, Data Analysis, or a similar field.
• Proven experience with custom reporting, dashboards, or BI tools (Power BI, Tableau, Qlik, or similar).
• Strong proficiency in SQL, Python, or other scripting/ETL languages.
• Strong understanding of database systems (MS SQL Server, MySQL, or similar) including database design and optimization.
• Hands-on experience with ETL processes and tools (SSIS, Talend, Apache Airflow, or similar).
• Knowledge of data modeling, warehousing, and integration protocols (APIs, SFTP, message queues, XML/JSON data exchanges).

Highly Desirable Experience, Qualifications and/or Certifications:

• Local government or public sector experience especially public safety (police and fire).
• Experience with version control systems (e.g., Git or TFS) and collaborative development workflows (e.g., GitFlow).
• Previous experience in a hybrid role combining technical and business analysis responsibilities.
• Knowledge of cloud-based data storage and processing (AWS, Azure, etc.).

Licensing/Certifications:

• Valid CA Class C Driver's License

Other Requirements:

• Must be able to speak and understand English to effectively communicate with fellow employees, customers, and vendors.

General Information
APPLICATION PROCESS:

• Submit NEOGOV/Government Jobs on-line application.
• Complete and submit responses to the supplemental questions, if required.
• Upload resume, cover letter, proof of degree (transcript), or other requested documents.

Your application may be rejected as incomplete if you do not include the relevant information in the online application and include the information only on the resume. Applications and/or Supplemental Questionnaires that state "see my resume" or "see my personnel file" are considered incomplete and will not be accepted. Cover letters and/or optional resumes are not accepted in lieu of a completed application.
The list of qualified candidates established from this recruitment may be used to fill other full-time, part-time, and temporary assignments. T here is currently one (1) full-time vacancy within the Information Technology Department.

Selected candidate(s) must pass a thorough background investigation.

UNION MEMBERSHIP: Positions in this classification are represented by the Oxnard Mid Manager's Association (OMMA).
NOTE: For most positions, the City of Oxnard relies on office automation (Microsoft Office/Google) and web-based enabled tools, therefore candidates must be proficient and comfortable with computer use to perform functions associated with on-going work.

Regular and reliable attendance, effective communication skills, and development of effective working relationships are requirements of all positions.
Employees are required to participate in the City's direct deposit plan and are paid on a bi-weekly basis.
This position requires a 12 month probationary period.
Pursuant to California Government Code Section 3100, all public employees are required to serve as disaster service workers subject to such disaster service activities as may be assigned to them.
EQUAL OPPORTUNITY: The City of Oxnard is an Equal Opportunity Employer and welcomes applications from all qualified applicants. We do not discriminate on the basis of race, color, religion, sex, national origin, age, marital status, medical condition, disability or sexual orientation.
REASONABLE ACCOMMODATION: The City of Oxnard makes reasonable accommodation for individuals/people with disabilities. If you believe you require special arrangements to participate in the testing process, you must inform the Human Resources Department in writing no later than the filing date. Applicants who request such accommodation must document their request with an explanation of the type and extent of accommodation required.
LEGAL REQUIREMENT: On the first day of employment, new employees must provide proof of citizenship or documentation of legal right to work in the United States in compliance with the Immigration Reform and Control Act of 1986, as amended. The City participates in E-Verify and will provide the federal government with your form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9. For more information on E-Verify, please contact DHS. View phone number on click.appcast.io dhs.gov/e-verify

If you have any questions regarding this recruitment, please contact Ashley Costello at NOTE: The provisions of this bulletin do not constitute an expressed or implied contract. Any provision contained in this bulletin may be modified or revoked without notice.
Retirement Contributions:
New members (as defined by PEPRA), 2% @ 62; "Classic" members 2% @ 55. The employee will be required to pay a portion of their annual earnings toward their retirement. The City of Oxnard does not participate in social security.


Safety Designated Positions: New members (as defined by PEPRA), 2.7% @ 57; "Classic" members 3% @ 50. The employee will be required to pay a portion of their annual earnings toward their retirement depending on their relevant MOU. The City of Oxnard does not participate in social security.

Vacation/Annual Accrual Rates:
Leave accrual rates vary between 6.24 - 11.78 hours per pay period based on years of service.

Administrative Leave:
Management employees are not compensated for overtime worked. However, the department director may authorize up to 40 hours of administrative leave in one year.

Deferred Compensation:
The City contributes 1% of employee salary to a 401(a) plan of its choosing.


Retirement Health Savings
The City contributes 1% to a retirement health savings account.

Bilingual Pay: A regular full time employee may receive bilingual pay at the rate of $50.00-$100.00 bi-weekly depending on the Level the employee is required to provide bilingual services as determined by the City Manager or designee.
Health and Dental:
Employees can choose from a variety of medical plans provided by the City. The City's contribution to medical coverage is outlined below:

Level One - For employees hired before January 1, 2023, the City contributes $1,543.00 per month toward medical insurance premiums and an additional $74.21 per month toward dental insurance premiums. Employees will receive cash back if the medical plan they choose is less than the City's monthly contribution of $1,543.00 per month. Employees who waive medical insurance will receive cash back in the amount $1,243.00 per month provided they provide proof of other qualifying coverage. Any unused dental premium monies are paid to the employee. If employees hired prior to January 1, 2023 make any changes to their health plan, they will be placed in level two.

Level Two - For employees hired on or after January 1, 2023, the City will contribute $2,054 per month towards medical insurance premiums with no cash back. Employees who waive medical insurance will receive $500.00 per month cash back provided they show proof of other qualifying coverage. The City will provide $66.80 per month towards dental insurance.

Holidays:
The City observes 12 holidays per year

Life Insurance:
City employees receive Basic Life Coverage ($7,500) + 1 times annual salary 100% paid by the City. Employees also have the option to purchase additional insurance.

Tuition Reimbursement:
Full-time employees are eligible for 100% reimbursement for work-related coursework up to a maximum of $5,000 per fiscal year.
01


Do you possess a Bachelor's degree in Computer Science, Business Administration, Information Technology, or a related field?

• Yes
• No

02


Please list your related degree(s).
03


Do you possess a minimum of five (5) years of hands-on experience in Data Engineering, Integration Engineering, Data Analysis, or a similar field?

• Yes
• No

04


If you answered yes to question 3, please describe your professional work experience. Answers that say "see resume" or "see application" will be marked as incomplete.
05


I understand the City does not offer hybrid or remote work and that this position will be reporting in office.
Required Question