Job Title: Lead Operational Engineer – Data Integration & Support
Key Responsibilities
-
Own day-to-day operational support for integration pipelines built on SnapLogic (or equivalent ETL/iPaaS tools) and dbt-based transformation workflows
-
Monitor pipeline health, proactively identify failures/bottlenecks, and drive root-cause analysis and permanent fixes (not just workarounds)
-
Manage incident response, ticket triage, and SLA adherence for production support issues (P1–P4 severity handling)
-
Lead a small team of support engineers — assign tickets, review fixes, mentor junior engineers, and ensure knowledge transfer
-
Maintain and enhance runbooks, support documentation, and standard operating procedures for the integration landscape
-
Coordinate with Data Platform/Architecture teams on change management, release deployments, and impact assessment for support-affected pipelines
-
Perform regular health checks, capacity/performance reviews, and recommend optimization of existing SnapLogic pipelines and dbt models
-
Manage on-call rotations and escalation processes
-
Track and report operational metrics (uptime, MTTR, ticket volume/trends) to engineering leadership and client stakeholders
-
Partner with client-side counterparts to review open issues, prioritize backlog, and communicate status transparently
Required Skills & Experience
-
Hands-on experience with SnapLogic (or similar ETL/integration tools — Informatica, Talend, Azure Data Factory, MuleSoft) in a production support capacity
-
Strong working knowledge of dbt (models, tests, macros, documentation, CI/CD for transformations)
-
Prior experience in a Managed Services / Application Support / L2-L3 support environment — ticketing tools (ServiceNow, Jira Service Management), incident management, SLA-driven delivery
-
SQL proficiency and experience with cloud data warehouses (Snowflake, Redshift, BigQuery, or similar)
-
Familiarity with cloud platforms (Azure/AWS/GCP) and orchestration/monitoring tools
-
Experience leading or mentoring a small support team
-
Strong troubleshooting and root-cause analysis skills under time pressure
-
Excellent communication skills — comfortable interfacing directly with client stakeholders
