Data Analyst
CurrentPartnered with the business to provide a data centric perspective and translated business needs to design and develop tools, techniques and key metrics. Built pipelines for safe and timely data transfer and also created dashboards for insights and data visualization. •Built and maintained Snowflake (SQL) and Databricks (Python) scripts to query data for over 16 marketing channels of Capital One. Worked collaboratively with the tech team to productionalize these scripts into automated pipelines that deliver time sensitive data to the model builders. Impact: Hassel free data pull for rebuild and refresh of Media Mix Model for marketing.•Created, validated and implemented a classification script in Databricks for data with over 200 fields. The logic was provided by an external provider who performed the classification on their proprietary platform. Impact: The results from this classification script was used in analysis that created value by providing meaningful insights on business strategies which in turn increased efficacy of marketing expenses.•Created reusable data quality tools in Databricks to be easily used by anyone creating a daily pipeline across the enterprise. Impact: Created an understanding and emphasized on discipline to adhere to the principles of data quality management including metadata, lineage, and business definitions. •Worked as a liaison between the marketing channel owners, business analysts, leadership and media mix model providers. Impact: A seamless journey from data pull to the final insights read out from the model provider. •Worked on data analysis, interpretation and validation of script-logics created by fellow analysts on a regular basis. •Created data visualizations and assisted with business intelligence initiatives of building dashboards in tableau. The idea was to enable the internal business team usage of data collected for media mix model. Value addition: Previously unavailable channel wise marketing Spend.