Senior Python Data Engineer

Summary

Join 3Pillar Global as a Senior Data Python + AWS Engineer to build impactful software products and deliver exceptional capabilities for clients. Develop and refine strategies for acquiring research data, engineer custom file parsers, and architect robust data models and scalable data pipelines. Perform comparative analysis of datasets and create visualizations and reports using various platforms. Contribute to client success and solidify 3Pillar Global's position as a leading product development services company. This role requires strong Python and SQL skills, experience with data visualization tools, and excellent communication skills. The ideal candidate will have a passion for data problems and experience in the pharmaceutical or biotech industry.

Requirements

• 5+ years of building solutions as a Data Engineer or similar fields
• 3+ years working in Python and SQL with a focus on data
• Excellent communication skills, attention to detail, and the confidence to take control of project delivery
• Quickly understand a highly technical product and effectively communicate with product management and engineering

Responsibilities

• Develop and refine strategies for acquiring research data from scientific laboratory instruments
• Engineer and operationalize custom file parsers to handle diverse instrument output formats—including .xlsx, .pdf, .txt, .raw, .fid, and a variety of proprietary vendor binaries
• Architect and implement robust data models, along with scalable data pipelines, comprehensive unit and integration tests, and modular utility libraries
• Perform comparative analysis of datasets generated by similar instruments or workflows to design shared, extensible data model components
• Create visualizations, reports, and interactive dashboards leveraging platforms such as Streamlit, Tableau, Jupyter Notebook, and others

Preferred Qualifications

• Experience with data plotting dashboarding tools like Streamlit, Tableau, Jupyter Notebook is a plus
• Passionate about data problems and using AI and LLM to come up with creative ideas
• A degree in biology or chemistry or relevant fields OR > 3 years of work experience in pharmaceutical or biotech industry in scientific data engineering, data modeling, or data analytics
• Exposure to DevOps practices in cloud environments

Benefits

• Career growth and development
• Physical and mental wellbeing: as a company, we spend a whole trimester in our annual cycle focused on wellbeing. Whether it is taking advantage of fitness offerings, mental health plans (country-dependent), or simply leveraging unlimited PTO to take some needed time off, we want all of our team members operating at their best