
Senior Data Engineer (SQL Server) - New York - Local - Hybrid - F2F
Quick overview
Job description
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.
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- HN

Data Platform ManagerRecently posted
Harvey Nash · New York, NY · Hybrid · Posted 20 Nov 2026 🇺🇸
AWSSnowflakeAirflow+4Technology$220k - $260k/yr - EG

Data Engineer with Security ClearanceRecently posted
Eliassen Group · Saint Louis, MO · On-site · Posted 18 Nov 2026 🇺🇸
GCPSQLScala+10TechnologySalary not listed - SI

Data Engineer -- 2/3 days a Week in Dayton, OH -- Only W2Recently posted
Siri Infosolutions Inc · Trotwood, OH · On-site · Posted 19 Nov 2026 🇺🇸
ETLAzureTechnologySalary not listed - GD

NCIS Data Engineer | Active Secret clearance
General Dynamics Information Technology · Quantico, VA · Hybrid 🇺🇸
DockerPL/SQLSQL+14Technology$142.8k - $166.8k/yr - BA

Mid Data EngineerRecently posted
Booz Allen Hamilton · Fort Belvoir, VA · On-site · Posted 18 Nov 2026 🇺🇸
DockerSQLGit+17Technology$62k - $141k/yr - ZP

Senior Data Engineer with Security ClearanceRecently posted
Zachary Piper Solutions, LLC · Honolulu, HI · On-site · Posted 19 Nov 2026 🇺🇸
Microsoft ExcelGitApache Spark+16Technology$120k - $180k/yr - EG

Data Engineer - PlatformRecently posted
Eliassen Group · Glendale, CA · On-site · Posted 20 Nov 2026 🇺🇸
SQLScalaScrum+5Technology$74 - $84/hr - PE

Mid-Level Data Engineer / Active Top Secret with SCI and Polygra with Security ClearanceRecently posted
Peraton · Washington, DC · On-site · Posted 19 Nov 2026 🇺🇸
ETLData PipelineData AnalysisTechnology$86k - $138k/yr - BA

Data EngineerRecently posted
Booz Allen Hamilton · Charlottesville, VA · On-site · Posted 19 Nov 2026 🇺🇸
SQLAWSETL+8Technology$99k - $225k/yr - GA

Staff Data EngineerRecently posted
GE Aerospace · United States · Remote · Posted 19 Nov 2026 🇺🇸
SQLGitApache Spark+8Technology$112k - $150k/yr - BA

Data Engineer with Security ClearanceRecently posted
Booz Allen Hamilton · Charlottesville, VA · On-site · Posted 19 Nov 2026 🇺🇸
SQLAWSETL+8Technology$99k - $225k/yr - RD

Data Systems EngineerRecently posted
Randstad Digital · Marietta, OH · Hybrid · Posted 20 Nov 2026 🇺🇸
SQL.NETC+++1Technology$38 - $41/hr