Data & AI Engineering Expert

1482 Opella Healthcare Colombia S.A.S.; Bogotá ciudad; On-site; COP 194,200,000 - 291,300,000; Full time

Job summary

Opella is seeking a Data Engineer to design, develop, and maintain data infrastructure and pipelines. You will collaborate with data scientists, analysts, and stakeholders to ensure data is accessible, accurate, and actionable.

The ideal candidate has experience with Databricks, Apache Iceberg, Unity Catalog, Python, Airflow, DBT, and strong cloud platform skills (AWS, Azure). Join Opella to contribute to scalable data solutions, data governance, and security practices while staying current with

Qualifications

• Bachelor’s degree in computer science, engineering, data science, or related field.
• Proven experience with Databricks data platform design and optimization using Apache Iceberg and Unity Catalog.
• Proficiency in Python for data manipulation, automation, and ETL/ELT processes.
• Strong experience with Airflow and DBT for data ingestion, transformation and modeling.
• Hands-on experience with major cloud providers (AWS and Azure).
• Solid understanding of data warehousing concepts and practices.
• Excellent problem-solving skills and attention to detail.
• Strong communication skills with the ability to work collaboratively in a team environment.
• Experience with Snowflake data platform and Informatica Cloud for data integration and cloud data management.
• Knowledge of data governance and data security best practices.

Responsibilities

• Design, implement, and maintain data pipelines and ETL processes using Databricks with Apache Iceberg and Unity Catalog, Python, Airflow, and DBT.
• Develop and optimize data models and schemas to support analytical and reporting needs.
• Collaborate with cross-functional teams to understand data requirements and deliver scalable data solutions.
• Manage data integration and migration projects across various cloud platforms mainly AWS and Azure.
• Monitor and troubleshoot data workflows and ensure high data quality and availability.
• Stay current with industry trends and best practices in data engineering and cloud technologies.

Skills

Python

Problem solving

Data manipulation

Education

Bachelor’s degree in Computer Science, Engineering, Data Science, or related field

Tools

Databricks

Apache Iceberg

Unity Catalog

DBT

Airflow

AWS

Azure

Snowflake

Informatica Cloud

Job description

Opella is the self-care challenger with the purest and third-largest portfolio in the Over-The-Counter (OTC) & Vitamins, Minerals & Supplements (VMS) market globally. Our mission is to bring health in people’s hands by making self-care as simple as it should be. For half a billion consumers worldwide – and counting. At the core of this mission is our 100 loved brands, our 11,000-strong global team, our 13 best-in-class manufacturing sites and 4 specialized science and innovation development centers. Headquartered in France, Opella is the proud maker of many of the world’s most loved brands, including Allegra, Buscopan, Doliprane, Dulcolax, Enterogermina, Essentiale and Mucosolvan. B Corp certified in multiple markets, we are active players in the journey towards healthier people and planet. Find out more about our mission at www.opella.com.

About the job:

As a Data Engineer at Opella, you will play a critical role in designing, developing, and maintaining our data infrastructure and pipelines. You will work closely with data scientists, analysts, and other stakeholders to ensure that data is accessible, accurate, and actionable. The ideal candidate will have expertise in Databricks data platform using Apache Iceberg and Unity Catalog, Python, DBT, Airflow and be proficient in major cloud platforms (AWS, Azure). Experience with Informatica Cloud and Snowflake will be considered a plus.

Main responsibilities:

• Design, implement, and maintain data pipelines and ETL processes using Databricks with Apache Iceberg and Unity Catalog, Python, Airflow, and DBT.
• Develop and optimize data models and schemas to support analytical and reporting needs.
• Collaborate with cross-functional teams to understand data requirements and deliver scalable data solutions.
• Manage data integration and migration projects across various cloud platforms mainly AWS and Azure.
• Monitor and troubleshoot data workflows and ensure high data quality and availability.
• Stay current with industry trends and best practices in data engineering and cloud technologies.

About you:

Bachelor’s degree in computer science, Engineering, Data Science, or a related field.

Proven experience with Databricks data platform design and optimization using Apache Iceberg and Unity Catalog.

Proficiency in Python for data manipulation, automation, and ETL/ELT processes.

Strong experience with Airflow and DBT for data ingestion, transformation and modeling.

Hands-on experience with major cloud providers (AWS and Azure).

Solid understanding of data warehousing concepts and practices.

Excellent problem-solving skills and attention to detail.

Strong communication skills with the ability to work collaboratively in a team environment.

Experience with Snowflake data platform and Informatica Cloud for data integration and cloud data management.

Knowledge of data governance and data security best practices.

Why us?

At Opella, you will enjoy doing challenging, purposeful work, empowered to develop consumer brands with passion and creativity. This is your chance to grow new skills and be part of a bold, collaborative, and inclusive culture where people can thrive and be at their best every day. We Are Challengers. We are dedicated to making self-care as simple as it should be. That starts with our culture. We are challengers by nature, and this is how we do things:

• All In Together: We keep each other honest and have each other's backs.
• Courageous: We break boundaries and take thoughtful risks with creativity.
• Outcome-Obsessed: We are personally accountable, driving sustainable impact and results with integrity.
• Radically Simple: We strive to make things simple for us and simple for consumers, as it should be.

Join us on our mission. Health. In your hands. www.opella.com/en/careers

Opella is the self-care challenger with the purest and third-largest portfolio in the Over-The-Counter (OTC) & Vitamins, Minerals & Supplements (VMS) market globally. Our mission is to bring health in people’s hands by making self-care as simple as it should be. For half a billion consumers worldwide – and counting. At the core of this mission is our 100 loved brands, our 11,000-strong global team, our 13 best-in-class manufacturing sites and 4 specialized science and innovation development centers. Headquartered in France, Opella is the proud maker of many of the world’s most loved brands, including Allegra, Buscopan, Doliprane, Dulcolax, Enterogermina, Essentiale and Mucosolvan. B Corp certified in multiple markets, we are active players in the journey towards healthier people and planet. Find out more about our mission at www.opella.com.