Senior Snowflake Data Platform Engineer

Kaizen Soft Solutions; Jersey City (NJ); On-site; USD 140,000 - 185,000; Full time

Job summary

Kaizen Soft Solutions seeks a Senior Data Engineer to architect and build a robust Snowflake-based data platform in Jersey City, NJ. The role focuses on data ingestion, transformation, and governance across raw, curated, and reporting layers.

You will implement Snowpipe, streaming, and orchestration with Python, Talend, or Informatica IDMC, while enabling scalable ELT/ETL pipelines and Power BI-ready data models for analytics.

Qualifications

• Design automated ingestion pipelines for Excel, CSV, and structured source files.
• Implement Snowpipe and Snowpipe Streaming for real-time and batch processing.
• Configure external stages and ingestion frameworks utilizing AWS S3 and Snowflake.
• Develop scalable ELT/ETL solutions using Python, Talend, or Informatica IDMC.
• Build metadata-driven ingestion processes supporting future onboarding of new source systems.

Responsibilities

• Design Raw, Curated, Workflow, Audit, and Reporting layers within Snowflake.
• Create ingestion monitoring, exception handling, and automated restart capabilities.
• Develop stored procedures, tasks, streams, and orchestration workflows.
• Implement file-level auditing, reconciliation controls, and data validation frameworks.
• Optimize Snowflake performance, clustering, and storage utilization.

Skills

Snowflake Data Engineering

Python Development

SQL Performance Tuning

ETL/ELT Development

Data Modeling (Dimensional/Relational)

Source-to-Target Mapping

CI/CD & DevOps

Data Quality Frameworks

Tools

Snowpipe

Snowflake Tasks/Streams/Stored Procedures/Stages

AWS S3 Integration

Talend Data Integration

Informatica IDMC

IDMC

Job description

Kaizen Soft Solutions seeks a Senior Data Engineer to architect and build a robust Snowflake-based data platform in Jersey City, NJ. The role focuses on data ingestion, transformation, and governance across raw, curated, and reporting layers.

You will implement Snowpipe, streaming, and orchestration with Python, Talend, or Informatica IDMC, while enabling scalable ELT/ETL pipelines and Power BI-ready data models for analytics.