Job Description

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 \xe2\x80\x93 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. 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 compound

Accountability: SQL/Cognos/PowerBI Report Development: Develop and implement SQL/Cognos/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 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

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

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

Why Us?

GSK is a global biopharma company with a special purpose \xe2\x80\x93 to unite science, technology and talent to get ahead of disease together \xe2\x80\x93 so we can positively impact the health of billions of people and deliver stronger, more sustainable shareholder returns \xe2\x80\x93 as an organization where people can thrive. Getting ahead means preventing disease as well as treating it, and we aim to positively impact the health of 2.5 billion people by the end of 2030.

Our success absolutely depends on our people. While getting ahead of disease together is about our ambition for patients and shareholders, it\xe2\x80\x99s also about making GSK a place where people can thrive. We want GSK to be a workplace where everyone can feel a sense of belonging and thrive as set out in our Equal and Inclusive Treatment of Employees policy. We\xe2\x80\x99re committed to being more proactive at all levels so that our workforce reflects the communities we work and hire in, and our GSK leadership reflects our GSK workforce.

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 \xe2\x80\x9cgsk.com\xe2\x80\x9d, 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.

GlaxoSmithKline