Business Intelligence Architect Senior BI Architect

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 a committed and talented Business Intelligence (BI) Architect to join our new FoundationX team- which lies at the heart of DigitalX. As a member of FoundationX, you will be responsible for ensuring our BI applications are performant, operational, scalable and continue to drive business value.

This position is based in India and may require on-site work from time to time.

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.
  
  

• Bachelors 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).
• Advanced SQL knowledge.
• Understanding of stored procedures, triggers, and tuning.
• Experience with other BI tools (Tableau, D3.js) is a plus.
• 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 experience 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.
  
  

• Experience working in the Pharma industry.
• Experience in storytelling with data
• Visualization best practices
• Knowledge/experience using Qlik, or PowerBI SaaS solutions.