Data Support Engineer- 7+ yrs- New York, New York- Onsite

Job Description :

Joonitor, support, and maintain enterprise data pipelines and ETL workflowsPerform advanced SQL analysis for troubleshooting, reconciliation, and operational reportingInvestigate and resolve production data issues, failures, latency, and data discrepanciesConduct root cause analysis across databases, ETL jobs, APIs, and downstream systemsSupport daily operational health checks, incident management, and SLA adherenceAnalyze large datasets to identify anomalies, trends, and data quality issuesCollaborate with business users, application teams, and platform engineering teams to resolve data-related incidentsExecute data validation, reconciliation, and integrity checks across multiple systemsOptimize SQL queries and data processing performanceSupport batch and near real-time data movement processesBuild and maintain operational dashboards, alerts, and monitoring solutionsAssist with deployment validation, release support, and production readiness activitiesCreate operational runbooks, troubleshooting guides, and support documentationDrive automation initiatives for monitoring, alerting, and issue remediationRequired SkillsStrong SQL expertise including:

Complex joins and subqueriesQuery tuning and optimizationWindow functionsStored proceduresData analysis and reconciliationHands-on experience supporting ETL/ELT processes and workflowsExperience with ETL tools/platforms such as:

Azure Data FactorySSISStrong analytical and troubleshooting skills in production support environmentsExperience investigating data quality, transformation, and integration issuesKnowledge of relational and cloud databases:

SQL ServerAzure SQLFamiliarity with monitoring and observability toolsUnderstanding of data lifecycle management and operational support processes