Integration Engineer

*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 highly skilled and versatile Integration Engineerto join our dynamic team. This role is responsible for integrating vendor applications and automating workflows across the citys various applications and services ensuring smooth data exchange between systems. You will work closely with business stakeholders IT leadership and third-party vendors to build scalable secure and efficient integration solutions.

The role is essential in bridging gaps between vendor solutions legacy systems and a mixture of on-prem and cloud-based services to improve operational efficiency across public safety utilities and administrative departments. Therefore the ideal candidate will have strong API integration experience an automation-first mindset and the ability to work with vendors to ensure secure scalable and efficient data exchanges.

• Work closely with business stakeholders and other developers to gather document and analyze integration needs across departments.

• Become subject matter expert on vendor technologies by working closely with vendor support and in-house staff to troubleshoot and resolve issues.

• Research evaluate and recommend software tools platforms and third-party solutions to meet business and technical requirements.

• Build or maintain custom application solutions to facilitate secure data transfer between various departments and teams within the citys agencies.

• Architect and document the technical solutions for new and existing integrations translating application needs into actionable infrastructure requests (e.g. servers databases allocations) for submission to the Change Advisory Board (CAB) and infrastructure teams.

• Ensure seamless integration between legacy systems and new applications via middleware API gateways or ETL pipelines using Python SQL PHP and other relevant technologies.

• Ensure integrations comply with CJIS and other government regulations to protect sensitive public data.

• Architect develop and maintain API integrations between city systems vendor applications and legacy databases.

• Translate business needs into technical integration workflows including design planning and execution of generated action items.

• Monitor troubleshoot and optimize application performance and scalability identifying and addressing bottlenecks and performance issues.

• Implement security best practices to protect against common web application vulnerabilities such as SQL injection cross-site scripting (XSS) and cross-site request forgery (CSRF).

• Leverage automation tools to streamline repetitive integration tasks.

• Write clean efficient and well-documented code following best practices and coding standards.

• Develop and maintain clear documentation on system integrations tech specs data flow diagrams and configuration changes.

• Prioritize work based on business impact resource constraints and project schedules.

• Contribute to the continuous improvement of development processes and practices suggesting and implementing improvements to streamline workflows and increase productivity.

• Other responsibilities as the role may require.

Payroll Title/Classification: Business Systems Analyst Senior

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

• Provide technical guidance to the IT team fostering a culture of collaboration and innovation.

• Design implement and/or maintain scalable and secure IT solutions.

• Optimize IT systems and operations to ensure high availability reliability and performance.

• Conduct technical evaluations feasibility studies and cost-benefit analyses for IT initiatives and investments.

• Adhere to IT policies procedures and standards to ensure compliance and security best practices.

• Troubleshoot complex technical issues and provide timely resolutions to minimize downtime and disruptions.

• Collaborate with cross-functional teams including software developers engineers and project managers to integrate systems and improve overall IT efficiency.

• Stay current with industry trends and advancements to recommend and implement innovative solutions that drive continuous improvement.

• Drive nitiatives to enhance security and efficiency while ensuring alignment with organizational goals.

• Participate in software upgrades andtechnology integrations ensuring minimal disruption to business operations.

• Performsother duties of a similar nature and level as assigned.

The following are the minimumqualifications necessary for entry into the classification:

EDUCATION:

• Bachelors degree in Computer Science Information Technology Business Administration or related field

• Five (5) years of experience in a related field which should include 2 years of experience comparable to a Business Systems Analyst
• Proficiency in full-stack development using Python SQL PHP Javascript or similar technologies.

• Strong scripting skills (e.g. Python PowerShell Bash) and understanding of unit testing and deployment strategies.

• Solid understanding of on-premise application and database server architecture (e.g. Windows/Linux SQL Server/MySQL) and the ability to define technical specifications for new infrastructure builds.

• Familiarity with ETL tools and data transformation (Apache SSIS or other) relational databases (MSSQL PostgresQL or other RDBMS) and data validation concepts.

• Solid understanding of business analysis methodologies including requirements gathering process mapping and documentation.

• Excellent problem-solving skills and attention to detail with the ability to analyze complex technical issues and propose effective solutions.

• Strong communication and interpersonal skills with the ability to work effectively in a team environment and collaborate with stakeholders from diverse backgrounds.

• Local government or public sector experience especially public safety (police and fire).

• Experience with building custom interfaces using frontend technologies such as HTML CSS JavaScript and modern JavaScript frameworks/libraries (e.g. React ).

• Proficiency in API design and protocols (HTTPS SOAP REST)

• Experience with version control systems (e.g. Git) and collaborative development workflows (e.g. GitFlow).

• Previous experience in a hybrid role combining technical and business analysis responsibilities.

• Proficient in data modeling and design.

• Certifications in business analysis (e.g. CBAP CCBA) or Python development (e.g. PCEP).

• Experience developing in/with Microsoft 365 (e.g. SharePoint PowerApps)

• Experience with cloud-based applications and enterprise systems (e.g. ERP CRM).

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

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.There is currently one (1) full-time vacancy within the IT Department.

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

UNION MEMBERSHIP:Positions in this classification are represented by theOxnard Mid Managers 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 Citys 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. you have any questions regarding this recruitment please contactVivian Morales 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.