MIDDLE DATA & AI SUPPORT ENGINEER

Svitla Systems, Inc.; Cambridge; Hybrid; MXN 600,000 - 840,000; Full time

Benefits offered by this job

Medical insurance including family

Remote work support

Christmas bonus 30 days' pay

Vacation: 15 days + 11 holidays

Job summary

Svitla Systems, Inc. is seeking a Middle Data and AI Support Engineer for a full-time role in Mexico. You will provide production support for data pipelines, monitor Airflow DAGs, SnapLogic pipelines, and Databricks jobs, and troubleshoot data issues within defined SLAs.

You will work with a global team, document investigations, manage incidents in ServiceNow, and coordinate with resolver groups. Strong SQL, cloud data platform experience (Databricks/Snowflake/Redshift) and ITIL-based processes

Qualifications

• 3+ years of production support for data pipelines or ETL processes.
• Advanced SQL for data analysis and reconciliation.
• Experience with Airflow and monitoring DAG runs.
• Cloud data platform experience (Databricks or Snowflake); Redshift is a plus.
• ITIL-based incident management and SLAs experience.
• Ability to document investigations and escalate appropriately.
• Strong English communication for handovers with team in India.

Responsibilities

• Monitor Airflow DAG runs, SnapLogic pipelines, and Databricks jobs during shifts.
• Investigate pipeline failures using logs, source file checks, and SQL validation.
• Prioritize incidents by business impact when multiple pipelines fail.
• Execute documented recovery procedures without code changes.
• Escalate unresolved issues with evidence to resolver groups (ServiceNow).
• Validate data loads using SQL in Databricks, Redshift, and Snowflake.
• Provide written handovers and document resolutions for team members.

Skills

SQL

Airflow

Databricks

Snowflake

Redshift

ITIL

ServiceNow

Documentation

English communication

Tools

SnapLogic

Databricks

AWS S3

Job description

Svitla Systems Inc. is looking for a Middle Data and AI Support Engineer for a full-time position (40 hours per week) in Mexico. Our client is a global, science-led biopharmaceutical company specializing in discovering, developing, and commercializing prescription medicines. The company operates in several therapeutic areas, including oncology, cardiovascular, renal, metabolic, respiratory, immunology, and rare diseases. They work alongside the world's leading academic and biotech research institutions to stimulate innovation and evaluate emerging technologies. The client operates in over 100 countries, and its innovative medicines are used by millions of patients worldwide. The headquarters is located in Cambridge, United Kingdom. This location aligns with the focus on science and innovation, providing proximity to leading academic and research institutions.

The Critical Operations team is responsible for keeping US Market data accurate, reliable, and available to business users across areas such as samples, calls, medications, products, and sales.

As a Data Support Engineer, you will provide production support for data pipelines, monitoring Airflow DAGs, SnapLogic pipelines, and Databricks jobs, investigating data issues, and managing incidents, service requests, and problem records. The role focuses on hands-on data investigation, SQL-based validation, documented recovery procedures, and effective issue escalation within defined SLAs.

Requirements

• 3+ years of experience providing production support for data pipelines or ETL processes, working within SLAs in a shift-based or follow-the-sun support model.
• Hands-on experience investigating data issues end-to-end, from source or vendor files through ingestion, transformation, and loading to published tables or reports.
• Advanced SQL skills for data analysis and reconciliation, including joins, CTEs, window functions, row-count reconciliation, and identifying missing or duplicate loads.
• Production experience with Apache Airflow, including monitoring DAG runs, reading task logs, and interpreting Python tracebacks.
• Hands-on experience with a cloud data platform, preferably Databricks or Snowflake; experience with Amazon Redshift or an equivalent platform is also considered.
• Experience handling incidents, service requests, and problem records within an ITIL-based process and defined SLAs.
• Ability to document investigation findings clearly, identify the appropriate resolver team, and provide evidence to support escalation.
• Ability to work independently within documented recovery procedures and elevate issues that require further technical intervention.
• Working English, with the ability to communicate effectively during daily handovers with the team in India.

Will be a plus

• Experience with Databricks, including job runs, Delta tables, and Databricks SQL.
• Experience with Snowflake and Amazon Redshift.
• Experience with SnapLogic or a similar ETL tool.
• Experience working with AWS S3.
• Proactive use of AI tools for troubleshooting, SQL analysis, and technical documentation.
• Basic Python skills for troubleshooting data pipelines.
• Experience with ServiceNow.
• Pharmaceutical industry experience, ideally involving US commercial data such as IQVIA data, CRM calls, and samples.

Responsibilities

• Monitor Airflow DAG runs, SnapLogic pipelines, and Databricks jobs during the assigned shift.
• Investigate pipeline failures by identifying the failing step in logs, checking source file availability in S3, and validating data freshness using SQL.
• Prioritize incidents based on business impact when multiple pipelines fail simultaneously.
• Execute documented recovery procedures from established runbooks without making code changes.
• Escalate issues that cannot be resolved through documented recovery procedures to the appropriate resolver group, providing the relevant evidence and investigation findings.
• Validate data loads using SQL in Databricks, Amazon Redshift, and Snowflake, including row counts by period, missing periods, and duplicate records.
• Manage incidents, service requests, and problem records in ServiceNow within defined SLAs.
• Keep requesters informed throughout the resolution process and document resolution details according to team standards.
• Provide written handovers to the team in India, including open issues, actions taken, and pending decisions.
• Document new failure patterns in the relevant runbook or knowledge base and flag recurring issues for further investigation.

WE OFFER

• Work with #1 winner of the ‘Best Place to Work’ award!
• US and EU projects based on advanced technologies.
• Legal IMSS contract and competitive compensation.
• Regular performance appraisals to support your growth.
• Flexibility in workspace, either remote or in our welcoming office.
• Remote work financial support.
• Comprehensive medical insurance including family.
• Life insurance, maternity policy, family days off.
• Christmas Bonus in the amount of 30 days' payment.
• Bonuses for recommendations of new employees.
• Bonuses for article writing, public talks, other activities.
• 15 vacation days, 25% vacations bonus, 11 national holidays.
• Personalized learning program tailored to your interests and skill development.
• Free tech webinars and meetups organized by Svitla.
• Monthly Pantry Vouchers, free office snacks, and drinks.
• Fun corporate online\offline celebrations and activities.
• Awesome team, friendly and supportive community!