Position Summary
The Senior Analyst will support the day-to-day operations of the HR2030 Medallion lakehouse, helping ensure reliable data ingestion, processing, and availability across Bronze, Silver, and Gold layers. This hands-on role will monitor scheduled pipelines, investigate failures and data-quality issues, execute approved recovery and maintenance activities, and coordinate timely resolution with engineering, platform, source-system, and data-product teams. The successful candidate will combine technical troubleshooting skills with disciplined operational practices, clear communication, and a strong focus on data reliability, security, and continuous improvement in a global support environment.
Location: India – Bangalore (On-site/Hybrid)
Reports to: IT Director, D&I Program Leader
Department: Johnson & Johnson Technology – Corporate Business Technology (CBT)
Key Responsibilities
•Daily operations monitoring: Monitor Medallion pipeline schedules, execution status, dependencies, and data freshness across Bronze, Silver, and Gold layers; identify missed loads, delays, and processing failures.
•Incident triage and recovery: Investigate alerts and operational incidents using logs and data checks; execute approved reruns, restarts, and recovery procedures, validate results, and escalate unresolved issues against agreed service targets.
•Data-quality checks and reconciliation: Perform routine completeness, accuracy, duplication, and source-to-target reconciliation checks; log exceptions, coordinate remediation, and confirm data readiness for downstream consumption.
•Service requests and maintenance: Manage the daily support queue, prioritize requests by business impact, and perform approved data reloads, backfills, and routine maintenance following established controls and runbooks.
•Operational controls: Follow HR data privacy, security, access, and retention requirements; maintain execution evidence and coordinate access requests through approved processes.
•Release and change support: Support operational readiness checks, testing, and deployment validation for pipeline changes; confirm monitoring, support documentation, recovery procedures, and handover are in place.
•Upstream and downstream coordination: Work with source-system owners, engineering teams, and data-product consumers to resolve feed issues, schema changes, and dependency failures; communicate expected recovery times and business impacts.
•Operational reporting and handovers: Maintain daily service-health updates, incident records, and shift handovers for India/US teams; track pipeline success, data freshness, incident ageing, resolution times, and recurring issues.
•Reliability and continuous improvement: Support root-cause analysis, implement approved corrective actions, automate repeatable checks, and identify performance and resource-usage improvements to reduce recurring incidents and manual effort.
Qualifications
•Bachelor's degree in Computer Science, Information Technology, Data Engineering, Analytics, Business Analytics, Engineering, or a related field.
•5+ years of experience in data engineering, data-platform operations, production support, or a related discipline, including hands-on support of scheduled data pipelines.
•Experience monitoring and troubleshooting production ingestion and transformation pipelines, managing dependencies, and validating recovery from failed or delayed processing.
•Strong SQL skills and working proficiency in Python or a comparable scripting language for troubleshooting, reconciliation, and automation of operational checks.
•Practical understanding of lakehouse and Medallion architecture, including Bronze, Silver, and Gold processing, incremental loads, schema changes, and data-quality controls.
•Experience with incident, problem, and change management; ability to prioritize by business impact, follow runbooks, maintain support records, and work against agreed service targets.
•Strong written and verbal communication skills, with the ability to explain service impacts, provide clear incident updates, and document troubleshooting and recovery procedures.
•Demonstrated collaboration, attention to detail, accountability, and ability to work across global teams and time zones.
•Experience with cloud data platforms, pipeline orchestration and monitoring tools, version control, and controlled deployments is preferred; familiarity with HR data privacy and security requirements is an advantage.
Preferred Skills: Medallion Operations, Lakehouse Support, SQL, Python, Pipeline Monitoring, Incident Management, Root-Cause Analysis, Data Reconciliation, Data Quality, Job Scheduling, Operational Automation, Runbook Documentation, Change Management, Data Privacy Standards, Stakeholder Communication.
