Data Engineer

The life sciences industry plays a significant role in advancing healthcare and improving the quality of life - in many cases, saving millions of lives globally. At BASE life science, this is the motivation for everything we do, aimed at pushing boundaries, seeking excellence, and making a lasting difference through consulting expertise and data-driven solutions.

**Who is BASE life science?**:
Founded in 2007, BASE life science is a business and technology consulting enterprise working exclusively in the life sciences industry.

From our headquarters in Denmark and offices in France, Germany, Italy, Spain, Switzerland, the United Kingdom, and the United States of America, we serve customers across the globe. With a deep understanding of the life sciences industry, we work hand in hand with customers to identify, develop, and implement strategic initiatives that drive growth, efficiency, and overall success through tailored solutions.

Our partnership with industry-leading solution providers, including Veeva, Salesforce, IQVIA, Benchling, and MediSpend ensures that our clients harness the full potential of the most innovative solutions on the market.

**About the role**:
We seek a highly skilled and motivated Data Engineer to join our Data Insights & Analytics team. In this role, you will be responsible for designing, developing, automating, and maintaining robust data pipelines to ensure efficient data collection, storage, and processing. You will work closely with business analysts, cross-functional teams, and domain experts in the pharmaceutical industry to ensure that the data architecture supports advanced analytics and business intelligence across a range of pharmaceutical projects.

As a Data Engineer your responsibilities include:

- Employ industry-leading performance optimization techniques to ensure the data ingestion process is both efficient and scalable, minimizing latency and maximizing throughput.
- Incorporate comprehensive error handling, exception management, and auditing mechanisms to maintain end-to-end data traceability and ensure data lineage is properly tracked and controlled.
- Design and execute end-to-end tests to ensure the data pipeline and solutions are functioning as expected, covering a variety of data scenarios and ensuring that data flows accurately and reliably from source to target.
- Work closely with cross-functional teams, including data privacy officers, business analysts, and quality assurance teams, to ensure alignment with organizational goals and to facilitate seamless data integration and usage.

We offer this position in Barcelona or Madrid, Spain.

**What makes you the best person for this job?**:
**Educational background**:

- Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related field.

**Experience**:

- Minimum of 3 years of hands-on experience in a Data Engineer role, with a focus on medium to complex data engineering projects, preferably in the pharmaceutical domain.
- Minimum of 2 years of hands-on experience in cloud data transformation platforms such as Azure, AWS, or GCP; relevant certifications are a plus.
- Minimum of 2 years of hands-on experience in Python or equivalent scripting languages is a must.

**Technical Expertise**:

- Proficient in Structured Query Language (SQL) and experienced in working with RDBMS (e.g., PostgreSQL, Oracle, MySQL).
- Skilled in ETL technologies (e.g., IDMC, Databricks), with a strong aptitude for upskilling based on evolving project needs.
- Experience with Cloud Databases (Google Cloud, AWS, Azure) is a must.
- Experience in data modelling and Medallion architecture.
- Familiarity with RESTful API tools (e.g., Postman, OpenAPI) and API Management platforms (e.g., Mulesoft Anypoint, AWS API Gateway, Apigee) is a plus.
- Experience with Snowflake, BigQuery, Redshift, or Azure Synapse is a plus.
- Good understanding of Veeva, Salesforce, IQVIA data models and data sources across HR and Sales functions.
- Familiarity with data visualization and analytics tools such as Power BI, Tableau, and Qlik is essential.
- Solid understanding of DevOps practices and Agile/Lean methodologies.

**Soft-skills**:

- Strong background as a seasoned data engineer with a consulting mindset, capable of working independently and collaborating within medium to large-scale project teams.
- Proven ability to work in dynamic, fast-paced project environments without compromising on quality.
- Excellent problem-solving and troubleshooting abilities.

**What makes us the best employer for you?**:
BASE life science has been recognized as an outstanding workplace, earning us the Great Place To Work certification in Spain, Germany, Switzerland, United States and the United Kingdom.

We are proud to represent 35+ nationalities among our colleagues, and firmly believe in the power of diverse perspectives and characteristics to drive truly innovative solutions and achieving excellence.

At the heart of ou