What are the responsibilities and job description for the Principal BI/Data Architect position at Simtra BioPharma Solutions?
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 warehouse and business intelligence architect to join an exciting opportunity for a ground up implementation of data and BI platform getting data from many Sales, Financial, Planning & Factory applications and provide best in class analytics and reporting for all levels in a pharma manufacturing company.
The BI Architect will report to VP, Technology 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 in various functions sales, marketing, finance, purchasing, supply chain and manufacturing to understand their data and reporting needs.
- Create a reporting and metrics catalog and work with consulting partners to build and execute a project plan to deliver the reporting needs.
- Architect a modern data platform which will be a combination of a cloud data warehouse/data lake, set of ETL tools, data quality tools and standards and an enterprise reporting tool for consumption of data.
- Lead the ETL tool implementation for building data pipelines for batch/real-time and near real time data into data lake.
- Define the standards for data modeling to support self-service reporting.
- Implement data retention and archival policies.
- Implement data security and governance standards for right access and PII data for European GDPR.
- Create a framework to measure data quality and report data quality issues in a timely fashion.
- Over time, create a data science platform to solve ML/AI used cases in factory.
- Lead a team of data and BI engineers to develop data pipelines and reports. Ability to work with onshore and offshore contracting teams will be required.
- Document the QA/testing and develop standards and guidelines. Implement a robust SDLC and CI/CD framework for all code and reports going into production.
- Review and monitor project teams’ adherence to design standards & implementation framework.
- Create a support process, SLAs, monitoring, alerting to support production break-fixes.
- Mentor junior engineers.
What you'll bring:
- Bachelor degree required. Computer Science, Software Engineering, Business Analytics field preferred.
- 15 years of experience in building and maintaining large data warehouses.
- 5 years of experience in implementing cloud data warehouses from scratch.
- 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, Databricks
- Strong experience in using modern ETL tools like Fivetran, dbt, Matillion or native Azure service like Azure Data Factory.
- Proven experience to use native storage, compute and data ingestion service in Azure and AWS cloud
- Hands-on and deep experience in implementing Power BI architecture and creating reports in Power BI
- Very strong in writing SQL and code in Python.
- Expertise with queuing systems like Kafka, Solace.
- Experience in understanding PLC data in manufacturing facility and building data platforms and analytics on it is a big plus.
- Experience in ingesting data from Microsoft Dynamics and creating embedded reporting using Power BI is a big plus.
#LI-AD1
#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