Data Engineer

Medison offers hope to patients suffering from rare and severe diseases by forming partnerships with emerging biotech companies to accelerate access to highly innovative therapies in international markets.

As the creator and leader of the global partnership category in the pharma industry, we strive to be Always Ahead and work relentlessly to bring therapy to patients in need, no matter where they live.

Our values are at the core of every action we take, and we are committed to going above and beyond to benefit the patients we serve.

We are a dynamic, fast-paced company operating in over 34 countries on 5 continents. We are looking for out-of-the-box thinkers, people who are passionate, caring, agile, and adaptive, to join us on our mission. If you are looking to make a difference in people's lives, we invite you to join us!

We are looking for a motivated and business-oriented Data Engineer to join our global Data & BI team.

In this role, you will design, develop, and maintain modern data pipelines and data solutions that support critical business processes across the organization.

You will work closely with global stakeholders, integrate data from multiple sources, ensure data quality and reliability, and contribute to modern data and AI initiatives.

(*Please note, the internal title for this role is Senior Data & BI Specialist, Business Technology.)

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines
• Develop and optimize complex SQL queries and data transformation processes
• Integrate data from internal and external systems, including APIs, databases, and third-party platforms
• Own data quality, monitoring, reliability, and governance processes
• Investigate and resolve data-related issues while supporting business users
• Take ownership of data workflows from design and development through production support
• Collaborate with global stakeholders to understand business requirements, analyze data discrepancies, and deliver reliable data solutions
• Design, develop, and maintain AI-powered data solutions that support business decision-making and operational excellence
• Build and implement monitoring capabilities (e.g. anomaly detection, forecasting, etc.) using modern AI capabilities
• Partner with business teams to identify opportunities for applying AI and LLM-based solutions to real-world business challenges
• Develop and operationalize AI workflows and data products from proof-of-concept through production deployment

Requirements

• Bachelor’s degree in Information Systems, Computer Science, Industrial Engineering, Economics, Business Administration, or a related field
• 3+ years of experience in Data Engineering, BI Engineering, Data Operations, or a similar role
• Extensive experience with Data Warehouse architecture and data modeling best practices
• Strong hands-on experience building and maintaining end-to-end data pipelines
• Advanced SQL proficiency (must)
• Experience working with AWS environments (2+ years)
• Hands-on experience with Snowflake, including Snowflake Cortex (2+ years)
• Hands-on experience building AI, Machine Learning, or Generative AI solutions
• Experience identifying anomalies, patterns, and business insights using statistical and AI-based approaches
• Experience integrating AI services into data platforms and business processes
• Experience deploying and supporting ML/AI solutions in production environments
• Experience with DBT (2+ years)
• Experience with ETL/ELT tools and modern data platforms (Rivery, Fivetran)
• Experience working in a global company
• Experience integrating data from multiple sources and technologies
• Strong problem-solving skills and ability to work independently
• Strong communication skills and experience working with global stakeholders
• High level of English and Hebrew, both written and spoken

Advantages

• Experience with Python
• Experience with LLMs, Retrieval-Augmented Generation (RAG), and AI agent architectures
• Familiarity with BI and analytics tools
• Experience with Amazon Bedrock
• Experience working with semantic layers in AI-driven solutions
• Experience with Apache NiFi