Years of Experience: 3-5+ years
Skill Set / Exposure: Power BI (Reports, Dashboards, Wizards), SQL/PLSQL Programming, (Denodo or Snowflakes or Argus).
Work Location: Bengaluru
Job Description:
- The essence of the Systems Specialist I- Reporting & 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 Queries
- Power BI Wizards, Dashboards and Report Development
- Data Analysis
- Reports 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 the roles with an adequate level of skill when necessary.
- This position ensures that the design, implementation, maintenance and support of Powe BI reports, wizards, and Dashboards, 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:
- SQL /Power BI Report Development: Develop and implement SQL/Power BI 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’s degree in an information management, business analytics, data query/reporting environments or related field with a minimum of 2-7 years working experience in the pharmaceutical industry, pharmacovigilance, 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
- Good at developing and extracting reports from DataMart using Power BI. Examples are like list reports, cross tab reports, drill through reports, etc...
- Good knowledge of report development in SQL& Power BI
- Good knowledge and working experience in administration and scheduling management.
- Good at 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.
- 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:
- Expert in oral and written communication skills.
- 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.
- Expert knowledge of clinical safety and pharmacovigilance data, or equivalent experience working to support query and reporting environments in other domains.
- Extensive experience working with SQL/other query language tools.
- 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.
- Flexibility to accommodate urgent requests raised to the team with minimum guidance and supervision.
- Expert in systems skill including Safety database set up and underlying procedures/systems.
- Expert 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.
- With minimal supervision from senior staff to complete small, non-complex projects or tasks.
- Bridges personal, business and cultural differences to work effectively in team settings.
- Proficient in stakeholder management and customer focus.
- Develops self and others.
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.
