Integration Engineer

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 Engineer to join our dynamic team. This role is responsible for integrating vendor applications and automating workflows across the city's 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.WHAT YOU'LL DO: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 city's 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 SUPERVISION EXERCISED/SUPERVISION RECEIVED: Receives general supervision and is expected to prioritize work to meet deadlines and to keep the supervisor informed of issues that would impact achievement of a deadline, organizational policy or procedure or in consideration of risk management. WORK SCHEDULE: The normal work week is Monday through Thursday 8:00am to 6:00pm and alternating Fridays 8:00am to 5:00pm. Depending on the area of assignment staff may be assigned to a shift that is outside the standard work hours. This position may be required to be available for additional hours in response to peaks in workloads and changes in department needs. The standard work environment varies depending on assignment but is typically either primarily in an office setting or out in the field. The City does not offer hybrid or remote work.PLEASE NOTE: The Information Technology Department supports public safety personnel including the Police Department. Therefore, as part of the selection process, applicants will be required to successfully complete a thorough background investigation, which includes a polygraph exam.ESSENTIAL FUNCTIONSProvide 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 initiatives to enhance security and efficiency while ensuring alignment with organizational goals.Participate in software upgrades and technology integrations, ensuring minimal disruption to business operations.Performs other duties of a similar nature and level as assigned.MINIMUM QUALIFICATIONSThe following are the minimum qualifications necessary for entry into the classification:EDUCATION:Bachelor's degree in Computer Science, Information Technology, or related fieldEXPERIENCE:Five (5) years of experience in a related field, which should include 2 years of experience comparable to a Business Systems AnalystProficiency 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.OTHER REQUIREMENTS:Must be able to speak and understand English to effectively communicate with fellow employees, customers, and vendors