Business Intelligence Architect, BI 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 Business Intelligence (BI) Architect to join our new FoundationX team

**Purpose and Scope**:
**Essential Job Responsibilities**:
Data Strategy Contribution: Contribute to the organization’s data strategy by identifying opportunities for data-driven insights and improvements.

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 data analytics 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 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.

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 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 data engineering and cloud platforms.

**Qualifications**:
**Required**

Bachelor’s Degree in computer science, information technology, or related field (or equivalent experience.)

5 years+ experience in using Qlik, PowerBI or equivalent technologies

Familiarity with Business Intelligence and Data Warehousing concepts.

Web integration skills (Qlik Sense).

Advanced SQL knowledge.

Understanding of stored procedures, triggers, and tuning.

Business Intelligence Tools:
Expert at creating and consuming complex Qlik/PowerBI data models

Power BI: Strong expertise in creating interactive reports, dashboards, and visualizations using Power BI. Knowledge of DAX (Data Analysis Expressions) is essential and Power Automate (MS Flow) or PowerBI alerts

Data Modeling and Integration:
Best practice knowledge of modelling data that is to be consumed by QlikSense or PowerBI

Ability to design and implement logical and physical data models.

Familiarity with data warehousing concepts, including star schema, snowflake schema, and data marts.

Understanding of ETL (Extract, Transform, Load) processes and data integration techniques.

SQL and Database Management:
Proficiency in SQL for querying and manipulating data.

Knowledge of database management systems (e.g., SQL Server, Oracle, MySQL).

Data Governance and Quality:
Understanding of data governance principles, data lineage, and metadata management

Experience ensuring data quality, consistency, and accuracy

Experience performance tuning BI data models and reports to ensure apps are responsive to users’ needs

Proven skill at creating dashboards of pixel perfect quality

Create and maintain technical documentation

Ability to communicate and work effectively with other technical team members to agree best solution

A self-starter able to work on own but know when to collaborate with wider team to ensure best overall solution.

Experience working with data warehousing and data modelling

Understanding of Qlik, Tableau and or PowerBI architecture or any equivalent technology

Ability to install, configure and upgrade Qlik/ PowerBI or equivalent systems

Conducting Unit Testing and troubleshooting BI systems

Data Analysis and Automation Skills: Proficient in identifying, standardizing, and automating critical reporting metrics

Ensuring Data Security and Compliance with relevant internal, global and or regional regulation

Assist users with ad-hoc queries and data troubleshooting.

Use analytics to understand root causes and drive decision-making for customer acquisition and retention.

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

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

**Preferred**

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