Note: The job is a remote job and is open to candidates in USA. Theoris Services is an information technology and engineering staffing company that connects consultants with client opportunities and supports their professional growth. The Data/Full Stack Software Engineer will design, build, and maintain scalable scientific data platforms, pipelines, and full-stack applications for pharmaceutical research. The role includes developing data integrations, APIs, user interfaces, visualizations, cloud architectures, testing, performance optimization, and collaboration with scientific and cross-functional stakeholders.
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+)
- 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
- Experience building RESTful APIs with proper versioning, error handling, and documentation using FastAPI, Flask, Django, Express.js, or similar
- Desired: Experience with lakehouse architectures and federated query engines (Trino/Presto) at scale
- Desired: Familiarity with scientific data domains (compounds, assays, experimental results) or life-sciences tools (Benchling, computational chemistry platforms)
- Desired: Experience implementing enterprise authentication (SSO, LDAP) and fine-grained access controls
- Desired: Prior work in pharmaceutical, biotech, or scientific research environments
- Desired: 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
Company H1B Sponsorship