Back to Jobs
Recently postedTechnology

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

LiveMindzNew York, NY🇺🇸United States

Quick overview

SeniorityMid-Senior
Work modeHybrid
LocationNew York, NY, United States
SQLGitAWSETLSnowflakeData PipelinePythonAzureSQL ServerCI/CD

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