Software Developer & Database Architect

**Position Summary:** Design, develop and maintain scalable data management platforms, dashboards and backend systems to support a county‑wide environmental monitoring program. The role combines software development, database architecture and systems integration to process, store and visualize multi‑source environmental data reliably and securely. **Key Responsibilities:** * Design and implement robust database architectures (relational and spatial) and data models to support environmental monitoring datasets. * Develop backend services, APIs and ETL pipelines for ingesting, validating and transforming data from multiple sources (field devices, labs, satellite/UAV, third‑party feeds). * Build interactive dashboards and visualization components for data exploration, reporting and decision support. * Optimize application and database performance, ensure scalability and high availability. * Implement data security, access control, backup and recovery procedures; ensure compliance with data confidentiality requirements. * Apply software engineering best practices: version control, automated testing, CI/CD and documentation. * Collaborate with GIS specialists, data engineers, statisticians and field teams to translate requirements into technical solutions. * Prepare technical specifications, system architecture diagrams and deployment plans. * Provide troubleshooting, maintenance and support for production systems; monitor system health and respond to incidents. * Support knowledge transfer and provide training documentation for client staff. **Qualifications:** * Bachelor’s degree in Computer Science, Information Technology, Software Engineering or a related field. * Strong understanding of database design, data modeling and data warehousing principles. * Familiarity with spatial data and geodatabases is an advantage. **Experience:** * 3-5 years of professional experience in software development and database architecture. * Proven experience building data platforms, ETL processes, APIs and dashboards for medium to large datasets. * Experience integrating diverse data sources and optimizing database performance. **Technical Skills:** * Programming: Python and/or JavaScript; experience with backend frameworks (e.g., Flask, Django, Node.js). * Databases: SQL (PostgreSQL/PostGIS preferred), NoSQL (e.g., MongoDB) and knowledge of schema design and indexing. * Data processing: ETL tools, data pipelines, and familiarity with workflow orchestration (e.g., Airflow) beneficial. * Data visualization: experience with BI tools or libraries (e.g., Tableau, Power BI, D3, Plotly). * APIs and integration: RESTful API development and experience with JSON, GeoJSON. * DevOps/Deployment: familiarity with Docker, CI/CD, cloud services (AWS/Azure/GCP) and monitoring tools. * Testing, version control (Git) and automated build/test practices. Work Location: In person