Senior Data Engineer - Snowflake, ETL Pipelines Leader

Themesoft Inc; New York (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

Themesoft Inc in New York, NY is seeking a Senior Data Engineer to design, build, and support enterprise data pipelines using SQL Server, Snowflake, Python and SSIS. You will partner with business stakeholders, data analysts, and data scientists to deliver scalable data solutions for analytics and reporting.

The role requires hands-on development, data quality enforcement, and migration activities toward Snowflake and Python-based frameworks, with on-site collaboration three days per week and a

Qualifications

• Senior Data Engineer with hands-on experience using SQL Server, Snowflake, Python, and SSIS.
• Able to design, develop and support enterprise data integration and analytics solutions.
• Collaborates with business stakeholders, data analysts and data scientists to deliver scalable data pipelines.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines for ingesting data 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.
• Define and implement data quality rules, validations and reconciliation processes.
• Migrate SQL Server databases, stored procedures and SSIS packages to Snowflake and Python-based frameworks.

Skills

ETL/ELT

Data integration

Stakeholder collaboration

Data quality

Tools

SQL Server

Snowflake

SSIS

Python

Job description

Themesoft Inc in New York, NY is seeking a Senior Data Engineer to design, build, and support enterprise data pipelines using SQL Server, Snowflake, Python and SSIS. You will partner with business stakeholders, data analysts, and data scientists to deliver scalable data solutions for analytics and reporting.

The role requires hands-on development, data quality enforcement, and migration activities toward Snowflake and Python-based frameworks, with on-site collaboration three days per week and a