Snowflake Data engineer

Title: Senior Data Engineer - Snowflake Data Integration & Data Platform
Location: Jersey city, NJ Duration: 12 Month
Only on W2

Key Responsibilities Data Ingestion & Integration

• Design and develop automated ingestion pipelines for Excel, CSV, and structured source files.
• Implement Snowpipe and Snowpipe Streaming solutions 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.

Data Engineering & Snowflake Development

• 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.

Data Modeling

• Design dimensional, relational, and reporting data models.
• Create fact and dimension structures supporting operational workflows and Power BI dashboards.
• Develop audit history and event-based data structures supporting regulatory traceability.
• Define logical and physical data models aligned with business requirements.

Data Quality & Governance

• Implement source-to-target mapping documentation.
• Create automated data quality controls and exception reporting.
• Develop reconciliation processes between source files and Snowflake datasets.
• Support enterprise data governance standards, metadata management, and lineage requirements.
• Establish audit-ready controls supporting regulatory compliance needs.

Project Delivery Support

• Participate in requirements analysis and technical design sessions.
• Support System Integration Testing (SIT), User Acceptance Testing (UAT), and production deployments.
• Collaborate with UI developers, Power BI developers, business analysts, and business stakeholders.
• Produce technical documentation, operational procedures, and support guides.

Required Skills Technical Skills

• Snowflake Data Engineering (Advanced)
• Snowpipe and Snowpipe Streaming
• Snowflake Tasks, Streams, Stored Procedures, and Stages
• Python Development
• SQL Development and Performance Tuning
• AWS S3 Integration
• Data Modeling (Dimensional and Relational)
• ETL/ELT Development
• Data Quality Frameworks
• Source-to-Target Mapping
• CI/CD and DevOps Practices

Integration Platforms
Candidate should possess expertise in one or more of the following:

• Informatica Intelligent Data Management Cloud (IDMC)
• Talend Data Integration
• Python-based data engineering frameworks
• Control M or enterprise scheduling platforms (preferred)

Preferred Skills

• Healthcare Data and Analytics Experience
• Medicare Risk Adjustment Experience
• RADV Audit Data Processing Experience
• CMS Data Submission Experience
• Power BI Data Modeling Support
• AWS Cloud Services
• Data Governance and Metadata Management
• Agile Delivery Methodologies

Expected Deliverables

• End-to-end Snowflake ingestion framework
• Automated Excel and CSV ingestion processes
• Snowpipe-based file processing solution
• Source-to-target mapping documentation
• Snowflake Raw, Curated, and Reporting data layers
• Data quality and reconciliation framework
• Data model documentation
• Production deployment package
• Operational support runbooks
• Monitoring and alerting framework