1) Design data pipelines leveraging Cloud Platform and SQL to create and maintain the data warehouse for the client on
Snowflake to enable downstream modeling work.
2) Create detailed documentation of all the existing data flows i.e., Source to Target Mapping documents from functional
3) Create data pipelines using Python, Shell Scripting, and SQL on Snowflake serving the marketing team.
4) Integrate new data feeds like external data files and API calls with the existing Data warehouse in Snowflake using SQL and
5) Perform Exploratory Data Analysis to understand the existing customer behavior
6) Develop a Customer Lifetime Value Model to estimate the top profitable customers to help customize the marketing
7) Leverage existing RFM models as an input while building a new model for Customer Lifetime Value