Job Description

Site Name: Bengaluru Luxor North Tower
Posted Date: Aug 25 2022
Ready to help shape the future of healthcare? At GSK, we have already delivered unprecedented change over the past four years, improving R&D, becoming a leader in Consumer Healthcare, strengthening our leadership, and transforming our commercial execution. Now, we’re making the most significant changes we’ve made to our business in over 20 years. We’re on track to separate and create two new companies in 2022: New GSK with a leading portfolio of vaccines and specialty medicines as well as R&D based on immune system and genetics science; and a new world-leading consumer healthcare company of loved and trusted brands.
With new ambition comes new purpose. For New GSK, this is to unite science, talent, and technology to get ahead of disease together – all with the clear ambition of delivering human health impact; stronger and more sustainable shareholder returns; and as a new GSK where outstanding people thrive.
Getting ahead means preventing disease as well as treating it. How we do all this is through our people and our culture. A culture that is ambitious for patients – so we deliver what matters better and faster; accountable for impact – with clear ownership of goals and support to succeed; and where we do the right thing. So, if you’re ready to improve the lives of billions, join us at this exciting moment in our journey. Join our challenge to get Ahead Together. Job Purpose and Key Responsibilities: The essence of the Systems Specialist I- Developer 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 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. 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. Accountability: SQL/Cognos Report Development: Develop and implement SQL/Cognos 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 modeling 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. Complexity (this is best illustrated for this role by the behaviors needed to perform effectively):

• Teamwork: Works effectively with others to achieve business goals and objectives. Bridges personal, business and cultural differences to work effectively in team settings.

• Business Orientation: Understanding of the operational challenges of safety stakeholders and other customers. Recognises issues and initiatives important to the business in order to facilitate development of business benefits cases and effective prioritisation in order to move the business forward.

• Customer Focus: Understands their (internal and external) customer’s business. Understands customers’ needs and works with them to help solve their problems. Acts quickly to respond to customers’ needs.

• Communication: Listens to others: actively attends to and conveys understanding of the comments and questions of others; listens well in a group. Speaks effectively: speaks clearly and expresses self well in groups and in one-to-one conversations. Writing skills: conveys information clearly and effectively through both formal and information documents; reviews and edits written work constructively. Delivers presentations effectively: prepares and delivers clear, smooth presentations; carries self well in front of a group. Strong influencing and negotiation skills.

Responsibility:

• Good understanding and experience with SQL/PL-SQL development/query language tools
• Experience working in Power BI or other data modeling and reporting tools
• 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 administration and scheduling management
• Good at Cognos Framework Management and changes to Data modeling
• 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
• Knowledge of audits & inspections will be an added advantage

Competencies: Competencies:

• 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 report development using SQL/PL-SQL and other query language/tools
• Good understading of building models using PowerBI
• 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
• Good at multitasking and prioritization
• Good in coaching and influencing team members of lower grade
• Bridges personal, business and cultural differences to work effectively in team settings.
• Basic knowledge in resource and team management skills
• Proficient in stakeholder management and customer focus
• Develops self and others

Education – Bachelor/Master degree in an information management, SQL development experience, business analytics, data query/reporting environments or related field with minimum of 4-9 years experience in the pharmaceutical industry in clinical development, pharmacovigilance and information management or equivalent work experience.
At GSK we value diversity (Gender, LGBTQ +, PwD etc.) and treat all candidates equally. We aim to create an inclusive workplace where all employees feel engaged, supportive of one another, and know their work makes an important contribution.

• 
  LI-GSK

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. Getting ahead means preventing disease as well as treating it, and we aim to impact the health of 2.5 billion people around the world in the next 10 years.

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.