Solution Developer

About the role

The City of Oxnard's Information Technology Department is seeking a highly skilled and versatile Solution Developer to join our dynamic team. This role is essential in integrating vendor applications and automating workflows across various city applications and services, ensuring smooth data exchange between systems.

Responsibilities

• Work closely with business stakeholders and other developers to gather, document, and analyze software needs across departments.
• Become a subject matter expert on vendor technologies by working closely with vendor support and in-house staff to troubleshoot and resolve issues.
• Build or maintain custom application solutions to facilitate secure data transfer between various departments and teams within the city’s agencies.
• Document the technical solutions for new and existing applications, translating application needs into actionable infrastructure requests (e.g., servers, databases, allocations).
• 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 applications comply with CJIS and other government regulations to protect sensitive public data.
• Develop, maintain, and optimize API integrations between city systems, vendor applications, and legacy databases.
• Translate business needs into technical workflows, including design, planning, and execution of generated action items.
• Maintain 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 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.

Requirements

• Education: Bachelor’s degree in Computer Science, Information Technology, or related field.
• Experience: Three (3) years of experience comparable in a related field.
• Skills: 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.

Qualifications

• Education: Bachelor’s degree in Computer Science, Information Technology, or related field.
• Experience: Three (3) years of experience comparable in a related field.
• Skills: 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.

Skills

• Full-stack development using Python, SQL, PHP, Javascript or similar technologies.
• Strong scripting skills (e.g. Python, PowerShell, Bash).
• Familiarity with ETL tools and data transformation (Apache, SSIS, or other).
• Solid understanding of on-premise application and database server architecture (e.g., Windows/Linux, SQL Server/MySQL).
• Understanding of business analysis methodologies, including requirements gathering, process mapping, and documentation.
• Excellent problem-solving skills and attention to detail.
• Strong communication and interpersonal skills.

Benefits

N/A

Pay

N/A

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.

Union Information

This position is represented by the Oxnard Mid-Manager's Association (OMMA).