Job Description
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. Apply tot his job