Senior Data Engineer/Manager

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 Takeda’s Privacy Notice and Terms of Use. I further attest that all information I submit in my employment application is true to the best of my knowledge.

Job Description

Senior Data Engineer/Manager

Bannockburn, IL

Hybrid

Job Description

OBJECTIVES/PURPOSE

• The Senior Data Engineer/Manager will enable the success of Plasma-Derived Therapies (PDT) data strategy and Takeda’s overall vision by supporting their Line Manager and partnering closely with Data Governance, Platform Engineers, Data Scientists, and other key stakeholders.

• The Senior Data Engineer will:
  • Collaborate with different IT functions to develop data models, data ingestion pipelines, and data quality processes that empower business users with real-time decision making capability.
  • Serve as a data SME for the business and IT teams in managing a highly complex data ecosystems with thousands of data attributes.
  • Build and maintain data systems and datasets that are easy to analyze and support Business Intelligence requirements, as well as downstream systems.
  • Create, maintain, and enhance data platforms and infrastructure that enables the analytics front-end; this includes the testing, maintenance, construction, and development of architectures such as high volume, large scale data processing and databases with proper verification and validation processes.

​ACCOUNTABILITIES

• Collaborate as a trusted advisor and partner to Business teams by improving data models that feed Business Intelligence tools and dashboards, increasing data accessibility, and fostering a culture of data-driven decision making across the organization.
• Develop and maintain scalable data pipelines and build out new integrations using technologies such as Databricks lakehouse and AWS to support continuing increases in data source, volume, and complexity.
• Implement processes and systems to drive data reconciliation and monitor data quality, ensuring production data is always accurate and available for key stakeholders, downstream systems, and business processes that depend on it.
• Write unit/integration/performance test scripts and perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues.

• Work closely with:
  • Team of front-end and back-end Engineers, Product Managers, and Analysts
  • Enterprise Teams to design and develop data integration patterns/solutions and data models to support different data and analytics use cases.
  • DevOps Teams to deploy data pipeline solutions in Takeda AWS environments that meet security and performance requirements.
  • Data Governance team to maintain data quality
  • Data Science team to provide the necessary data to drive models and insights

​

DIMENSIONS AND ASPECTS

Technical/Functional (Line) Expertise  

• Advanced experience and understanding of data lakehouse , data integration, data model, data catalog, data warehouse/mart, RDBMS and other modern database (Graph, No-SQL, etc.) query languages, ETL (IICS), AWS technologies ( AWS DMS, AWS Lambda, , AWS SQS, AWS Step Functions, AWS EventBridge, AWS RDS Aurora, AWS Kinesis), Scheduling (Tidal/AirFlow), Databricks platform(Sprak structured-streaming, delta tables, unity catalog), Visualization (PowerBI/Tableau), Data streaming platform (Kafka), etc.
• Working hands-on knowledge in various function/object-oriented scripting languages (i.e., Python with Pyspark, SQL, Java/Scala )

• Deep technical knowledge in DevSecOps processes (CI/CD, testing, release mgt, change mgt) and tools (GitHub Actions, Cloudformation/Terraform, Sona