YES Prep Public Schools

Principal Data Engineer

5 November 2024
Apply Now
Deadline date:
£28000 - £67000 / year

Job Description

Job Purpose

This role contributes to the construction of the development of data warehouses, data models, data lake and ETL data pipelines. This role will interact with architects, engineers, data modelers, product owners as well as other team members in GSK Quality. This role will actively participate in creating technical solutions, designs, implementations & participate in the development of Data & AI products.

The Data Engineer demonstrates both depth and breadth across key data engineering competencies e.g. Software Development, Testing, DevOps, Data Engineering tools/platforms/concepts, and cloud. Can collaborate with experts from other subject domains. Primary responsibilities include using Azure cloud services and GSK data platform tools to ingest, egress, and transform data from multiple sources.

In addition, the role will demonstrate core engineering knowledge/experience of industry technologies, practices, and frameworks such as data models, data lake, data warehousing and scaling data platforms, containerization, cloud-based platforms, data analytics, and data streaming.  Examples of technologies include SAP, SQL, Python, GIT, Azure Devops, Data Bricks, Azure synapse analytics, Azure Delta Lake,  Spark, Azure Data Factory, ADLS V2, Kafka, Docker, Azure/GCP Cloud Architecture including networking principles and scaling applications. 

Key Responsibilities:

The Principal Data Engineer, Data & Analytics role is a senior technical role and will provide you the opportunity to lead key activities to progress your career.  These responsibilities include the following:

  • Design and Development of Datawarehouse, Data Models, Data Lake etc to meet the overall GSK Quality business requirements.

  • Design and Develop ETL pipelines to ingest, cleanse and transform data based on GSK Quality business requirements.

  • Experience in development of Reports and Dashboards using Business Intelligence tools is preferred (not must have)

  • Work with other teams to define data platform practices to meet the GSK quality requirements.

  • Conducting PoCs of new technologies related to data platforms and adopt these technologies as part of GSK Quality Data & AI products.

  • Ensures that technical delivery is fully compliant with GSK Security, Quality and Regulatory standards.

  • Ensures use of relevant GSK Tech / central services and work with strategic partners to deliver Data warehouse, Data Models, ETL pipelines, Data Lake etc

  • Maintains best practices for engineering and architecture on our Confluence site. This requires hands on experience with cutting edge technology.

  • Pro-actively engages in experimentation and innovation to drive relentless improvement.

  • Provides leadership, technical direction and GSK expertise to architecture and engineering teams composed of GSK FTEs, strategic partners and software vendors.

Why you?

Basic Qualifications:

Are you ready to work in an environment where you are continuously expected to work on projects with new technology and expected to use this technology to deliver real business value?

We are looking for professionals with these required skills to achieve our goals:

  • Total 10 to14 years of experience and proficient in below skills and can demonstrate knowledge and value with relevant experience in all the following competencies:

    • Must have experience in Azure Data Engineering, Azure Synapse, Delta Lake, SQL, Spark, Python and Databricks

    • Experience in development of dashboards and reports using PowerBI is preferred (not must have)

    • Software development, architecture design & technology platforms/frameworks

    • Data Platforms and Domain-driven design

    • DevOps & Automation [of testing, build, deployment, CI/CD, etc.]

    • Data Engineering, data analytics & data quality/integrity

    • Testing strategies & frameworks

  • Role requires:

    • Demonstrated skill in delivering high-quality engineered data products

    • Knowledge of industry standards and technology platforms aligned to GSK and R&D roadmaps

    • Excellent communication, negotiation, influencing and stakeholder management skills

    • Customer focus and excellent problem-solving skills

  • Computer Science or related bachelor’s degree – MS in Computer Science is preferred

  • Familiarity and use of various open-source ecosystems including Hadoop, Bigdata, python etc.

  • Good understanding of various software paradigms: domain-driven, procedural, data-driven, object-oriented, functional

  • Familiar with .Net Core (C#), Java, Python

  • Demonstrable knowledge depth in more than one area of software engineering and technology

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 [email protected], so that we can confirm to you if the job is genuine.