We are looking for an ETL Developer/Data Engineer to work on various data products dedicated to the pharmaceutical industry. The solutions you will be developing enable services and applications to provide insight for commercial customer service relevant data as well as proactive maintenance and repair to the client.
Apply to Sii and join our Data & Analytics Competency Center!
Your role
- Develop and implement scalable, high-performance data architectures
- Design data models, schema and structures that support business needs
- Ensure solutions are designed for optimal performance, scalability, and reliability
- Write, debug, and optimize complex SQL queries and stored procedures
- Develop ETL (Extract, Transform, Load) processes using tools and technologies compatible with Snowflake
- Implement and manage data integration solutions
- Analyze performance issues and implement solutions to enhance data processing efficiency
- Participate in code reviews and ensure adherence to development standards and best practices
Your skills
- At least 4 years of working with programming languages focused on data pipelines (Python or R)
- Experience with data modeling, data warehousing, and ETL processes
- Proficiency in SQL and experience in the Snowflake cloud environment
- Previous work with different types of storage (filesystem, relations, MPP, NoSQL) and various kinds of data (structured, unstructured, metrics, logs, etc.)
- Familiarity with data integration tools (e.g. Talend, Informatica) and cloud platforms (preferably AWS)
- Exposure to open-source and proprietary cloud data pipeline tools such as Airflow, Glue, DBT, and Dataflow
- Experience in working in data architecture concepts in any of the following areas: data modeling, metadata, workflow management, ETL/ELT, real-time streaming, data quality, distributed systems
- Very good knowledge of relational databases and data serialization languages such as JSON, XML, YAML
- Excellent knowledge of Git, Gitflow, and DevOps tools, e.g. Docker, Bamboo, Jenkins, Terraform
- Capability to conduct performance analysis, troubleshooting, and remediation
- Knowledge of Pharma data formats is a big plus
Job no. 240702-JNCIR
Why Sii
Great Place to Work
it’s thanks to feedback from our workers that we get this special title and constantly implement new ideas
Fascinating projects
prestigious brands from around the world, long-term contracts with many clients
Projects suited to you
Do you want to change your career path? Is your project coming to an end? We’ll find you a new one! We have an app for this – Job Changer
We share the profit with Workers
last year we allocated PLN 23 M to this benefit
PLN 1 000 000 per year for your ideas
with this amount, we support the passions and voluntary actions of our workers
7 500 experts and many development opportunities
Tech Communities, workshops, a training platform, and a technology blog – you choose
Employment stability
revenue of EUR 480M, no debts, since 2006 on the market
Great, comfortable offices
perfect place to work, integrate, have fun together, and celebrate successes
Open-minded and available management team
quick decision-making, we’re all on a first-name basis
True values
these are not empty words – we’re guided by them every day
Fantastic atmosphere
created by all Sii Power People
Attractive Benefits Package
private healthcare, benefits cafeteria platform, car discounts and more