Kunal Rizwani

• Led the architecture and ownership of Altria’s unified analytics platform, consolidating CRM, ERP, billing, telemetry, vendor QA, and customer feedback data into governed Snowflake and SQL models used across Product, Finance, Operations, and Engineering. • Designed and scaled 300+ dbt models with modular patterns, incremental logic, tests, contracts, lineage, and CI/CD validation, improving reliability by 50% and establishing consistent modeling standards across teams. • Built and automated end-to-end Airflow and Python pipelines integrating S3, Salesforce, NetSuite, QA logs, and device telemetry, improving data latency and reducing manual reporting by 50+ hours per week. • Developed semantic layers and dimensional data marts that standardized 80+ KPIs covering revenue, cohorts, customer health, device performance, and operational quality, enabling single-source-of-truth reporting for leadership. • Delivered executive-grade dashboards in Tableau, Looker, and Power BI covering financial forecasting, churn, cohort behavior, supply chain trends, and product analytics, improving visibility into business performance and operational bottlenecks. • Implemented comprehensive data quality frameworks including dbt tests, freshness SLAs, anomaly detection, schema enforcement, and Github Actions CI/CD checks, reducing data incidents by 50% and ensuring audit-ready pipelines. • Collaborated with Product, Engineering, Finance, and Data Science teams to design schemas, publish analysis-ready datasets, and support use cases such as forecasting, lifecycle modeling, and experimentation. • Mentored 5+ analysts and engineers, building onboarding paths, running SQL/dbt workshops, and establishing review practices that scaled analytics velocity and data literacy across the organization. Core Tools and Skills: SQL, dbt, Snowflake, Airflow, Python, Looker, Tableau, Power BI, S3, GitHub, CI/CD, Data Modeling, Pipeline Architecture, Metric Governance, Analytics Engineering Leadership

• Designed and owned NJOY’s dbt transformation ecosystem in Snowflake, building 300+ models across staging, intermediate, and mart layers to create a unified and reliable analytics foundation for the company. • Consolidated fragmented data from Salesforce, NetSuite, vendor systems, S3 files, telemetry events, and operational feeds into governed, high-quality Snowflake models that supported Product, Finance, Operations, and Executive reporting. • Developed semantic layers and dimensional data marts in Looker, standardizing 80+ KPIs across revenue, customer behavior, quality, device performance, and inventory movement, significantly improving reporting consistency. • Built end-to-end pipelines using Fivetran, Stitch, dbt, Python, and S3 to automate ingestion and transformation, improving data latency and eliminating manual prep work for multiple teams. • Delivered 25+ self-serve dashboards in Looker covering product usage trends, financial performance metrics, customer lifecycle insights, and operational KPIs, reducing ad hoc requests by 50%. • Automated reverse ETL using Census to operationalize curated metrics back into internal systems, enabling real-time prioritization and tighter alignment between analytics and operational teams. • Integrated external syndicated and retail datasets to support forecasting, product planning, and strategic business reviews with leadership. • Produced weekly executive reporting packs using SQL and Looker for VP and C-suite visibility into device performance, revenue trends, cohort movements, and supply chain bottlenecks. • Mentored analysts on SQL modeling, LookML optimization, data validation best practices, and dashboard design, reducing analysis turnaround time by 50% and raising overall modeling standards. Core Tools and Skills: SQL, dbt, Snowflake, Looker, Python, Fivetran, Census, S3, NetSuite, Salesforce, GitHub, CI/CD, Data Modeling, Semantic Layer Design, KPI Frameworks, Pipeline Automation.

• Consolidated fragmented data sources by building SQL + Python pipelines into Redshift, automating ingestion and transformation of customer activity, product performance, and campaign engagement data from 10+ external partners. • Developed 15+ Tableau dashboards to track KPIs like retention, engagement, and ROI, providing self-service access for Marketing, Finance, and Product stakeholders. Reduced reporting turnaround from 2 weeks to same-day insights. • Designed multi-touch attribution models in SQL/Python to connect digital campaigns and customer touchpoints to business outcomes, leading to a 10% improvement in conversion rates. • Defined and standardized KPI frameworks across leadership teams, ensuring consistent reporting and alignment on performance metrics. • Implemented automated data quality checks (SQL + Postman), reducing errors by 50% and eliminating 75% of manual QA overhead. • Enabled new business initiatives by analyzing customer behavior and campaign performance data, providing actionable insights that accelerated go-to-market strategies.

• Analyzed large, imperfect datasets using SQL to validate, preprocess, and standardize incoming partner data, ensuring accuracy and reliability for downstream analytics. • Developed and tested ETL workflows alongside engineering teams, improving data load reliability and supporting new reporting features. • Documented functional and technical requirements in Confluence and Google Suite, strengthening transparency and cross-team alignment. • Partnered with product and engineering teams to validate pipelines and ensure new reports adhered to production-quality standards. Core tools & skills applied: SQL, Data Validation, ETL Workflows, Confluence, Data Quality Testing, Stakeholder Collaboration

• Delivered analytics and reporting solutions for global enterprise clients, leveraging SQL, Tableau, and SAP data sources to support Finance, Sales, and Operations teams. • Built classical and interactive dashboards that provided leaders with visibility into KPIs such as revenue, supply chain performance, and customer behavior. • Optimized and standardized reporting pipelines, improving data refresh times and reducing errors in recurring reports. • Collaborated with cross-functional stakeholders across business units to gather requirements and deliver analytics that supported decision-making at scale. • Conducted performance tuning and process improvements on SQL queries and reporting logic, improving efficiency and reliability of client reporting. Core tools & skills applied: SQL, Tableau, Data Pipelines, KPI Reporting, Requirements Gathering, SAP Data Sources, Business Intelligence

Specialization: Data Management