Note: The job is a remote job and is open to candidates in USA. Theoris Services is assisting a pharmaceutical and scientific research client that uses advanced data platforms and modern applications to accelerate discovery. The Data/Full Stack Software Engineer will design, build, and maintain scalable data pipelines, lakehouse platforms, APIs, and user-facing applications that enable scientists to access, analyze, and visualize complex scientific datasets.
Responsibilities
- Design, build, and optimize data pipelines and ETL/ELT processes for scientific data integration across 30+ heterogeneous data sources
- Implement and maintain lakehouse architectures on AWS (S3, Glue, Athena) supporting multibillion-record scientific datasets
- Develop federated query capabilities using Trino and other distributed query engines to enable unified data access
- Build data harmonization solutions to standardize compound, assay, and experimental data across modalities
- Design and develop responsive, intuitive web applications using modern JavaScript/TypeScript frameworks (React preferred; Vue or Angular acceptable)
- Build robust backend services and RESTful APIs using Python (FastAPI, Flask, Django) or Node.js
- Create data-rich user interfaces that enable scientists to search, filter, and visualize complex compound, assay, and experimental data
- Implement full-stack features from database/query layer to UI, ensuring seamless end-to-end functionality
- Develop reusable component libraries and establish frontend architecture patterns
- Integrate applications with federated data platforms, query engines (Trino, PostgreSQL, Snowflake/Iceberg), and scientific databases
- Build API integrations with external systems including Benchling, Spotfire, computational chemistry tools, and AI/ML model endpoints
- Implement authentication and authorization using enterprise identity management (SSO, LDAP, content-based access controls)
- Develop data visualization components for scientific datasets including dose-response curves, chemical structures, and analytical results
- Optimize database and query performance for PostgreSQL, Iceberg, and other platforms handling complex analytical workloads
- Implement caching strategies, query optimization, and efficient data retrieval patterns for large datasets
- Monitor and troubleshoot data pipeline and application performance; address bottlenecks proactively
- Design scalable architectures that support growing data volumes and user bases
- Implement data validation, quality checks, monitoring frameworks, and comprehensive metadata/documentation
- Ensure compliance with data governance policies and regulatory requirements
- Implement CI/CD pipelines for automated testing and deployment; deploy and manage applications on AWS (EC2, ECS, Lambda, S3)
- Write unit, integration, and end-to-end tests; participate in code reviews and contribute to engineering best practices
- Partner with UX designers, scientists, and stakeholders across therapeutic areas to gather requirements, conduct user testing, and iteratively improve usability
Skills
- Bachelor's degree in Computer Science, Software Engineering, Data Engineering, Information Systems, or a related technical field
- 3+ years of professional experience combining data engineering/data warehousing and full-stack web development
- Proven track record of building production-grade data pipelines/platforms and delivering production web applications with high user engagement
- Strong proficiency in Python and SQL; solid JavaScript/TypeScript (ES6+)
- Experience building RESTful APIs with proper versioning, error handling, and documentation using FastAPI, Flask, Django, Express.js, or similar
- Deep expertise in relational databases (PostgreSQL, Oracle/MySQL) and modern data warehouses/lakehouses (Snowflake, Redshift, Iceberg)
- Hands-on experience with AWS services (S3, Glue, Athena, Lambda, RDS, EC2, ECS)
- Experience with distributed processing frameworks (Spark, Trino, Presto or similar) and building scalable ETL/ELT pipelines
- Experience with scientific or business visualization tools (Spotfire, Power BI) and building custom data visualization components
- Experience with Git and collaborative development workflows
- Strong problem-solving skills with the ability to debug complex data and application issues
- Excellent communication skills to translate technical concepts for scientific and non-technical stakeholders
- Ability to work independently and collaboratively in cross-functional teams
- Attention to detail and commitment to data quality, accuracy, performance, and user experience
- Familiarity with scientific data domains (compounds, assays, experimental results) or life-sciences tools (Benchling, computational chemistry platforms)
- Experience implementing enterprise authentication (SSO, LDAP) and fine-grained access controls
- Prior work in pharmaceutical, biotech, or scientific research environments
- Experience with AI/ML model endpoint integration
- Expert-level experience with React (preferred), Vue, or Angular; deep understanding of HTML5, CSS3, responsive design, state management, and modern frontend tooling
Benefits
- Robust Health Insurance
- 401(k) plan
- PTO
- Paid holidays
- Personal and professional growth
Company Overview