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
Didn't find what you're looking for? Search again!
Loading more jobs...