Senior Data Engineer

Senior Data Engineer (ETL Development & Data Integration)

Our Vision

P\S\L Group is a global organisation dedicated to putting information at the service of medicine.  The companies and people of the P\S\L Group aim to improve medical care by serving those who need it, those who provide it and those who seek to improve it.

To this end, we want our information and education services to contribute to the goals we share with our clinicians, clients and supporters, namely: to accelerate the advancement of medicine and help people enjoy better, longer lives. 

Purpose

Our key contribution to society is to help clinicians and those who support them provide state-of-the-art medical care. Our primary business purpose is to help clients and supporters increase the effectiveness of activities pertaining to scientific communication, medical education and the maintenance of clinician audience intimacy.

Position Summary:

We are seeking a results-driven Senior Data Engineer to play a critical role in designing, developing, and optimizing complex ETL solutions and data integration workflows. This individual will act as a technical leader for the management of enterprise data pipelines, seamless synchronization between platforms, and efficient utilization of OpenSearch for data discovery and reporting.

Key Responsibilities

• ETL Design & Development
• Architect, build, and maintain robust ETL pipelines to automate multi-source data ingestion, transformation, and enrichment.
• Ensure system reliability, scalability, and adherence to data quality and compliance standards.
• Data Integration & Synchronization
• Develop and manage data synchronization and interoperability between internal platforms (e.g., Salesforce, Snowflake, Quickbase, AiMatch, Ongage) and external tools.
• Enable high-fidelity, near real-time data transfer and updates, reducing manual dependencies.
• OpenSearch Implementation
• Lead the adoption, optimization, and management of OpenSearch for indexing, searching, and retrieving large and complex datasets.
• Work with relevant stakeholders to define indexing, querying, and data retrieval solutions that optimize search performance and data accessibility.
• Automation & Tool Integration
• Evaluate, integrate, and manage third-party APIs and off-the-shelf tools to complement internal data workflows.

Requirements:

• 5+ years’ hands-on experience in ETL development, data engineering, and large-scale data integration (using tools such as Python, SQL, Snowflake, DBT, Airflow, Informatica, Talend, etc.).
• Proficiency with OpenSearch (or Elasticsearch), including cluster management, indexing, querying, and optimization for large datasets.
• Proven experience integrating APIs and managing end-to-end data workflows across complex technical environments.
• Deep understanding of data modeling, data governance, and data quality assurance.
• Familiarity with marketing or analytics data platforms (e.g., Salesforce, Segment, Tealium, CDPs, DSPs) is a strong advantage.

Professional Skills:

• Demonstrated analytical and problem-solving skills with the ability to design scalable data solutions.
• Strong communication and interpersonal skills; able to translate business needs into technical solutions.
• Experience working collaboratively in cross-functional, high-performance teams.
• Ability to thrive in a fast-paced, change-oriented environment.

Desirable

• Experience with data cleaning and matching tools (e.g., DataLadder, WinPure) and campaign management platforms.
• Background in healthcare, digital marketing, or large-scale enterprise data solutions.

Perks & Benefits of Joining Our Team at P\S\L Mexico

⚕️  Private Health Insurance
🌍  International Exposure
🤸  Agile Organization
💸  13th-Month Salary (Aguinaldo)
💰  Savings Fund
🍽️  Food Vouchers
💻  Flexible Home Office – Come to the Office at Your Best Convenience
🏖️  12 Vacation Days After Your 3-Month Anniversary
📚  Tuition Reimbursment