Systems Specialist Reporting and Analysis

Years of Experience: 9+ years

Skill Set / Exposure: Japanese language is a Must, Data Reporting, SQL, PL SQL, Oracle Argus and Power BI.

Location: Bangalore

Mode: Hybrid Mode (3-4 days office)

Job Purpose:

• The essence of the Systems Specialist – Reporting and Analysis role is to provide a clearly defined communication channel between GSK safety systems stakeholders/users worldwide, Regulatory Authorities, Safety teams, and IT vendors and suppliers in three key areas – systems delivery, systems validation and systems support.

The key systems management activities are:

• SQL/Cognos/PowerBI Report Development
• Data Analysis
• Systems Validation
• Systems Support and Maintenance
• The position requires demonstrated skills in a range of these roles as measured in the eyes of customers and be able to cover all of the roles with an adequate level of skill when necessary.
• Collaboration for safety systems users in this role with be focused on Asia Pac stakeholders.
• This position ensures that the design, implementation, maintenance and support of PV systems enable GSK to efficiently, timely, accurately, and consistently report and analyze data from all relevant data sources to support the full range of PV activities, ensuring effective monitoring of the safety of our marketed products and investigational compounds.

Key Responsibilities (suggested no more than 10 bullet points):

• Japanese language skills
• SQL/PowerBI Report Development: Develop and implement SQL/PowerBI custom reports for end users, provide complex query and reporting support for end users, write complex SQL queries to extract data and performing data analyses for end users and support the overall reporting environment configuration/safety database and DataMart.
• Data Analysis: Extracting, inspecting, cleaning, transforming and modelling raw data with the goal of highlighting useful information, suggesting conclusions and supporting decision making.
• Systems Validation: The documented act of demonstrating that a procedure, process, and activity will consistently lead to the expected results. Plan, execute, report on user acceptance testing and archive test findings for diverse regulated systems. Be able to produce evidence of systems validation to internal and external auditors.
• Support: Respond to client or end-user requests by diagnosing and resolving problems and incidents that fall within defined guidelines and/or escalating or transferring problems and incidents to other technical support teams and/or outside vendors as appropriate to ensure ongoing business operations. Knowledge and understanding of user needs when issues are raised and provision of timely and expert resolution and advice.
• Support includes but is not limited to query and reporting support as well as  managing helpdesk requests.
• Work across the organization to resolve end-user  requests and incidents in a timely manner.

Education Requirements (minimum expected):

• Bachelor/Master degree in an information management, SQL development experience, business analytics, data query/reporting environments or related field with minimum of 4-9 year’s experience in the pharmaceutical industry in clinical development, pharmacovigilance and information management or equivalent work experience.

Job Related Experience (minimum requirements):

• Good understanding and experience with SQL/PL-SQL development/query language tools
• Experience working in Power BI or other data modeling and reporting tools.
• Working knowledge of Data Virtualization tools (Denodo)
• Knowledge of data caching and implementing connections to multiple sources through data virtualization tools
• Experienced in scheduling management in PowerBI.
• Good at developing and extracting reports from DataMart using Cognos or PowerBI, Examples are like list reports, cross tab reports, drill through reports, etc.
• Good knowledge of report development in Cognos and/or Power BI and/or OBIEE
• Experienced in development of reports (using native SQL and Cognos studio or PowerBI) based on end user requirements.
• Good knowledge and working experience in Cognos/Power BI administration and scheduling management.
• Good at Cognos/Power BI Framework Management and changes to Data modelling
• Knowledge of Argus database/DataMart structure.
• Experience supporting in ad-hoc data requests and report request/issues.
• Thorough knowledge of clinical safety and pharmacovigilance data, or equivalent experience working to support query and reporting environments in other domains.
• Good at responding to and supporting help desk request within query and reporting environments.
• Proficient in knowledge of incident, problem, knowledge and change management processes and best practices.
• Good in business analysis capable of documenting requirements based on end user input.
• Good understanding of GxP testing and validation processes with minimal supervision for senior staff
• Good in writing report specifications/requirements documents with minimal supervision for senior staff.
• Good in writing and executing GxP System and User acceptance test documents with minimal supervision for senior staff.
• Good knowledge of the data querying and reporting tools used to generate aggregate reports (Cognos, Qlik, Power BI, Spotfire, others) knowledge of medical and drug terminology.
• Active participation during audits and inspections with supervision from senior staff
• Ability to work with tight deadlines while under pressure, while maintaining a high level of accuracy, attention to detail and integrity.
• Functions as a team player
• Ability to work independently.
• Proficient in stakeholder management and customer focus

