Develop and maintain backend services using Python and FastAPI focusing on creating high-performance and scalable APIs, ensuring proper error handling, input validation, and adherence to best practices
Work with SQLModel and SQLAlchemy to manage and manipulate data in our PostgreSQL backend, ensuring efficient data retrieval and storage
Implement and optimize CRUD operations, working closely with core objects and view definitions
Collaborate on database schema design and optimization to support new features and improve performance
Integrate and maintain connections to supported cloud warehouses, particularly Snowflake, ensuring seamless data flow between our platform and external data sources
Ensure robust and secure communication between our platform and external services, handling data transformation and synchronization as needed
Integrate and maintain our platform's connection to data visualization tools such as Sigma. Ensure seamless data flow and optimal performance for visual analytics.
Write clean, maintainable, and well-documented code, adhering to best practices in software development
Contribute to the testing suite by writing and maintaining unit and integration tests using Pytest, ensuring high test coverage and reliability
Participate in code reviews, providing and receiving constructive feedback to improve code quality and team collaboration
Work closely with frontend engineers to define API specifications and ensure seamless integration between frontend and backend systems
Actively participate in sprint cycles, providing estimates, updates, and technical insights to help guide the development process
Requirements
5+ years of experience in backend development, particularly with Python and FastAPI in an enterprise production environment
Strong proficiency in SQL and experience with SQLAlchemy and SQLModel for database management and ORM
Experience with PostgreSQL, including schema design, query optimization, and performance tuning
Hands-on experience with task queues like Celery, including task scheduling, execution, and optimization
Strong understanding of testing practices, with experience writing unit and integration tests using Pytest.
Familiarity with version control systems like Git, and experience with CI/CD pipelines, particularly GitLab CI
Excellent problem-solving skills with the ability to troubleshoot and optimize backend performance
Experience working in an Agile development environment, with a focus on collaboration and continuous improvement
Benefits
Medical Insurance
Dental Insurance
PTO
16 annual company holidays
401K
Vision Insurance
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
PythonFastAPISQLSQLAlchemySQLModelPostgreSQLCRUD operationsPytestCeleryAgile development
Soft skills
problem-solvingcollaborationcommunicationcode reviewconstructive feedbackteamworkadaptabilityattention to detailcritical thinkingtime management