Senior Data Engineer

Company: Takeda Pharmaceutical
Location: Presto
Posted on: May 26, 2023

Job Description:

By clicking the Apply button, I understand that my employment application process with Takeda will commence and that the information I provide in my application will be processed in line with Takedas and . I further attest that all information I submit in my employment application is true to the best of my knowledge.Job DescriptionAbout the role:At Takeda, we are a forward-looking, world-class R&D organization that unlocks innovation and delivers transformative therapies to patients. By focusing R&D efforts on four therapeutic areas and other targeted investments, we push the boundaries of what is possible in order to bring life-changing therapies to patients worldwide.Join Takeda as a Senior Data Engineer where you will lead the implementation of development, testing, automation tools and IT infrastructure in line with SDLC principles and leading implementation of DevOps through the entire architecture. You will report to the Head, Digital Platforms and Manufacturing Informatics Cell Therapy and will be a part of the Cell Therapy Engineering and Automation team.How you will contribute:

• Lead the implementation of various development, testing, automation tools and IT infrastructure in line with SDLC principles and leading implementation of DevOps through the entire architecture. Specifically, lead continuous improvement and build continuous integration, development, and constant deployment pipelines.
• Write code to develop and test the required solution and architecture features to enable seamless data pipelining and flow to many different end-applications such as front-end visualization platform, Tableau dashboards etc.
• Test the code using the appropriate testing approach. Deploys software to production servers. Contributes code documentation, maintains playbooks, and provides timely progress updates
• Define relational tables, primary and foreign keys, and stored procedures to create a data model structure. Evaluates existing data models and physical databases for variances and discrepancies
• Oversee the active maintenance and improvement of current data warehouses and data pipelines.
• Create training documentation and trains junior team members on data pipelining, CI/CD processes, as well as architecture implementation and testing as well as stipulates system troubleshooting support.
• Actively communicate with scientists, analytical and process development leads, manufacturing, non-clinical and clinical teams to inform QbD (Quality-by-Design) and systems approaches, data analyses, and engineered improvements driving discovery and development.
• Provide and support the implementation of engineering solutions by building relationships and partnerships with key stakeholders, determining and carrying out necessary processes, monitoring progress and results, recognizing and capitalizing on improvement opportunities, adapting to competing demands, organizational changes, and new responsibilities.
• Demonstrate up-to-date expertise and apply this to development, execution and improvement of infrastructure setup and provide guidance to others by supporting and aligning efforts by multiple stakeholders.
• Work in a matrixed environment by leading projects using a product mindset.Minimum Requirements/Qualifications:
  • Masters degree or higher in a quantitative discipline such as Statistics, Mathematics, Engineering, or Computer Science.
  • 4+ years of experience working in data engineering role in an enterprise environment
  • Entry-level certification with AWS Cloud or prior experience with developing solutions on cloud computing services and infrastructure in the data and analytics space.
  • Strong experience developing, working in, and maintaining production data pipelines and production data warehouses
  • Strong understanding of Software Development Life Cycle (SDLC) as it applies to data systems and project planning/execution skills including estimating and scheduling.
  • Knowledge of professional software engineering practices & best practices for the full software development life cycle, including coding standards, code reviews, source control management (especially Github), build processes, testing, and operations
  • Prior experience working in healthcare/pharmaceutical industry.
  • Ability to read/write Python and R scripts for building data transformation pipelines
  • Demonstrated experience with a variety of relational database and data warehousing technology such as AWS Redshift, Athena, RDS, BigQuery
  • Demonstrated experience with big data processing systems and distributed computing technology such as Databricks, Spark, Sagemaker, Kafka, etc.
  • Solution-oriented enabler mindset and excellent problem-solving skills.
  • Demonstrated experience working at different levels of leadership in a technical project including individual contributor work.
  • Prior experience working with non-technical stakeholders to deliver working data content for consumption via adhoc analysis.
  • Strong interpersonal and communication skills (verbal and written)
  • Collaborative mindset and teamwork, with the ability to challenge and engage an audience towards better outcomes
  • Ability and prior experience navigating a challenging, matrixed organization
  • Ability and willingness to multi-task across a range of functional and technical contextsNice-to-haves:
    • Prior experience with data analysis including aggregation, cross-data-set analyses, generating confusion matrices, exception finding, and data mapping
    • Ability to read/write ANSI-compatible SQL from scratch including selects and aggregate functions, DDL/DML
    • Prior experience in consulting or analytics project delivery through the entire software lifecyle: Requirements, Design, Testing, Deployment
    • Prior experience developing documentation for a data platform
    • Prior experience designing and implementing data architectures, including tables, views, facts, dimensions
    • Prior experience with Data Engineering projects and teams at an Enterprise level
    • Strong experience with ETL/ELT design and implementations in the context of large, disparate, and complex datasets
    • Prior experience managing, overseeing, and guiding junior data engineers.
    • Prior experience working in manufacturing facilities. What Takeda can offer you:
      • Comprehensive Healthcare: Medical, Dental, and Vision
      • Financial Planning & Stability: 401(k) with company match and Annual Retirement Contribution Plan
      • Health & Wellness programs including onsite flu shots and health screenings
      • Generous time off for vacation and the option to purchase additional vacation days
      • Community Outreach Programs and company match of charitable contributions
      • Family Planning Support
      • Flexible Work Paths
      • Tuition reimbursementMore about us:At Takeda, we are transforming patient care through the development of novel specialty pharmaceuticals and best in class patient support programs. Takeda is a patient-focused company that will inspire and empower you to grow through life-changing work.Certified as a Global Top Employer, Takeda offers stimulating careers, encourages innovation, and strives for excellence in everything we do. We foster an inclusive, collaborative workplace, in which our teams are united by an unwavering commitment to deliver Better Health and a Brighter Future to people around the world.This position is currently classified as "hybrid" in accordance with Takeda's Hybrid and Remote Work policy.Base Salary Range: $102,200.00 to $146,000.00, based on candidate professional experience level. Employees may also be eligible for Short-term and Long-Term Incentive benefits as well. Employees are eligible to participate in Medical, Dental, Vision, Life Insurance, 401(k), Charitable Contribution Match, Holidays, Personal Days & Vacation, Tuition Reimbursement Program and Paid Volunteer Time Off.The final salary offered for this position may take into account a number of factors including, but not limited to, location, skills, education, and experience.#LI-Hybrid#LI-AA1EEO StatementTakeda is proud in its commitment to creating a diverse workforce and providing equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, parental status, national origin, age, disability, citizenship status, genetic information or characteristics, marital status, status as a Vietnam era veteran, special disabled veteran, or other protected veteran in accordance with applicable federal, state and local laws, and any other characteristic protected by law.LocationsBoston, MAWorker TypeEmployeeWorker Sub-TypeRegularTime TypeFull time

Keywords: Takeda Pharmaceutical, Pittsburgh , Senior Data Engineer, Engineering , Presto, Pennsylvania