описание
Our Key Service Provider is looking for a hands-on Data Engineer ( Mid/Senior). The Product Data Integration team builds and runs the data pipelines that bring R&D product, quality and testing data into PMI's cloud data platform. Demand for our work is growing – from migrating the Quality data domain to a new platform node, to integrating new sources such as battery testing and regulatory data. We are looking for a hands-on Data Engineer to help us design, build, migrate and support these pipelines.
задачи
- Design, build and maintain ELT pipelines that ingest data from internal systems, APIs and files (AWS S3) into Snowflake.
- Develop orchestration and transformation jobs in Matillion, reusing and extending shared frameworks.
- Write efficient, well-structured SQL and Python for data transformation, validation and automation.
- Manage database objects in Snowflake – schemas, tables, views, access roles – and tune performance and cost.
- Support platform migrations: re-point jobs, reconcile data between environments, and analyze differences.
- Monitor production pipelines, resolve incidents, and keep documentation and data quality checks up to date.
- Work with data owners, analysts and engineers across R&D to turn business requests into reliable data products.
требования
- strong hands-on SQL (complex queries, tuning) and Python for data processing.
- practical experience with Snowflake or a comparable cloud data warehouse.
- design, modelling and administration of relational databases (dimensional modelling, indexing/clustering, access control).
- working knowledge of AWS, especially S3 for data storage and ingestion.
- experience with Matillion, or a similar ETL/ELT tool (e.g. ADF, dbt, Informatica, Talend) and willingness to learn it quickly.
- familiarity with Git, CI/CD and DEV→QA→PROD promotion practices.
- Bachelor's degree in Computer Science, Engineering, Mathematics, Physics or a related field.
- Fluency in English.
- 2–5 years in data engineering; delivers pipelines independently with guidance on design.
- 6+ years; owns end-to-end solution design, leads migrations, reviews code and mentors others.
- Будет плюсом: Master’s degree a plus; Experience in regulated environments (quality, life sciences, healthcare, manufacturing) or with laboratory/testing data; Data migration or platform modernization projects; data quality and observability tooling
условия
- You will work at the center of PMI's R&D data landscape, with real ownership, a collaborative international team, and visible impact on how science and quality data are used across the company.