דרושים » דאטה » data Engineering team leader

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

City:
Petah Tikva

Our Data team consists of highly skilled senior software and data professionals who collaborate to solve complex data challenges. We process billions of records daily from multiple sources using multi-stage pipelines with intricate data structures and advanced queries.

We are responsible for building data pipelines end to end-from raw data ingestion to the creation of actionable datasets-following the bronze, silver, and gold paradigm. This includes business logic, infrastructure, ETLs, optimization, and ongoing maintenance.

The data we deliver drives insights and decision-making across the organization and enhances our product offerings. We leverage technologies such as AWS, Snowflake, Iceberg, Airflow, Spark, and more.

What Youll Do

Lead the translation of business and product requirements into scalable data models, transformations, and pipelines.

Design and own datasets across bronze, silver, and gold layers, including defining grain, aggregations, and data contracts.

Develop and maintain SQL-heavy data pipelines and Airflow DAGs (workflow logic, dependencies, backfills, python, and lots of SQL).

Own data correctness for key business metrics (e.g., ARR), including deep root cause analysis and resolution of data issues.

Define and drive best practices for SQL, data modeling, and pipeline design across the team.

Optimize queries and data models for performance, scalability, and cost efficiency.

Collaborate closely with product managers, analysts, and BI developers to refine requirements and ensure high-quality data delivery.

Develop AI-agents to accelerate data analysis by internal and external users.

Work with complex data inputs (e.g., JSON, schemas, logs) and incorporate them into robust data pipelines.

We are looking for a highly skilled Data Engineer to join our growing Data Analytics Department.
As a Data Engineer in a multi cloud company, you will build data-driven solutions for our customers using cutting-edge data tools and large-scale data on AWS\GCP\Azure.
Job Responsibilities:
Lead data solutions design and development for our various clients and projects.
Design the solution by understanding the needs, modeling the data, choosing the right tools and defining the interfaces/dashboards.
Develop Data Pipelines, Data Lakes, DWHs, AI\ML models, Dashboards and reports using advanced tools and leading technologies.