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.