Senior L2/L3 Production Support Data Engineer (Python + SQL + AWS)

Publicis Groupe; Colombia; Remote; COP 120,000,000 - 180,000,000; Full time

Benefits offered by this job

Inclusive workplace

Learning opportunities

Competitive compensation

Work-life balance

Health benefits

Paid leave

Wellness program

Job summary

Publicis Sapient is seeking a Senior Production Support Data Engineer to maintain and operate critical data platforms on AWS, ensuring reliability, performance, and smooth production releases for global teams.

You will troubleshoot incidents, optimize complex SQL queries, develop Python automation, and collaborate with engineering, infrastructure, and business stakeholders to prevent recurrences and continually improve data quality and platform stability.

Qualifications

• 5+ years of experience in Data Engineering and Production Support roles.
• Strong hands-on experience writing and optimizing complex SQL queries.
• Experience supporting and operating AWS-based data platforms and services.
• Strong knowledge of Amazon Aurora, including performance tuning and troubleshooting.
• Experience investigating and resolving production issues within data ecosystems.
• Hands-on experience with Python for scripting, automation, and operational support activities.
• Ability to perform root cause analysis and drive issue resolution independently.
• Strong communication, stakeholder management, and coordination skills.

Responsibilities

• Monitor, troubleshoot, and resolve complex production incidents across data platforms and AWS services.
• Perform root cause analysis and implement preventive measures to improve platform stability and reliability.
• Support and optimize SQL queries, stored procedures, and database performance in production environments.
• Investigate data quality, pipeline, and integration issues while ensuring timely resolution of business-critical incidents.
• Collaborate with development, infrastructure, and business teams to coordinate issue resolution and production releases.
• Develop automation scripts and operational tools using Python to improve support efficiency and reduce manual effort.
• Maintain operational documentation, knowledge articles, and support runbooks for recurring issues and processes.

Skills

Data Engineering

SQL optimization

AWS

Python scripting

Incident management

Root cause analysis

Communication skills

Tools

Amazon Aurora

Amazon DocumentDB

AWS CloudWatch

Job description

Company description

Publicis Sapient is a digital transformation partner helping established organizations get to their future, digitally enabled state, both in the way they work and the way they serve their customers. We help unlock value through a start-up mindset and modern methods, fusing strategy, consulting, and customer experience with agile engineering and problem-solving creativity. United by our core values and our purpose of helping people thrive in the brave pursuit of next, our 20,000+ people in 53 offices around the world combine experience across technology, data sciences, consulting, and customer obsession to accelerate our clients’ businesses through designing the products and services their customers truly value.

Overview

Senior Production Support Data Engineer, you will be responsible for supporting and maintaining critical data platforms and production environments. This is a long-term L2/L3 support role requiring strong analytical and troubleshooting skills to investigate, resolve, and prevent data-related incidents in cloud-based environments. You will work closely with engineering, infrastructure, and business teams to ensure the reliability, stability, and performance of data systems running on AWS.

Responsibilities

Your Impact

• Monitor, troubleshoot, and resolve complex production incidents across data platforms and AWS services.
• Perform root cause analysis and implement preventive measures to improve platform stability and reliability.
• Support and optimize SQL queries, stored procedures, and database performance in production environments.
• Investigate data quality, pipeline, and integration issues while ensuring timely resolution of business-critical incidents.
• Collaborate with development, infrastructure, and business teams to coordinate issue resolution and production releases.
• Develop automation scripts and operational tools using Python to improve support efficiency and reduce manual effort.
• Maintain operational documentation, knowledge articles, and support runbooks for recurring issues and processes.

Qualifications

Skills & Experience

• 5+ years of experience in Data Engineering and Production Support roles.
• Strong hands-on experience writing and optimizing complex SQL queries.
• Experience supporting and operating AWS-based data platforms and services.
• Strong knowledge of Amazon Aurora, including performance tuning and troubleshooting.
• Experience investigating and resolving production issues within data ecosystems.
• Hands-on experience with Python for scripting, automation, and operational support activities.
• Ability to perform root cause analysis and drive issue resolution independently.
• Strong communication, stakeholder management, and coordination skills.

Set Yourself Apart With

• Experience supporting Amazon DocumentDB environments.
• Exposure to AWS monitoring and observability tools such as CloudWatch.
• Experience with incident management, problem management, and ITIL-based support processes.
• Knowledge of data pipelines, ETL workflows, and batch processing systems.
• Experience building operational automation solutions to reduce manual support effort.
• Ability to identify recurring issues and proactively implement improvements to system reliability.

Additional information

• An inclusive workplace that promotes diversity and collaboration.
• Access to ongoing learning and development opportunities.
• Competitive compensation and benefits package.
• Flexibility to support work-life balance.
• Comprehensive health benefits for you and your family.
• Generous paid leave and holidays.
• Wellness program and employee assistance.

As part of our dedication to an inclusive and diverse workforce, Publicis Sapient is committed to Equal Employment Opportunity without regard for race, color, national origin, ethnicity, gender, protected veteran status, disability, sexual orientation, gender identity, or religion. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at [e-mail]