Lead Software Engineer (Santa Monica, CA)

Collectly; Santa Monica (CA); On-site; USD 180,000 - 220,000; Full time

Job summary

Collectly seeks a skilled software engineer to develop and enhance features, focusing on secure, scalable code and robust data pipelines. The role includes integrating with EHR systems, building ETL workflows, and designing efficient PostgreSQL schemas.

You will collaborate across founders, frontend, UX, and other teams to ship high-quality features in a fast-paced environment. You will drive architectural decisions, explore new tools, and mentor peers while delivering customer-centric

Qualifications

• Associate’s degree in Software Engineering or equivalent.
• 6 years of experience as Web/Python Developer.
• Knowledge of PostgreSQL internals, autovacuum, and transaction isolation levels.
• Experience optimizing queries with PostgreSQL features, including CTEs and Window Functions.
• Proficiency with Docker, multi-stage Dockerfiles, cross‑platform images, and multi-container orchestration.
• Experience deploying scalable services with Kubernetes and AWS (EKS), resource definitions, traffic routing, and autoscaling.
• Experience with SQLAlchemy, polymorphic relationships, and avoiding N+1 queries.
• Building RESTful services with FastAPI/Flask, including validation, async endpoints, and middleware.
• Front-end integration with RESTful APIs and modern JavaScript frameworks.
• Proficiency in C# and .NET Framework, CI/CD with GitLab, and ETL workflows with Celery Canvas.
• Strong Python async programming (asyncio).

Responsibilities

• Develop and enhance Collectly features in a secure, well-tested, scalable manner.
• Integrate Collectly with EHR systems.
• Build and maintain ETL data pipelines.
• Design scalable PostgreSQL schemas and optimize queries.
• Collaborate cross-functionally to deliver high-quality features.
• Engage with customers to gather feedback and align with needs.
• Research emerging tools and guide architectural decisions.
• Solve complex technical problems with high-quality code and maintainability.
• Participate in code reviews and mentor peers.
• Address technical debt with sustainable improvements.
• Represent Collectly in customer discussions and technical conversations.
• Independently ship small to mid-sized features and contribute to larger initiatives.
• Lead integration efforts for Pre-visit Intake Automation, AI Eligibility & Benefits, and AI Cost Estimates.

Skills

6 years experience (Web/Python)

PostgreSQL internals

Python performance optimization

CTEs & Window Functions

Docker & multi-stage builds

Kubernetes & AWS (EKS)

SQLAlchemy & ORM patterns

RESTful APIs (FastAPI/Flask)

Education

Associate’s degree in Software Engineering

Tools

Docker

Kubernetes

AWS / EKS

GitLab CI/CD

PostgreSQL

SQLAlchemy

FastAPI/Flask

Celery Canvas & async

Job description

Duties

• Develop and enhance features for the Collectly product in a secure, well-tested, and performantmanner.
• Integrate Collectly with Electronic Health Records (EHR) systems.
• Build and maintain ETL data pipelines.
• Design scalable database schemas and optimize queries for PostgreSQL.
• Collaborate cross-functionally with Founders, Frontend, UX, and other core team members todeliver high-quality features in a fast-paced, iterative environment.
• Engage with customers to gather feedback, understand workflows, and ensure productimprovements align with real-world needs.
• Conduct technical research on emerging tools, frameworks, and best practices to improveCollectly’s platform and guide architectural decisions.
• Solve complex technical problems while maintaining high standards for code quality,maintainability, and scalability.
• Participate in code reviews to uphold internal standards and mentor peers.
• Identify and address technical debt, proposing sustainable solutions to improve team efficiency.
• Represent Collectly and its values in customer interactions, external communications, andtechnical discussions around projects.
• Independently ship small and mid-sized features, while collaborating with the team on largerinitiatives.
• This position leads integration efforts for Pre-visit Intake Automation, AI Eligibility and Benefits,and AI Cost Estimates products.

Requirements

• Associate’s degree in Software Engineering, or similar field, and 6 years of experience as a WebDeveloper or Python Developer.

• Knowledge of:
  - PostgreSQL internals, autovacuum, and transaction isolation levels;
  - Python internals, including details of data type implementation regarding memorymanagement and performance optimization.

• Experience in:
  - optimizing database queries using advanced PostgreSQL features;
  - using CTEs, Window Functions, and complex data types in PostgreSQL;
  - building containerized applications with Docker, writing multi-stage Dockerfiles, buildingcross-platform Docker images, and orchestrating multi-container environments;
  - deploying scalable services using Kubernetes and AWS, managing EKS clusters, definingresources, configuring traffic routing, and implementing autoscaling;
  - architecting CI/CD pipelines on GitLab;
  - building complex data schemas and queries using SQLAlchemy while implementingpolymorphic relationships and preventing N+1 problems;
  - building RESTful web services using FastAPI and Flask, utilizing validation, asyncendpoints, and middleware;
  - building dynamic JavaScript web applications using modern frameworks and integratingthem with RESTful APIs;

  - building and deploying web applications using C# and .NET Framework;
  - complex ETL workflows using Celery Canvas primitives, while managing intermediate stateand monitoring queue health; and
  - Python asynchronous programming (asyncio, coroutines, and event loops).

$200,000 - $200,000 a year