Dwh Architect

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 MDM Engineers to join our new FoundationX team, which lies at the heart of DigitalX. As a member within FoundationX, you will be playing a critical role in ensuring our MDM systems are operational, scalable and continue to contain the right data to drive business value. You will play a pivotal role in building maintaining and enhancing our MDM systems.

**Purpose and Scope**:
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 organization. This is a fantastic global opportunity to use your proven agile delivery skills across a diverse range of initiatives, utilize your development skills, and contribute to the continuous improvement/delivery of critical IT solutions.

This position is based in Bengaluru and will require some on-site work.

**Responsibilities and Accountabilities**:
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.

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:
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.

Collaborate with cross functional teams and practices across the organization 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 optimize 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 practices 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.

**Required Qualifications**:

- Bachelor's degree in computer science, Information Technology, or related field (Master’s preferred) or equivalent experience. Minimum of 3 years demonstrated relevant experience.

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