Remote Predictive Analytics Snowflake Integration consultant Part Time or Full time

CapB is seeking a Predictive Analytics Snowflake Integration consultants for its ongoing project. the project is 100% remote and can be done on Full time or Part time basis. The consultant on this project will connect existing code to a new cloud-based warehouse. Currently, existing analytic code is connected to legacy, on-prem warehouses. Responsibilities will include but not be limited to: Write associated SQL queries to support two-way communication for 2 statistical models written in R to a Snowflake database (Academic Predictive and Early Warning models). Rewrite R/SQL in both scripts to consume and transform data from the on-prem warehouse to the cloud-based Snowflake. Provide the traceability matrix or data map for the existing on-prem data warehouse to Snowflake. Work with in-house statistical analytics team to build their capacity to sustain connections to Snowflake. Required Skills & Qualifications Must have expertise and experience working with programming in R, SQL, and cloud-based warehouses. Experience with advanced statistical modeling is required. Experience with Snowflake and Python is preferred.