The City of Oxnard is seeking an Integration Engineer to integrate vendor applications and automate workflows across the city's various applications and services, ensuring smooth data exchange between systems. This 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.
Requirements
- 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.
- Proficiency in API design and protocols (HTTPS, SOAP, REST)
- Experience with version control systems (e.g., Git) and collaborative development workflows (e.g., GitFlow).
- Experience developing in/with Microsoft 365 (e.g., SharePoint, PowerApps)
Responsibilities
- Architect, develop, and maintain API integrations between city systems, vendor applications, and legacy databases.
- Ensure seamless integration between legacy systems and new applications via middleware, API gateways, or ETL pipelines using Python, SQL, PHP, and other relevant technologies.
- Build or maintain custom application solutions to facilitate secure data transfer between various departments and teams within the city’s agencies.
- 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.
- Develop and maintain clear documentation on system integrations, tech specs, data flow diagrams, and configuration changes.
Other
- 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.
- 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.
- Selected candidate(s) must pass a thorough background investigation.
