Solutions Developer
Role details
Job location
Tech stack
Job description
We are seeking a highly skilled and versatile Solution Developer to join our dynamic team. This role is responsible for helping to integrate 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 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 development 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 software 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.
- 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) 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 applications comply with CJIS and other government regulations to protect sensitive public data.
- Develop, and maintain 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.
- 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 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.
Requirements
- Bachelor's degree in Computer Science, Information Technology, Business Administration or a related field., * Minimum of 3 years of experience as a Solution/Software Developer, or a related role.
- 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, PostgresSQL, 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.
Highly Desirable Experience, Qualifications and/or Certifications
- 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, Vue.js).
- Proficiency in AI-Assisted Development and LLMs for more efficient code delivery.
- 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.
- Proficiency in data modeling and design.
- Certifications in business analysis (e.g., CBAP, CCBA) or Python development (e.g., PCEP).
- Experience with cloud-based applications and enterprise systems (e.g., ERP, CRM).
- Experience developing in/with Microsoft 365 (e.g., SharePoint, PowerApps).
- Experience with Geographic Information Systems (GIS).