Senior Lead Application Support Data Engineer - Informatica PowerCenter & Power BI

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

Publicis Sapient is seeking a Senior Lead Application Support Data Engineer (Informatica PowerCenter & Power BI) for a client in the financial industry, specialized in investment management, to provide advanced production support, operational ownership, and incident management across enterprise data and analytics platforms.

This role is primarily focused on supporting and maintaining critical ETL, data integration, and reporting environments, with Informatica serving as the core technology. The successful candidate will be responsible for incident resolution, root cause analysis, platform support, change management, deployment validation, and operational excellence across business-critical systems. Exposure to Power BI is highly valued, but the ability to quickly learn and support additional platforms is equally important.

The ideal candidate combines strong troubleshooting capabilities, enterprise support experience, and deep Informatica expertise, with a willingness to ramp up on adjacent technologies within the platform ecosystem.

Your Impact

• Lead operational support across enterprise BI and ETL platforms ensuring platform stability and SLA compliance.
• Own end-to-end resolution of critical production incidents, including executive communications, bridge management, and permanent corrective actions.
• Drive root cause analysis activities across multiple technology stacks and coordinate long-term remediation strategies.
• Govern production releases, deployment pipelines, change approvals, and environment promotion processes.
• Partner with infrastructure, development, database, cloud, and vendor teams to resolve complex technical issues.
• Lead platform upgrade initiatives, capacity reviews, performance optimization efforts, and operational readiness activities.
• Mentor L1 and L2 support engineers while establishing operational standards, runbooks, and knowledge management practices.
• Identify automation opportunities and implement self-healing, monitoring, and operational efficiency improvements.

Key Responsibilities

Business Intelligence & Analytics Platforms

• Administer and support Power BI workspaces, datasets, data gateways, Fabric capacity, deployment pipelines, tenant governance, and REST API automation.
• Monitor and troubleshoot scheduled refreshes, subscription failures, data availability issues, and reporting performance concerns.
• Administer Tableau Server environments, TSM operations, extract refreshes, subscriptions, platform upgrades, and capacity management.
• Support SSRS reporting environments including subscriptions, execution logs, caching, snapshots, and report delivery services.

Data Integration & ETL Platforms

• Support Informatica PowerCenter workflows, sessions, parameter files, workflow monitoring, and performance troubleshooting.
• Administer Informatica Intelligent Cloud Services (IICS) mapping tasks, taskflows, secure agents, execution monitoring, and integration operations.
• Troubleshoot ETL failures, performance bottlenecks, source-to-target discrepancies, and data integrity issues.
• Partner with business and technical teams to validate critical enterprise data processing activities.

Incident, Change & Service Management

• Lead major incident response and cross-functional war-room activities for enterprise-critical outages.
• Drive permanent-fix initiatives through structured problem management and RCA ownership.
• Review, approve, and govern production change requests and deployment activities.
• Ensure compliance with ITIL, change management, release management, and operational governance processes.
• Own vendor escalations and coordinate resolution activities with Microsoft and Informatica.

Platform Leadership & Operational Excellence

• Drive continuous improvement initiatives focused on reliability, observability, automation, and service quality.
• Establish operational best practices, standards, and governance frameworks.
• Lead capacity planning, scalability reviews, platform health assessments, and operational maturity initiatives.
• Serve as the technical escalation point for complex production issues.
• Coach and mentor support engineers while improving team effectiveness and technical capabilities.

Qualifications

Skills & Experience

• 6-8+ years supporting enterprise applications, ETL environments, or data platforms in production environments.
• Strong hands-on experience with Informatica PowerCenter and/or Informatica IICS, including troubleshooting, workflow monitoring, incident resolution, and operational support.
• Strong SQL expertise including query troubleshooting, stored procedures, data validation, and performance analysis.
• Experience performing Root Cause Analysis (RCA), incident management, and production issue resolution.
• Experience supporting enterprise platforms operating under SLAs and change management processes.
• Knowledge of ITIL-aligned operational support practices.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication, stakeholder management, and cross-functional collaboration skills.
• Demonstrated ability to learn and support new enterprise platforms and technologies.

Preferred

• Experience supporting Power BI environments, reporting platforms, or business intelligence solutions.
• Experience with monitoring and observability tools such as Splunk, AppDynamics, ELK, or similar technologies.
• Experience working with CI/CD pipelines, release management, and deployment processes.
• Experience mentoring support analysts or participating in operational knowledge-sharing initiatives.

Contract

This is a long-term, full-time (Indefinite) contract.

Work Setup

This position follows a predominantly remote working model. Candidates must be based in Mexico City or within commuting distance, and be available to attend the office when required, for occasions such as team events or in-person team meetings. There is no fixed weekly in-office schedule. We are seeking candidates who are comfortable with this level of flexibility.

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 [email protected]