Software Engineer

About K3-Innovations K3-Innovations, Inc. is building a cutting-edge, database-driven SaaS platform designed to streamline data workflows in the biopharma industry. We are seeking a Full Stack Developer with strong expertise in Python , JavaScript , and PostgreSQL to join our team. This role will focus on backend and database development, with additional responsibility for creating lightweight, user-friendly dashboards. If you're passionate about data-centric development and skilled in crafting robust backend systems and seamless frontends, we want to hear from you. Key Responsibilities

1. Database Design and Optimization (Priority #1) :

• Architect and implement relational database schemas for managing large datasets.
• Write and optimize complex SQL queries for processing and validating data.
• Ensure high performance through indexing, query tuning, and database partitioning.
• Handle database migrations using tools like Alembic .

1. Backend Development :

• Build scalable REST APIs using Flask and Python .
• Develop workflows to process, validate, and export data efficiently.
• Ensure secure and scalable backend architecture.

1. Frontend Development (Lightweight) :

• Build intuitive dashboards using React and JavaScript for interacting with the platform.
• Integrate REST APIs into frontend components for real-time data interactions.
• Ensure user-centric designs with minimal frontend complexity.

1. Collaboration and Ownership :

• Work closely with stakeholders to define requirements and ensure smooth data workflows.
• Take ownership of the development process from schema design to deployment.

• PostgreSQL :
• Strong proficiency in SQL, including advanced queries (joins, CTEs, aggregations).
• Experience with database indexing, partitioning, and performance tuning.
• Familiarity with advanced features like views, triggers, and stored procedures.
• Database Design :
• Proven experience designing relational schemas for large-scale data.
• Hands-on experience with database migrations using tools like Alembic .

• Python :
• Strong programming skills with a focus on building and optimizing backend systems.
• Flask :
• Experience developing REST APIs using Flask or similar frameworks.
• SQLAlchemy :
• Familiarity with ORM tools to manage database interactions.

• JavaScript/React :
• Basic proficiency in building responsive, lightweight dashboards with React.
• Ability to integrate REST APIs and handle simple state management.

• Docker :
• Experience containerizing applications and managing multi-service environments.
• CI/CD :
• Familiarity with automated deployment workflows (e.g., GitHub Actions).

• Working with large, industry-specific datasets (e.g., biopharma, healthcare).
• Familiarity with SDTM and ADaM standards in clinical trials.
• Experience with statistical tools or R-based APIs like Plumber.

• Database Specialist : Your expertise in PostgreSQL and relational database design is critical.
• Backend-Focused Developer : You thrive on building secure, scalable, and efficient APIs.
• Collaborator and Problem-Solver : You enjoy tackling complex challenges and delivering impactful solutions.

• Meaningful Work : Contribute to a platform that transforms how data is managed in the biopharma industry.
• Professional Growth : Be a core contributor to a technology-driven organization.
• Remote Flexibility : Work from anywhere with a results-oriented approach.
• Competitive Compensation : Attractive salary and benefits tailored to your expertise.