Data Engineer, Sr.- WFH

About the Role

iSpace, Inc. is seeking a Senior Data Engineer specializing in Snowflake data integration and data platform development for a 12-month remote contract. In this role, you will design and implement scalable data ingestion pipelines, develop Snowflake data layers, and establish automated data quality and reconciliation processes.

You will help build the data platform for RADV Audit Tool 2.0, integrating healthcare and audit-related data from sources including CMS, Optum, and CDAT. Your work will support reliable reporting, regulatory traceability, and the planned production deployment on January 25, 2027.

Key Responsibilities

• Design and develop automated data ingestion pipelines for Excel, CSV, and other structured source files.
• Implement Snowpipe and Snowpipe Streaming solutions to support batch and real-time data processing.
• Configure external stages and ingestion frameworks integrating AWS S3 with Snowflake.
• Develop scalable ETL and ELT pipelines using Python, Talend, Informatica IDMC, or other suitable data engineering frameworks.
• Build metadata-driven ingestion processes that simplify onboarding additional source systems.
• Design and maintain Raw, Curated, Workflow, Audit, and Reporting data layers within Snowflake.
• Develop Snowflake stored procedures, tasks, streams, and orchestration workflows to automate data processing.
• Implement ingestion monitoring, exception handling, automated restart capabilities, and alerting mechanisms.
• Create file-level auditing, reconciliation controls, and data validation frameworks to improve data accuracy and traceability.
• Optimize Snowflake query performance, clustering, and storage utilization.
• Design dimensional, relational, and reporting data models aligned with business requirements.
• Develop fact and dimension structures to support operational workflows and Power BI dashboards.
• Build audit history and event-based data structures to support regulatory traceability.
• Maintain source-to-target mapping documentation and implement automated data quality checks and exception reporting.
• Support enterprise data governance, metadata management, data lineage, and audit-ready controls.
• Participate in requirements analysis, technical design sessions, System Integration Testing (SIT), User Acceptance Testing (UAT), and production deployments.
• Collaborate with UI developers, Power BI developers, business analysts, and business stakeholders to deliver integrated data solutions.
• Prepare technical documentation, data model specifications, operational procedures, deployment packages, and support runbooks.
• Establish reusable ingestion patterns that reduce manual processing and support future risk adjustment initiatives.

Required Qualifications

• Advanced expertise in Snowflake data engineering and data platform development.
• Strong experience with Snowpipe, Snowpipe Streaming, Snowflake tasks, streams, stored procedures, and stages.
• Proficiency in Python development and SQL programming, including performance tuning.
• Experience integrating AWS S3 with Snowflake.
• Strong knowledge of dimensional and relational data modeling.
• Experience developing ETL and ELT pipelines and automated data ingestion frameworks.
• Knowledge of data quality frameworks, source-to-target mapping, reconciliation, and data validation.
• Experience with CI/CD pipelines and DevOps practices.
• Expertise in at least one of the following: Informatica Intelligent Data Management Cloud (IDMC), Talend Data Integration, or Python-based data engineering frameworks.

Preferred Qualifications

• Experience with healthcare data and analytics.
• Familiarity with Medicare Risk Adjustment, RADV audit data processing, or CMS data submissions.
• Experience supporting Power BI data modeling and reporting requirements.
• Knowledge of AWS cloud services beyond S3 integration.
• Experience with enterprise data governance, metadata management, and data lineage.
• Familiarity with Control-M or other enterprise scheduling platforms.
• Experience working with Agile delivery methodologies.

Key Deliverables

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

Salary & Benefits

• Pay rate: $66 per hour on W-2.
• Contract duration: 12 months.

Work Location

Remote. The position lists Clayton, Missouri, as the work location, while the job listing also identifies Georgia. Candidates should confirm the approved remote work location with the recruiter.

Project Impact

This role will help accelerate delivery of the RADV Audit Tool 2.0 data platform, automate the integration of CMS, Optum, CDAT, and audit workflow data, and reduce manual data processing. The resulting framework will support data quality, regulatory compliance, operational monitoring, Power BI reporting, and executive dashboards, with a target production deployment date of January 25, 2027.