[Remote] Data/Fullstack Software Engineer

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