Chuo Astellas Pharma Inc. Permanent
Description 【About Astellas】 As part of the Astellas commitment to delivering value for our patients, our organization is currently undergoing transformation to achieve this critical goal. This is an opportunity to work on digital transformation and make a real impact within a company dedicated to improving lives.
DigitalX our new information technology function is spearheading this value driven transformation across Astellas. We are looking for people who excel in embracing change, manage technical challenges and have exceptional communication skills.

We are seeking committed and talented Data Warehouse Architects, to join our new FoundationX team- which lies at the heart of DigitalX.

As a member of our team within FoundationX, you will be responsible for ensuring our data driven systems are operational, scalable and continue to contain the right data to drive business value.

Your role will be critical to the continuous improvement/ continuous development (CI/CD) of strategic IT assets and services. You will be supporting the development of data warehouse architecture, design and delivery across Astellas. You will also ensure that data infrastructure supports critical business processes, regulatory compliance, and data-driven decision-making. As a Data Warehouse Architect, you will play a crucial role in designing, building, and maintaining our data infrastructure. Your expertise in Azure, AWS and other related technologies, will be instrumental in driving data-driven decision-making across the organization. You will play a pivotal role in building maintaining and enhancing our systems across the organisation.

This is a fantastic global opportunity to use your proven agile delivery skills across a diverse range of initiatives, utilise your development skills, and contribute to the continuous improvement/delivery of critical IT solutions.

【職務の内容 / Essential Job Responsibilities】 (雇入れ直後) Data Modelling and Integration:


  • Collaborate with cross-functional teams to analyze requirements and create technical designs, data models, and migration strategies.
  • Design, build, and maintain physical databases, dimensional data models, and ETL processes specific to pharmaceutical data

Cloud Expertise:

  • Evaluate and influence the selection of cloud-based technologies such as Azure, AWS (essential), or Google Cloud (Desirable).
  • Implement data warehousing solutions in a cloud environment, ensuring scalability and security

Qlik Expertise:

  • Leverage Qlik for data visualization, dashboards, and self-service analytics.
  • Create Qlik applications to empower business users with insights.

Pharmaceutical Data Governance:

  • Ensure compliance with industry-specific regulations (e.g., FDA, HIPAA) related to data privacy, security, and audit trails.
  • Implement data quality, integrity, and standardization efforts across pharmaceutical products and databases

Advanced Analytics:

  • Work with analytics teams to enable advanced data analytics, predictive modelling, and AI applications specific to drug discovery, clinical trials, and patient outcomes.

Collaboration and Communication:

  • Engage with business stakeholders, including researchers, clinicians, and regulatory affairs teams, to understand their data needs.
  • Translate technical information into actionable insights for non-technical audiences. Additional focus areas
  • Participate in smaller focused mission teams to deliver value driven solutions aligned to our global and bold move priority initiatives and beyond.
  • Design develop and implement robust and scalable full stack applications using modern technologies.
  • Collaborate with cross functional teams and practises across the organisation including Commercial, Manufacturing, Medical, DataX, GrowthX and support other X (transformation) Hubs and Practices as appropriate, to understand user needs and translate them into technical solutions.
  • Provide Level 3 and 4 Technical Support to internal users troubleshooting complex issues and ensuring system uptime as soon as possible.
  • Champion continuous improvement initiatives identifying opportunities to optimise performance security and maintainability of existing data and platform architecture and other technology investments.
  • Ensure compliance with industry-specific regulations (e.g., FDA, HIPAA) related to data privacy, security, and audit trails.
  • Implement data quality, integrity, and standardization efforts across pharmaceutical products and databases
.

  • Participate in the continuous delivery pipeline Adhering to DevOps best practises for version control automation and deployment. Ensuring effective management of the FoundationX backlog.
  • Leverage your knowledge of Machine Learning (ML) and data engineering principles to integrate with existing data pipelines and explore new possibilities for data utilization.
  • Stay-up to date on the latest trends and technologies in full-stack-development, data engineering and cloud platforms.
(変更の範囲) 会社内での全ての業務 【応募要件 / Qualifications】 Any relevant cloud-based AWS or Azure certifications for example:


  • AWS Certified Solutions Architect – Professional / Associate (will be considered with relevant experience)
  • Microsoft Certified Azure Solutions Architect Expert
  • Microsoft Certified Azure Database Administrator
  • Microsoft Certified Azure Developer
  • Knowledge and experience of working with SalesForce / SAP (Desirable)
  • Experience using ETL tools like Talend / Talend Cloud and DataStage (Essential)
  • Knowledge and experience using Azure DevOps (Essential)
  • Experience in working with MPP Databases like Redshift
  • Experience of delivering architectural solutions effectively within Lifesciences or Pharma Domains.
  • Experience analyzing and building star schema data warehouses
  • Experiencing writing SQL and creating stored procedures is essential Data Analysis and

Automation Skills:
Proficient in identifying, standardizing, and automating critical reporting metrics and modelling tools.

Analytical Thinking:
Demonstrated ability to lead ad hoc analyses, identify performance gaps, and foster a culture of continuous improvement.

  • Experience in integrating data from multiple Data sources like relational Databases, Salesforce, SAP and API calls.

Technical Proficiency:
Strong coding skills in SQL, PLSQL. Experience in AWS and Azure.