Other Job-Related Skills:

• Excellent in oral and written communication skills including:
• Ability to identify and communicate issues in timely fashion to both end-users and central resources.
• Experienced in business analysis capable of documenting requirements based on end user input.
• Experienced in responding to and supporting help desk request within query and reporting environments.
• Excellent computer skills including Word, Excel, PowerPoint and SharePoint.
• Expert in systems skill including Safety database, Incident/Problem management tool and SQL query language tool.
• Thorough understanding and experience in Cognos/PowerBI report development using SQL/PL-SQL and other query language/tools.
• Good understanding of building models using PowerBI.
• Knowledge of Denodo implementation/Data virtualization tools.
• Excellent skill in managing the reporting environments and building models as per the business requirements.
• Good understanding of reporting environment setup and its integrated components.
• Thorough knowledge of Cognos administration and framework management.
• Expertise in resolving diverse business needs in terms of query and report environments.
• Expert knowledge of clinical safety and pharmacovigilance data, or equivalent experience working to support query and reporting environments in other domains.
• Logical thinking to perform independent analysis resulting in comprehensive requirement definition or problem resolution with minimum supervision from senior staff.
• Good in business analysis capable of documenting requirements based on end user input.
• Thorough understanding of GxP testing and validation processes
• Proficient in writing report specifications/requirements documents
• Proficient in writing and executing GxP System and User acceptance test documents.
• Expert in responding to and supporting help desk request within query and reporting environments.
• Expert knowledge of incident, problem, knowledge and change management processes and best practices.
• Excellent understanding of the data querying and reporting tools like Cognos, QlikView, Power BI, Spotfire, others.
• Expert knowledge of medical and drug terminology.

Why GSK?

Uniting science, technology and talent to get ahead of disease together.

GSK is a global biopharma company with a special purpose – to unite science, technology and talent to get ahead of disease together – so we can positively impact the health of billions of people and deliver stronger, more sustainable shareholder returns – as an organisation where people can thrive. We prevent and treat disease with vaccines, specialty and general medicines. We focus on the science of the immune system and the use of new platform and data technologies, investing in four core therapeutic areas (infectious diseases, HIV, respiratory/ immunology and oncology).

Our success absolutely depends on our people. While getting ahead of disease together is about our ambition for patients and shareholders, it’s also about making GSK a place where people can thrive. We want GSK to be a place where people feel inspired, encouraged and challenged to be the best they can be. A place where they can be themselves – feeling welcome, valued, and included. Where they can keep growing and look after their wellbeing. So, if you share our ambition, join us at this exciting moment in our journey to get Ahead Together.

  
Important notice to Employment businesses/ Agencies

GSK does not accept referrals from employment businesses and/or employment agencies in respect of the vacancies posted on this site. All employment businesses/agencies are required to contact GSK's commercial and general procurement/human resources department to obtain prior written authorization before referring any candidates to GSK. The obtaining of prior written authorization is a condition precedent to any agreement (verbal or written) between the employment business/ agency and GSK. In the absence of such written authorization being obtained any actions undertaken by the employment business/agency shall be deemed to have been performed without the consent or contractual agreement of GSK. GSK shall therefore not be liable for any fees arising from such actions or any fees arising from any referrals by employment businesses/agencies in respect of the vacancies posted on this site.

It has come to our attention that the names of GlaxoSmithKline or GSK or our group companies are being used in connection with bogus job advertisements or through unsolicited emails asking candidates to make some payments for recruitment opportunities and interview. Please be advised that such advertisements and emails are not connected with the GlaxoSmithKline group in any way.

GlaxoSmithKline does not charge any fee whatsoever for recruitment process. Please do not make payments to any individuals / entities in connection with recruitment with any GlaxoSmithKline (or GSK) group company at any worldwide location. Even if they claim that the money is refundable.

If you come across unsolicited email from email addresses not ending in gsk.com or job advertisements which state that you should contact an email address that does not end in “gsk.com”, you should disregard the same and inform us by emailing askus@gsk.com, so that we can confirm to you if the job is genuine.