Live Operations Analyst (ETL & SQL)

About the role

The Live Operations Analyst supports Tier 1‑2 production operations for Reveleer’s data platform, ensuring scheduled workflows run smoothly and issues are resolved quickly. The role provides overnight delivery coverage and morning triage, working from documented runbooks and escalation procedures.

Key responsibilities

• Monitor scheduled production workflows, file movements, processing status and operational alerts.
• Perform first‑pass diagnosis of failed or delayed workflows, including submissions analysis and member‑management troubleshooting.
• Execute approved reruns, reprocesses, recoveries and configuration changes, then validate successful completion.
• Operate and monitor Flatfile ingestion pipelines and MuleSoft integrations, following documented recovery procedures.
• Support secure file transfer, S3/sFTP delivery, folder configuration and access provisioning.
• Create accurate tickets, capture logs and evidence, and escalate to Lead Live Operations Engineer when issues exceed runbook authority.

Required profile

• 2+ years of production support, data operations or integration support experience.
• Hands‑on experience with Flatfile and MuleSoft in a production environment.
• Working knowledge of AWS S3, secure file transfer protocols and basic‑to‑intermediate SQL for read‑only investigations.
• Strong ticket hygiene, documentation habits and ability to follow runbooks and SOPs.
• Willingness to work a 24×7 schedule with offshore overnight shifts and rotational weekly offs.

Required skills

• Flatfile
• MuleSoft
• AWS S3
• sFTP / secure file transfer
• SQL (read‑only diagnostics)
• Basic Python or shell scripting (preferred)
• Terraform / infrastructure‑as‑code concepts (preferred)
• API integration and ETL pipeline knowledge (preferred)