UK ~ Nottingham
Business Intelligence Analyst
Our growing and successful business comprises of over 800 talented individuals globally, in an environment where everybody counts and is instrumental to our success. With state-of-the-art manufacturing and clinical facilities in the UK and USA, we deliver a full range of drug development solutions around the globe saving our clients both time and money.
People join Quotient Sciences because we are a respected member of the drug development world, specialising in delivering innovative solutions that integrate formulation development, real time GMP manufacturing and clinical testing. We pride ourselves on the quality of our services and our engaged culture. We are passionate about helping our customers get new medicines to market.
Due to business growth Quotient Sciences have a brand new and exciting role available for a Business Intelligence Analyst to join Information Technology Services in Nottingham.
The Business Intelligence Analyst will be responsible for the development, analysis and testing of customized reports in support of a number of operational Quotient Teams. This will involve using a number of bespoke data management and business systems as source data alongside a number of industry standard tools like SSRS, SSIS, SQL, Spotfire and other data extraction tools.
It is the Business Intelligence Analyst's responsibility to ensure that reports are delivered to a high standard and this will be achieved through elicitation of requirements through face to face interviews with internal customers
You will be required to collaboratively establish and refine the ITS Reporting Portfolio along with providing technical expert advice on appropriate data reporting and extraction techniques. You will ensure the highest standards of consistent customer service are provided to staff, volunteers and customers.
Main tasks and responsibilities:
- Extracting manipulating and analysing data in a timely manner and developing the reports and solutions that keep Quotient departments/teams running efficiently.
- Confidently write SQL statements from multiple tables, views and functions; including the use of correlated sub queries where appropriate.
- Confidently use a variety of database and reporting tools including SSRS, SSIS, Spotfire, Excel (including Pivot and Power BI tools) and MSSMS.
- Accurately contribute in the maintaining of the structural integrity of the databases, along with their tables, views, stored procedures and indexes.
- Conducting and leading the elicitation of requirements gathering with customers to establish a firm understanding of reporting requirements.
- Providing ad-hoc local support.
- Working closely with your internal customers to ensure that reports produced satisfy all business requirements
- Working in a highly regulated environment
The successful candidate will be educated to degree level in IT/equivalent experience with 5+ years of working in an IT/BI environment.
Other skills and experience required:
- Possess the ability to write in SQL to a high standard; to create and alter stored procedures, views, cursors & functions.
- Effectively develop with in a Microsoft Visual Studio environment.
- Effectively use office systems inc. MS Office.
- Experience with SSRS and the creation of SSIS packages including understanding of SSIS development lifecycle and processes.
- Exhibit proficiency of pivot tables within Excel.
- Aware of relational database concepts
- Possess working knowledge of the Microsoft Reporting Suite
- A working knowledge of Data Warehousing implementation and up-keep, across multiple servers.
- DB Performance, health and efficiency via monitoring
- Good understanding of DB infrastructure and relational theory
- Good understanding of Computer Systems Validation and change control
This role may involve occasional travel to UK sites (Reading and Edinburgh) and US.
In return you will receive a competitive salary, a generous benefits package, excellent training and development, as well as an exciting career within a fast paced and dynamic business.