Site Reliability Engineer (Data warehouse administration)

Key Responsibilities

• Operate and support data warehouse platforms such as Hive, Hadoop, ClickHouse, and Vertica in production environments
• Own the stability, availability, and performance of data warehouse systems and supporting infrastructure
• Maintain stable production environments, improve observability, and drive operational excellence across data platforms
• Automate repetitive operational tasks to improve efficiency and reduce manual intervention
• Manage deployment activities, configuration changes, patching, and system upgrades
• Support data workflows including ETL pipelines (e.g., Azkaban), PySpark/SparkSQL processing, and ingestion processes
• Support data platform integrations such as Azure Blob storage and Power BI Gateway connectivity
• Collaborate with data engineering, analytics teams, and vendors to improve system robustness and scalability
• Participate in on-call rotation and support incident response to ensure timely resolution
• Develop and maintain operational documentation, SOPs, and runbooks

Required Skills

• Strong SQL skills with experience working on large-scale data systems
• Hands-on experience with data warehouse platforms (Hive, ClickHouse, Vertica, or similar)
• Experience supporting production data platforms with SLA/SLO awareness (required)
• Strong understanding of distributed systems, preferably within the Hadoop ecosystem
• Experience supporting ETL pipelines, data ingestion, and workflow orchestration tools (e.g., Azkaban, Airflow)
• Solid troubleshooting skills across data pipelines, query performance, and system/infrastructure layers
• Experience with monitoring, alerting, and observability tools
• Working knowledge of Linux systems in production environments
• Experience with scripting (Shell, Python, or similar) for automation
• Experience with deployment processes, environment management, patching, and upgrade activities
• Experience with Spark, PySpark, or SparkSQL troubleshooting
• Familiarity with cloud storage (e.g., Azure Blob) and BI integrations (e.g., Power BI Gateway) is a plus