Software Engineer

Software Engineer - - - - - - - - - - - - Mission: This role is ideal for someone who collaborates effectively with cross-functional teams, embraces new technologies and programming languages, and is committed to continuously expanding their technical expertise. The successful candidate is self-driven, proactive, and takes ownership of new challenges while contributing to a collaborative and innovative environment.

Thinks independently and challenges conventional approaches when appropriate.  Is adaptable and comfortable working in evolving environments.  Enjoys experimenting with new ideas and technologies to solve problems.  Takes ownership and follows through from design to delivery.  Balances innovation with practical, maintainable solutions.  Is proactive in identifying opportunities for improvement rather than waiting for direction.  Values collaboration while being capable of working autonomously.  5+ years of hands-on experience in SQL development, database programming, and performance optimization.

Design, develop, and maintain complex SQL queries, stored procedures, functions, views, and triggers.  Build scalable and efficient database solutions with a strong focus on performance.  Analyze, troubleshoot, and optimize slow-running queries and database workloads.  Design and implement database schemas that support evolving business requirements.  Develop ETL/data processing routines and automate database operations where appropriate.  Collaborate with application developers, analysts, and business stakeholders to translate requirements into robust database solutions.  Ensure data quality, integrity, security, and privacy best practices are followed.  Review, refactor, and improve existing SQL code for maintainability and efficiency.  Participate in technical discussions, contribute ideas, and evaluate alternative approaches to solving problems.  Stay current with emerging database technologies and recommend improvements where appropriate.

5+ years of SQL development experience   Strong expertise in:   SQL  PL/SQL   Python for scripting, automation, or data processing  PostgreSQL database  Database Schema Design  Query Optimization  Database Performance Tuning  Data Processing  Experience troubleshooting production database issues.  Ability to work independently with minimal supervision.  Strong analytical and problem-solving skills.  Excellent communication and collaboration skills.  Good to Have   Experience with Geographic Information Systems (GIS) or spatial databases (e.g., PostGIS).  Exposure to cloud database platforms.  Experience with CI/CD for database deployments.  Version control (Git).

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.  Experience working in Agile/Scrum teams.    Core Technology Stack   Required   SQL  PostgreSQL  Stored Procedures  Database Schema Design  SQL Optimization  Database Performance Tuning  Data Processing  Preferred    PL/SQL  Python  GIS (PostGIS or similar)