Agile Champion:
Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery.

  • Code and version control experience and best practices
  • Understand and Interpret business requirements and can term them into technical requirements.
  • Create and maintain technical documentation as part of CI/CD principles 【Working Environment】
  • This position is based in India and will require on-site work.
  • (OR) At Astellas we recognize the importance of work/life balance, and we are proud to offer a hybrid working solution allowing time to connect with colleagues at the office with the flexibility to also work from home. We believe this will optimize the most productive work environment for all employees to succeed and deliver. Hybrid work from certain locations may be permitted in accordance with Astellas' Responsible Flexibility Guidelines.


  • Chuo Astellas Pharma Inc. Permanent

    About This Job 】 As part of the Astellas commitment to delivering value for our patients, our organization is currently undergoing transformation to achieve this critical goal. This is an opportunity to work on digital transformation and make a real impact within a company dedica ...

  • Cloud Engineer

    4日前


    Chuo Astellas Pharma Inc. Permanent

    Description 【募集の背景 / Purpose & Scope】 · •As a Cloud Engineer, you will be a vital member of our DigitalX TrustTechX team. Your primary responsibility is to manage the multi cloud (AWS and Azure) and hybrid environments at Astellas, including full stack automation, incident respo ...


  • Chuo Astellas Pharma Inc. Permanent

    About This Job 】 As part of the Astellas commitment to delivering value for our patients, our organization is currently undergoing transformation to achieve this critical goal. This is an opportunity to worzk on digital transformation and make a real impact within a company dedic ...

  • Cloud Engineer

    2日前


    Tokyo TEKsystems Permanent

    Job Summary · We are looking for a (English only) Cloud Engineer with experience in AWS or Azure, cloud design and architecture as well as hands-on experience with cloud-native technologies. · Our client is expanding to support an ambitious project, a groundbreaking initiativ ...


  • Shinagawa Microsoft Full time

    Overview · Are you passionate about helping customers transform their businesses? Microsoft is at the forefront of this transformation; come and help organizations rethink aspects of their business in a way that sets them and their people up for success. · Microsoft is revolutio ...

  • ETL Developer

    14時間前


    Tokyo TEKsystems Permanent

    Job Summary · One of the leading insurance companies is seeking a skilled ETL Developer with expertise in Informatica PowerCenter and AWS to join the team. The ETL Developer will be responsible for designing, developing, and maintaining ETL processes that load data from various ...


  • Chiyoda MUFG Full time

    Do you want your voice heard and your actions to count? · Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 7th largest financial group in the world. Across the globe, we're 120,000 colleagues, striving to make a difference for every client, organization ...


  • Tokyo Databricks

    CSQ125R90 · As a Big Data Resident Solutions Architect (RSA) in our Professional Services team you will work with clients on short to medium term customer engagements on their big data challenges using the Databricks platform. You will provide data engineering, data science, and ...

  • CSA Manager

    4日前


    Shinagawa Microsoft Full time

    Overview · Microsoft is on a mission to empower every person and every organization on the planet to achieve more. Our culture is centered on embracing a growth mindset, a theme of inspiring excellence, and encouraging teams and leaders to bring their best each day. In doing so, ...

  • Solutions Architect

    22時間前


    Tokyo Databricks

    FEQ425R13 · As a Pre-sales Solutions Architect (Analytics, AI, Big Data, Public Cloud), you will guide the technical evaluation phase in a hands-on environment throughout the sales process. You will be a technical advisor internally to the sales team, and work with the product te ...


  • Chiyoda MUFG Full time

    Do you want your voice heard and your actions to count? · Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 7th largest financial group in the world. Across the globe, we're 120,000 colleagues, striving to make a difference for every client, organization ...


  • Tokyo Rakuten Full time

    Description · : Business Overview · The Technology Platforms Division of Rakuten Group Inc. develops and maintains the core infrastructure and ecosystem necessary to support the various businesses and partners of Rakuten Group Inc. worldwide. · Department Overview · In the E ...


  • Chiyoda MUFG Full time

    Do you want your voice heard and your actions to count? · Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 7th largest financial group in the world. Across the globe, we're 120,000 colleagues, striving to make a difference for every client, organization ...


  • Chiyoda MUFG Full time

    Do you want your voice heard and your actions to count? · Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 7th largest financial group in the world. Across the globe, we're 120,000 colleagues, striving to make a difference for every client, organization ...


  • Chiyoda MUFG Full time

    Do you want your voice heard and your actions to count? · Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 7th largest financial group in the world. Across the globe, we're 120,000 colleagues, striving to make a difference for every client, organization ...


  • Tokyo DENODO SL

    Job Description · As a passionate Technical Consultant, you will be responsible for consulting, solution/problem-solving, and empowering our clients' data journey using Data Virtualization. · Our customers' projects include integrating data in a virtual manner for operational and ...


  • Tokyo Slalom

    *This is a position based in Tokyo, Japan, and requires a valid working visa and living within a commutable distance to the city.* · Data Engineering Consultant · Who You'll Work With · As a modernized technology company, our Slalom Technologists are disrupting the market and br ...


  • Tokyo Takeda Full time

    Description · Lead, Data Platforms · "Better Health for People, Brighter Future for the World" is the purpose of a company. We aim to create a diverse and inclusive organization where people can thrive, grow and realize their own potential while enabling our purpose. We contin ...


  • Tokyo Rakuten Full time

    Description · : Business Overview · The Technology Platforms Division (TPD) is responsible for building and operating the infrastructure and ecosystem platforms that power the Rakuten Group. Our mission is to provide our Rakuten Cloud and Ecosystem Platforms which will deliver ...

  • Data Scientist

    4日前


    Tokyo Rakuten Full time

    Description · : Business Overview · Rakuten group has almost 100 million customers based in Japan and 1 billion globally as well, providing more than 70 services in a variety such as e-commerce, payment services, financial services, telecommunication, media, sports, etc. · Dep ...