Senior Data Engineer – Snowflake

iSpace, Inc; United States; Remote; USD 120,000 - 155,000; Full time

Job summary

iSpace, Inc. seeks a Senior Data Engineer to lead Snowflake data integration and platform work. You will design ingestion pipelines, implement Snowpipe streaming, and optimize Snowflake architectures in a remote-capable role based in Clayton, MO.

Applicants will design data models, implement data governance and quality controls, and work with Power BI/analytics stakeholders. A 12-month contract with a $66/hr W2 pay rate is offered.

Qualifications

• Proven experience with Snowflake data engineering and Snowpipe.
• Strong SQL skills and performance tuning for large datasets.
• Hands-on ETL/ELT development and data modeling expertise.
• Experience with AWS S3 and data ingestion frameworks.

Responsibilities

• Design and implement end-to-end Snowflake ingestion framework.
• Build raw, curated, and reporting layers in Snowflake with scripts.
• Develop monitoring, auditing, and automated restart capabilities.
• Collaborate with BI, analytics, and governance teams.
• Produce documentation and operational runbooks for production.

Skills

Snowflake Data Engineering

Snowpipe & Streaming

Snowflake Tasks/Streams/Stored Procs/​

Python Development

SQL Development & Tuning

AWS S3 Integration

Data Modeling (Dimensional/Relational)

ETL/ELT Development

Data Quality Frameworks

Source-to-Target Mapping

CI/CD & DevOps Practices

Tools

Informatica IDMC

Talend Data Integration

Python-based data frameworks

Control M / Enterprise Scheduling

Job description

Title: Senior Data Engineer – Snowflake Data Integration & Data Platform Location: Clayton, MO (REMOTE) Duration: 12 Months

Pay rate $66 Per hr 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

• 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

Business Value

• Accelerate delivery of the RADV Audit Tool 2.0 data platform.
• Enable automated ingestion of CMS, Optum, CDAT, and audit workflow data into Snowflake.
• Reduce manual processing effort through scalable and reusable ingestion patterns.
• Improve data quality, audit traceability, and regulatory compliance.
• Establish a reusable enterprise ingestion framework for future Risk Adjustment initiatives.
• Provide a high-quality data foundation supporting workflow applications, Power BI reporting, operational monitoring, and executive dashboards.
• Support the aggressive January 25, 2027 production deployment timeline by providing dedicated expertise in Snowflake architecture, ingestion automation, and data engineering.