Technical Architect - Life Sciences Consulting (R1007414) in London, UK at IQVIA™

Date Posted: 8/13/2018

Job Snapshot

Job Description

Job Title: Technical Architect - Life Sciences Consulting

Department: NEMEA Regional Delivery

Function & Level: Consulting, 150

Location: Pentonville Road, London

Reporting to: Engagement Manager

Hours: 35


Overview of the Role

To lead the technical design and implementation of Business Intelligence solutions to IQVIA clients. The position carries the responsibility of defining architectural standards and approaches from data acquisition through to front end BI tools. As such there is a focus on data sourcing and modelling (ETL), data integration (MDM/DWH) and the provision of decision ready data to front end BI solutions.

The candidate should have a strong hands-on technical experience in creating service oriented solutions in a business intelligence environment. They must be willing to work with commercial teams on a general level to ensure solutions are aligned with business needs. They must also act as partners to project managers to ensure delivery of solutions to a high quality. Must have a passion for producing robust, configurable end-to-end BI solutions and automation of data management processes.


The role requires subject matter expertise to support analysis and design of best practice solutions and architecture that maximise efficiency and user adoption.


Principal Accountabilities

  • Set Standards and Define Processes
    • Define and implement standards and best practice guidelines for ETL, data warehousing and BI data marts across multiple client offerings and deliveries.
    • Develop training packages and accreditation programs to align resources with standards and best practice, in conjunction with the delivery excellence function.
    • Create project quality checkpoints to ensure compliance.
    • Develop solution architecture & design, recommend improvements and alternative solutions to resolve problems. Challenge the way things are done and push through improvements.
  • Technical Leadership in Delivery
    • Work in conjunction with our partners in the IQVIA business and the client themselves to define requirements and conceptualise projects.
    • Feed technical implementation details (work estimates, task breakdowns) into project plan, working with a designated project manager.
    • Organise, prioritise and lead own work and that of the team. Able to directly or indirectly manage a distributed team of onshore and offshore technical resources.
  • Service and Business Development
    • Partake in research & development of new services in collaboration with commercial teams and central technology services pillars.
    • Collaboration with colleagues in business units to produce demos and proofs of concept to help the sales process, and providing subject matter expertise in client meetings.

Education, Experience & Specialised Knowledge Required

  • Graduate with 7+ years of experience in architecture, design and delivery of data management and business intelligence solutions in a commercial services environment.
  • Expert level knowledge and experience in the MicroStrategy (up to v10.3) or Power BI
  • Expertise in other BI solutions (Qlik Sense, Tableau etc.) would be an advantage
  • Expert level knowledge in the MS SQL Server suite of products (Management Studio, Integration Services, Analysis Services, Master Data Services, Database Engine – 2008 R2 through to 2014). Understanding of metadata driven ETL and technologies to support dynamic SSIS package development.
  • Expert understanding of data modelling techniques to support MicroStrategy solutions (star schema, transformation tables, etc).
  • Expert in continuous integration and testing frameworks to support ETL, with supporting experience of continuous integration tools and platforms.
  • Experience in mobile application development on iOS


Job ID: R1007414