AstraZeneca Pharmaceuticals LP Senior BI Architect in Macclesfield, United Kingdom

Job Overview

We are looking for a Senior Architect to enable our teams in delivery of Business Intelligence and Data projects to our internal customers. We are looking for people with the right mind-set and attitude who strive for close, collaborative, and empowered working environments, where individuals and teams can flourish

The primary accountability will be working with IIS leadership team, architects, Data and Analytics architects in CFIT teams in development and evolution of an integrated BI technical strategy and roadmap. Focus will be on how to rapidly build internal capability (on/off shore, IT/business) and source technology to meet growing business expectation on how BI can get better insights from Data.

As part of this role we expect significant external due diligence to ensure we are current in BI Architecture space as well as liaising across the AZ portfolio’ to demonstrate innovation and investments in other parts of AZ.

In addition, the individual will play an oversight role on Big Data, Data Science, BI Fabric in the SSS, coaching team members on approaches, advising projects on application of big data and data science capability as required.

The role holder should deliver tangible and measurable value to IIS, SSS and CFIT partners by advising, prototyping and delivering BI solutions.

Lastly, you will also operate, as needed, in a hands-on capacity, as part of the delivery of BI solutions within projects.

The role will report to and be supported by, the Lead BI and Data Enablement of SSS and will work across the SSS organisation, primarily focused on BI.


  • You will partner and develop an BI technical strategy and roadmap, working with business, architecture and D&A leaders

  • Your will be responsible for identifying areas for BI innovation, develop business case in alignment with IIS Leadership team and demonstrate value through prototyping and delivery of solutions

  • Track external BI innovation, you will find opportunities and advise and guide on investments / vendors / partnerships (academic & commercial)

  • You will be able to develop skills and raise BI awareness across IT team through regular communications (verbal / written), demonstrators projects, AI delivery, training and coaching.

  • You will support the delivery of the strategy by advising BI projects implementing solutions on standard methodology and technology application, and the oversight/delivery of enabling BI platform capability.

  • You will collaborate closely with CFIT architects to ensure data and technology architectures/ investments.

  • As needed, hands on delivery of BI solutions within projects.

  • You will lead methodology, best practice, tooling, documentation and overall continuous evolution of capability


  • Strong BI Architecture experience including strategy definition and execution

  • Big Data/Data Science experience

  • Ideally domain knowledge (processes & data): Pharma R&D.

  • Strong external network and awareness in BI

  • Experience of a range of Analytics architectures: traditional warehousing, Distributed computing (Hadoop), NoSQL, virtualization, semantic web, data streaming etc

  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

  • Experience supporting and working with multi-functional teams in a dynamic environment.

Areas of specialization will include:

  • Business Intelligence

  • Data visualization, User Interface design

  • Data analysis and design of KPI/Measures/Metrics

  • Development of Reports using AZ adopted BI technologies

  • Data Integration

  • ETL and ELT concepts, principles and implementations

  • Data Virtualization concepts, principles and implementations

  • Data Management

  • Data Quality with Data Profiling

  • Master Data Management

  • Meta Data Management

  • Data Archival

  • Applicable tools:

  • SAP Business Objects, Qlikview/Qliksense, MicroStrategy, Thoughtspot, PowerBI

  • Oracle, SQL Server, Redshift, SAP HANA

  • Big Data Technologies – Hive, Impala

  • Understanding of data management and integration services

  • Life cycle management and capacity planning

  • Creation of standards and procedures to maintain AstraZeneca's environments.

Candidate Knowledge, Skills & Experience –

  • Experienced Solution Architect and system engineering experience

  • Experience supporting multiple time zones/geographical regions


  • Good communication skills

  • Architect and Design BI solutions on tools like MicroStrategy, PowerBI, SAP Business Objects, Qlik, etc

  • Developing with MySQL, SAP HANA or PostgreSQL

  • Data modelling (particularly in ERWIN, Idera)

  • Database design

  • Agile development (SAFe, SCRUM)

  • Experience with 3/5NF and Star Schemas

Behaviour and skills

  • Mental Agility: critical and fast thinker, comfortable with complexity and making connections that are understandable for others – Breadth and Depth of thinking - Problem solving.

  • Adaptability: Learner mindset; demonstrated ability to take risk and be successful in different environment. Entrepreneurship. Comfortable with ambiguity and unpredictability. Forward looking.

  • Self-Awareness: Has personal insight and effectively communicates

  • Impact and Influence: strong drive for results - Ability to lead change effectively. Challenge status quo - Ability to impact and influence different profiles and add value.


  • Masters degree

  • Proven leadership skills interacting with senior leaders


ob Dimensions –

  • Approximate number of people managed in total (all levels) – up to 5

  • Some matrix team leadership and/or matrixed into other teams and projects

  • Global remit – 2 or 3 countries at minimum of 40% of time

Other –

  • Should have proven skills in handling projects of mid-large size

  • Should have worked in a team environment and possess good written and oral communication skills

  • Good organizational and social skills

  • Aptitude and motivation learn new technologies and make appropriate recommendations for consideration

  • Ability to prioritize tasks and work in a dynamic environment support with minimal supervision in very large user community that is geographically dispersed

  • Proven skills in communicating directly with user community

  • Apply now to learn more about this exciting opportunity with a world renowned pharmaceutical brand!

AstraZeneca is an equal opportunity employer. AstraZeneca will consider all qualified applicants for employment without discrimination on grounds of disability, sex or sexual orientation, pregnancy or maternity leave status, race or national or ethnic origin, age, religion or belief, gender identity or re-assignment, marital or civil partnership status, protected veteran status (if applicable) or any other characteristic protected by law.