Sr. Data Engineer (onsite)

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 Bio Pharma 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. This position sits on site in Bloomington, Indiana.

This will 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 qualityCreate Power BI reports.Test data pipeline code and reports with IT and Business usersSetup 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 experience5-7 years of experience in data engineering and business intelligence5+ years of experience in building data pipelines into Azure Data Lake and Snowflake using ETL tools like Fivetran, DBT and Airflow3-5 years of writing code in python to create data pipelines between source system and target data lake.Excellent written and verbal communication skillsExperience in managing onsite and offshore consultants for timely and quality delivery.Strong, hands-on experience in cloud data platforms like SnowflakeHands-on experience with batch and real-time data ingestion with snowflake and ADLS using variety of data setsStrong understanding of data warehouse concepts and hands-on experience in data modeling using Kimball or Data Vault methodologyExperience 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 Law

EEO is the law - Poster Supplement

Pay Transparency Policy

Reasonable Accommodations

Simtra is committed to working with and providing reasonable accommodations to individuals with disabilities globally. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the application or interview process, please click on the link here and let us know the nature of your request along with your contact information.

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