As a Senior Data Engineer at Home Depot Canada, I excel in crafting and managing data solutions that enhance business intelligence and operational efficiency. My expertise includes leading initiatives such as developing the Decision Analytics data warehouse in Google BigQuery and managing ETL tasks for migrating data from legacy SAP HANA systems. I also oversee the transition of Alteryx workflows to Google Cloud, utilizing SQL and Python data pipelines.I am skilled at designing comprehensive data models and transforming data tables to support diverse teams, including Merchandising, Finance, Supply Chain, and E-commerce. My work provides these teams with access to over 250 business and financial metrics from multiple sources through a unified Tableau solution.In addition to managing the Offshelf portfolio, valued at over $1.5 billion, I have worked extensively on the Decision Analytics, Clearance, and Private Brands portfolios. I provided actionable data insights and analytical solutions for better managing clearance products and supported a $2 billion private brands portfolio with data and analytical needs for improved sourcing, comparisons, and margin optimization.My optimization strategies have notably streamlined processes, reducing the number of SQL scripts needed to update data tables by 50% and consolidating various data flows into a single, efficient process. Additionally, I have automated the entire reporting lifecycle, from ELT pipelines to report publishing, significantly saving analysts’ time.I have also played a key role in diminishing the organization's reliance on Alteryx by converting workflows to SQL and Python data pipelines and transitioning all analytical needs to the cloud. Through mentoring and training cross-functional teams in SQL, I have further reduced the dependency on Alteryx.My automation and optimization projects have saved my team over 100K annually in BigQuery slots. I am dedicated to ensuring data compliance and adhere to SOX regulations to maintain data integrity across all projects.Driven by a passion for leveraging data to fuel strategic decisions, I am always eager to connect with like-minded professionals and explore new opportunities to apply my skills and experience.