Data Engineer – Leading Pharmaceutical Company – Manchester

at  Noir Consulting

DATA ENGINEER - LEADING PHARMACEUTICAL COMPANY - MANCHESTER

(Tech Stack: Data Engineer, Databricks, Python, Power BI, AWS QuickSight, AWS, TSQL, ETL, Agile Methodologies)
About the Role: We are seeking a talented and experienced Data Engineer on behalf of our client, a leading Software House. This is a fully remote position, offering the opportunity to work with cutting-edge technologies and contribute to exciting projects in a collaborative environment.
About the Role: Our client is seeking an experienced Data Engineer to join their team in Manchester. This hybrid position involves working within the pharmaceutical industry, focusing on the design, development, and maintenance of data pipelines, ETL processes, and databases. The role is ideal for someone passionate about improving processes, ensuring data quality, and maintaining compliance with regulatory standards. focusing on designing, developing, and maintaining data pipelines, ETL processes, and databases. If you are passionate about driving continuous improvement and ensuring data quality and compliance, we want to hear from you.

ESSENTIAL SKILLS/EXPERIENCE:

• A good degree in a relevant subject or equivalent professional experience in a data role.
• At least 3 years’ professional experience developing data pipelines and ETLs using Microsoft products.
• Minimum 1 year of experience working with cloud-native technologies like Azure Data Factory.
• Demonstrable experience of delivering technical work within time and budget constraints.
• Good understanding of data security best practices.
• Experience in supporting ETLs or data pipelines crucial to a production system.
• Experience working in a cross-functional team to deliver technical solutions.

DESIRABLE SKILLS:

• Experience with SQL Server, SSIS, Azure Data Factory, and Azure SQL.
• Experience with Cloud and Infrastructure as Code, particularly in an Azure setting using Bicep.
• Understanding of DevOps practices and the associated benefits.
• Skill in database testing including unit, performance, stress, and security testing.
• Experience working in an agile team.
• Experience working in a highly regulated industry and with highly sensitive data.
• Exposure to large data solutions like Snowflake, Trino, Synapse, Azure Data Lake, and Databricks.
• Experience in data science using R, Stata, or Python.
• Familiarity with Atlassian tools such as JIRA, Confluence, and BitBucket.
• Understanding of clinical trials, GCP, and GxP.

• Design, develop, maintain, and optimise data pipelines, ETL processes, and databases.
• Drive continuous improvement by refining processes, products, and identifying new tools, standards, and practices.
• Collaborate with teams across the business to define solutions, requirements, and testing approaches.
• Assist with process definition, ensuring compliance with organisational processes and regulatory standards.
• Ensure compliance with regulatory requirements and standards and audit readiness.
• Automate and monitor data and data processes, ensuring data quality and integrity.
• Share knowledge and provide guidance on databases and data.
• Maintain up-to-date, accurate, and concise documentation of database configurations and processes.
• Work across the team to deliver best practice infrastructure and infrastructure deployment and management processes.