Principal BI/Data Architect

Simtra BioPharma Solutions
Bloomington, IN Remote Full Time
POSTED ON 5/7/2024 CLOSED ON 5/15/2024

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

 

Sales Associate Bi-lingual
Tipton Mills Foods -
Columbus, IN
Enterprise Architect
Astrion -
Bedford, IN
Principal Utilities Engineer
Simtra BioPharma Solutions -
Bloomington, IN

For Employer
Looking for Real-time Job Posting Salary Data?
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Principal BI/Data Architect?

Sign up to receive alerts about other jobs on the Principal BI/Data Architect career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$118,672 - $145,916
Income Estimation: 
$115,408 - $152,678
Income Estimation: 
$136,983 - $165,201
Income Estimation: 
$135,443 - $183,933
Income Estimation: 
$120,063 - $162,529
Income Estimation: 
$129,317 - $164,950
Income Estimation: 
$150,815 - $193,615

Sign up to receive alerts about other jobs with skills like those required for the Principal BI/Data Architect.

Click the checkbox next to the jobs that you are interested in.

  • BI Analytics/Reporting Tools Skill

    • Income Estimation: $83,569 - $105,822
    • Income Estimation: $85,216 - $116,970
  • Big Data Skill

    • Income Estimation: $116,473 - $144,260
    • Income Estimation: $142,479 - $178,572
This job has expired.
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Simtra BioPharma Solutions

Simtra BioPharma Solutions
Hired Organization Address Bloomington, IN Full Time
For over 65 years, pharmaceutical and biotech companies have partnered with Simtra BioPharma Solutions (Simtra) to bring...
Simtra BioPharma Solutions
Hired Organization Address Bloomington, IN Full Time
Simtra BioPharma Solutions (Simtra) is a world-class Contract Development Manufacturing Organization, partnering with ph...
Simtra BioPharma Solutions
Hired Organization Address Bloomington, IN Full Time
Simtra BioPharma Solutions (Simtra) is a world-class Contract Development Manufacturing Organization, partnering with ph...
Simtra BioPharma Solutions
Hired Organization Address Bloomington, IN Full Time
Simtra BioPharma Solutions (Simtra) is a world-class Contract Development Manufacturing Organization, partnering with ph...

Not the job you're looking for? Here are some other Principal BI/Data Architect jobs in the Bloomington, IN area that may be a better fit.

Data Architect

BJSS, Edinburgh, IN

Principal, SOC Security Architect Engineer

indie Semiconductor, Edinburgh, IN