Associate, DataOps & Analytics
Bain & Company
SnowflakeSQLSnowflake Cortex CodePythonPySparkData QualityBusiness AnalyticsKPI AnalysisRoot-Cause AnalysisProcess OptimizationWorkflow AutomationGenAI
- Transformed recurring monthly delivery workflows into reusable, AI-assisted processes using Snowflake Cortex Code, reducing manual intervention and simplifying execution.
- Introduced phased execution with checkpoints, validation and resumability, improving process control and delivery reliability.
- Automated generation of subsequent monthly SQL workflows from existing templates, reducing repetitive development effort.
- Established automated post-execution checks covering record counts, null values, distinct values and schema profiling.
- Built structured JSON quality summaries and comparisons across reporting cycles to identify anomalies, unexpected trends and inconsistencies.
- Strengthened delivery controls by catching potential data issues before outputs reached stakeholders.
- Reviewed and optimized SQL workflows and stored procedures, eliminating redundant operations, repeated table rewrites and unnecessary processing steps.
- Analyzed query performance and warehouse utilization to improve execution efficiency and optimize compute consumption.
- Contributed to reducing processing time and operational costs through workflow simplification and resource optimization.
- Analyzed business KPIs, including sales, orders and customer activity, across customer segments, fulfilment types and basket sizes.
- Investigated unexpected KPI movements by reconciling multiple data sources and distinguishing genuine business trends from data-capture inconsistencies.
- Used weekly and monthly comparisons to identify emerging trends, anomalies and the underlying drivers of performance.
- Translated complex analytical findings into concise, client-ready weekly and monthly performance summaries.
- Developed executive updates and presentation storylines highlighting key trends, performance drivers and actionable recommendations.
- Supported data-driven discussions by communicating findings in a clear, structured and business-oriented manner.
Ways of working. Human-in-the-loop AI automation: I use AI to accelerate analytical workflows and operational execution while keeping human review, validation and approval of outputs within established access controls.
What's next. Expanding AI-assisted operational workflows, automating recurring reporting and quality-control processes, and building performance dashboards for better operational visibility and decision-making.