Senior Data Engineer (SQL Server) - New York - Local - Hybrid - F2F

Hybrid in New York, NY, US • Posted 7 hours ago • Updated 7 hours ago
Contract W2
Contract Independent
Contract Corp To Corp
6 Months
No Travel Required
Hybrid
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Amazon Web Services
  • ELT
  • Data Quality
  • Data Loading
  • Continuous Delivery
  • Continuous Integration
  • Data Integrity
  • Extract, Transform, Load
  • Meta-data Management
  • Microsoft SQL Server
  • Microsoft SSIS
  • Migration
  • SQL
  • Python
  • Test Cases
  • Snow Flake Schema

Summary

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 90915265
  • Position Id: 9147223
  • Posted 7 hours ago
Contact the job poster
SR

Srikanth Racha

Recruiter @ LiveMindz

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.