Data Engineer, Data Engineering Chapter

Do you want to be part of an inclusive team that works to develop innovative therapies for patients? Every day, we are driven to develop and deliver innovative and effective new medicines to patients and physicians.  If you want to be part of this exciting work, you belong to Astellas!

Astellas Pharma Inc. is a pharmaceutical company conducting business in more than 70 countries around the world. We are committed to turning innovative science into medical solutions that bring value and hope to patients and their families. Keeping our focus on addressing unmet medical needs and conducting our business with ethics and integrity enables us to improve the health of people throughout the world. For more information on Astellas, please visit our website at www.astellas.com.

This position is remote and is based in Bangalore, India.  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.

Purpose and Scope:

As a BI Architect, you will be responsible for designing, implementing, and maintaining our business intelligence (BI) solutions. You’ll collaborate with cross-functional agile driven teams, including IT, data analysts, and business stakeholders, to ensure our data architecture aligns with key business objectives. Your expertise in QLIK and/or Power BI will be essential in creating scalable, efficient, and insightful BI solutions.

You will play a pivotal role in building maintaining and enhancing our BI applications.  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.

Essential Job Responsibilities:

• Data Architecture:
• Develop and maintain scalable data models.
• Design and implement logical and physical data models.
• Translate business analysis and reporting requirements into high-quality BI designs and dashboards
• BI Solution Development:
• Optimize BI solutions using tools like SQL Server and Power BI Desktop.
• Create and enhance data pipelines for efficient data processing.
• Ensure data quality and integrity throughout the BI ecosystem.
• Leadership and Collaboration:
• Provide analytical and technical leadership for BI and reporting.
• Mentor junior BI team members.
• Collaborate with IT and business teams to integrate BI solutions.
• Best Practices and Standards:
• Develop and enforce BI best practices and standards.
• Stay updated on industry trends and emerging technologies. 

• 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 applications to meet ever-changing business needs.
• 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.
• Participate in the continuous delivery pipeline adhering to dev OPS best practices for version control automation and deployment. Ensuring effective management of the FoundationX backlog.
• Stay up-to date on the latest trends and technologies in full-stack development, data engineering and cloud platforms.
• automation and deployment. Ensuring effective management of the FoundationX backlog.
• Stay-up to date on the latest trends and technologies in full-stack development, data engineering and cloud platforms.

Qualifications:

Required

• Bachelor's degree in computer science, Information Technology, or related field (master’s preferred) or equivalent experience
• 7 years+ using Qlik, PowerBI or equivalent technologies
• Analytical mindset and logical thinking.
• Familiarity with Business Intelligence and Data Warehousing concepts.
• Web integration skills (Qlik Sense).
• Subject Matter Expertise: possess a strong understanding of data architecture/ engineering/operations/ reporting within Life Sciences/ Pharma industry across Commercial, Manufacturing and Medical domains.
• Other complex and highly regulated industry experiences will be considered across diverse areas like Commercial, Manufacturing and Medical.
• 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.
• Technical Proficiency: Strong coding skills in SQL, R, and/or Python, coupled with expertise in machine learning techniques, statistical analysis, and data visualization.
• Agile Champion: Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery.
• Advanced SQL knowledge.
• Understanding of stored procedures, triggers, and tuning.
• Experience with other BI tools (Tableau, D3.js) is a plus.

Working Environment 

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

Astellas’ Global Capability Centers – Overview
Astellas’ Global Capability Centres (GCCs) are strategically located sites that give Astellas the ability to access talent across various functions in the value chain and to co-locate core capabilities that are currently dispersed. ​Our three GCCs are located in India, Poland and Mexico.​
​The GCCs will enhance our operational efficiency, resilience and innovation potential, enabling a timely response to changing business demands.​
​Our GCCs are an integral part of Astellas, guided by our shared values and behaviors, and are critical enablers of the company’s strategic priorities, sustainable growth, and commitment to turn innovative science into VALUE for patients.

"Beware of recruitment scams impersonating Astellas recruiters or representatives. Authentic communication will only originate from an official Astellas LinkedIn profile or a verified company email address. If you encounter a fake profile or anything suspicious, report it promptly to LinkedIn's support team through LinkedIn Help"