For over 65 years, pharmaceutical and biotech companies have partnered with Simtra BioPharma Solutions (Simtra) to bring their sterile injectable products to market.

Simtra is a world-class Contract Development Manufacturing Organization with facilities in Indiana, US and Halle/Westfalen, Germany. We offer a wide-range of delivery systems including prefilled-syringes, liquid/lyophilized vials, diluents for reconstitution, powder-filled vials, and sterile crystallization. Our product types include biologics and small molecules, cytotoxics, highly potent compounds, diluents for reconstitution and vaccines - which are all directly injected into patients worldwide. As such, at Simtra, there is a strong emphasis on quality and continuous improvement. We hold ourselves to the highest quality and regulatory standards.

While our primary focus is cGMP manufacturing, we offer many support services including formulation and development, lyophilization optimization, global regulatory support, and secondary packaging.

In addition to unmatched expertise and experience, we offer a uniquely collaborative approach. Clients look to Simtra as an extension of their own companies.

It is very rewarding industry to work in. Our teams are driven to help clients scale, innovate, and bring-life changing medicines to patients worldwide.

Your role at Simtra BioPharma Solutions:

Simtra BioPharma Solutions is looking for an enthusiastic, fast paced data engineer for a ground up implementation of data and BI platform getting data from many Sales, Financial, Planning, Manufacturing and Factory applications to provide best in class analytics and reporting for all levels in a pharma manufacturing company. The Senior Data Engineerwill report to a Principal Architect and will lead the end-to-end solution of building a cloud data warehouse platform, implementing ETL tools to pull data from source systems, model the data in data warehouse, understanding the business analytics requirement across multiple business functions and delivering the best-in-class enterprise reporting.
What you'll do:

• Work with multiple business partners and cross functional IT teams in various functions sales, marketing, finance, purchasing, supply chain and manufacturing to understand their data and reporting needs.
• Use Azure DevOps to create data stories and demonstrate weekly progress.
• Create design documents and data modeling.
• Build data pipelines from the source system to snowflake using Fivetran, DBT cloud, python, PySpark and airflow.
• Work with offshore consultants explain design and create development tasks for them as well as review their work for completeness and quality
• Create Power BI reports.
• Test data pipeline code and reports with IT and Business users
• Setup DevOps framework using DBT and DevOps repos/Github.
• Build a DevOps framework in Azure to promote code from lower environment to higher environment.
• Troubleshoot production issues and provide code fixes.
• Mentor junior engineers.

What you'll bring:

• Bachelors degree in Computer Science, Software Engineering, Business Analytics or equivalent combination of education and experience
• 5-7 years of experience in data engineering and business intelligence
• 5 years of experience in building data pipelines into Azure Data Lake and Snowflake using ETL tools like Fivetran, DBT and Airflow
• 3-5 years of writing code in python to create data pipelines between source system and target data lake.
• Excellent written and verbal communication skills
• Experience in managing onsite and offshore consultants for timely and quality delivery.
• Strong, hands-on experience in cloud data platforms like Snowflake
• Hands-on experience with batch and real-time data ingestion with snowflake and ADLS using variety of data sets
• Strong understanding of data warehouse concepts and hands-on experience in data modeling using Kimball or Data Vault methodology
• Experience in building Power BI reports and/or setting up the user administration in Power BI in a big plus.
• Experience in understanding PLC data in manufacturing facility and building data platforms and analytics on it is a big plus.

#IND-USOPS

Equal Employment Opportunity

Simtra is an equal opportunity employer. Simtra evaluates qualified applicants without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity or expression, protected veteran status, disability/handicap status or any other legally protected characteristic.

EEO is the LawEEO is the law - Poster SupplementPay Transparency Policy

Data Privacy

To learn more about Simtra's approach to data privacy, please review the Simtra Recruitment Platform Global Privacy Policy:
https://biopharmasolutions.baxter.com/simtra-recruitment-platform-privacy-policy