Data/Fullstack Software Engineer

Reporting into the Scientific Applications and Data Platforms organization, the Data/Full Stack Software Engineer will design, build, and maintain scalable data pipelines and full-stack applications that enable scientists to access, analyze, and visualize multibillion-record scientific datasets. You will own the end-to-end delivery of data platforms and user-facing tools, ensuring robust, performant, and user-friendly solutions that support growing data volumes and cross-functional scientific teams.

Job Title: Data/Full Stack Software Engineer
 
Location: Indianapolis, IN (remote)
 
Industry: Pharmaceutical
 
Job Description:
Theoris Services is assisting our client in their search for a Data/Full Stack Software Engineer to add to their growing team. Our client is a leader and innovator in scientific research and pharmaceutical discovery. They leverage advanced data platforms and modern applications to accelerate insights from complex experimental and compound data. We seek those who share a commitment to scientific excellence, innovation, and high-quality software delivery. Reporting into the Scientific Applications and Data Platforms organization, the Data/Full Stack Software Engineer will design, build, and maintain scalable data pipelines and full-stack applications that enable scientists to access, analyze, and visualize multibillion-record scientific datasets. You will own the end-to-end delivery of data platforms and user-facing tools, ensuring robust, performant, and user-friendly solutions that support growing data volumes and cross-functional scientific teams.
 
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

 
Requirements:

• 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+)
• Expert-level experience with React (preferred), Vue, or Angular; deep understanding of HTML5, CSS3, responsive design, state management, and modern frontend tooling
• 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

 
Desired:

• Experience with lakehouse architectures and federated query engines (Trino/Presto) at scale
• 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

 
Best-In-Class-Benefits:
We are in the people business; treating people right is our ONLY priority. Theoris Services consultants are full-time employees with full benefits, including:

• Robust Health Insurance
• 401(k) plan
• PTO
• Paid holidays

 
About Theoris:
Our goal is to Fuel Your Career! As a Theoris team member, you join a culture based on people-centered values and an environment that fosters both personal and professional growth. We build long-term relationships with our clients and our consultants. With over 30 years of building strong relationships in the industry, we’re uniquely positioned to make the right connections. This knowledge is used to find the right job placement. Our recruiting teams are experts dedicated to the information technology and engineering staffing space and are highly respected by our client base.