About the role
Senior Data Engineer
New York - Local - Hybrid - F2F
Design, develop, and maintain ETL/ELT pipelines for ingesting data from multiple source systems into Snowflake-based Enterprise Data Warehouse.
• Develop scalable data integration solutions using SQL Server, SSIS, Python, and Snowflake.
• Create and optimize SQL queries, stored procedures, views, and data transformation logic.
• Build ingestion frameworks for batch and incremental data loads.
• Implement metadata-driven and reusable data pipeline components.
• Support migration of SQL Server databases, stored procedures, and SSIS packages to Snowflake and Python-based frameworks.
• Define and implement data quality rules, validations, and reconciliation processes.
• Perform root cause analysis for data quality issues and implement corrective actions.
• Ensure data integrity, consistency, and compliance across data platforms.
• Maintain data lineage, audit, and operational logging processes.
• Design and develop Snowflake databases, schemas, tables, views, stages, streams, tasks, and data pipelines.
• Implement data loading processes using Snowflake native capabilities.
• Optimize Snowflake warehouse utilization, query performance, and overall operational efficiency.
• Support role-based access control, security, and governance requirements.
• Experience with Azure/AWS Cloud services.
• Experience with CI/CD, Git, and DevOps practices.
Testing & User Acceptance Support
• Work closely with business users during System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Support defect triage, issue resolution, and validation activities.
• Prepare test cases, reconciliation reports, and deployment validation documentation.
Production Support & Optimization
• Monitor ETL/ELT pipelines and batch processes.