Operational Data Engineer

About the Role:

We are looking for a seasoned Data Lead Operational Data Engineer with a strong background in SQL, ETL, and data operations. This role is pivotal in ensuring the stability, scalability, and efficiency of our data infrastructure and operational workflows. The ideal candidate will bring deep technical expertise along with a proactive approach to monitoring, support, and continuous improvement.

---

Key Responsibilities:

Data Engineering & ETL:

Design, build, and maintain scalable ETL pipelines for data ingestion, transformation, and delivery.

Optimize SQL queries and data workflows for performance and reliability.

Collaborate with data analysts, scientists, and business stakeholders to understand data needs and deliver solutions.

Operational Engineering & Support:

Own and manage the operational health of data systems, ensuring uptime, performance, and data integrity.

Monitor production data pipelines and proactively resolve issues before they impact business operations.

Implement alerting and monitoring systems to detect anomalies and failures in real-time.

Perform root cause analysis (RCA) and post-mortems for incidents, driving long-term fixes and improvements.

Manage job scheduling, workflow orchestration, and dependency management using tools like Airflow, Control-M, or similar.

Automate routine operational tasks to improve efficiency and reduce manual intervention.

Maintain documentation for operational procedures, runbooks, and support guides.

Collaborate with DevOps and infrastructure teams to ensure smooth deployment and scaling of data services.

Participate in on-call rotations and provide L2/L3 support for data-related incidents.

---

Required Skills & Qualifications:

8+ years of experience in data engineering, operations, or a similar role.

Strong command of SQL and experience with performance tuning and troubleshooting.

Hands-on experience with ETL tools and data pipeline frameworks.

Proven track record in data operations, monitoring, and support.

Familiarity with cloud platforms (AWS, Azure, GCP) and data services.

Proficiency in scripting languages (e.g., Python, Shell) for automation and tooling.

Strong analytical and problem-solving skills.

Excellent communication and collaboration abilities.