Pavan Kumar

Results-driven Azure and BI Data Engineer with over 5 years of experience building scalable, efficient data solutions across insurance, finance, and manufacturing domains. Hands-on expertise in designing and orchestrating ELT pipelines using Azure Data Factory, Databricks, and dbt, with Snowflake as the primary data warehouse. Proficient in SQL, Python, and cloud-native tools to implement modular data transformations, incremental models, and CI/CD workflows. Adept at integrating machine learning models for real-time analytics, automating infrastructure with Terraform, and delivering BI insights via Power BI and Tableau. Strong focus on data governance, security (RBAC, masking), and optimization to support business-critical decisions.
 

Data Engineer

Wawanesa Insurance, Toronto
Aug 2023 – Present

Developed and optimized scalable data pipelines using Azure Data Factory, Databricks, and Snowflake, improving processing speed by 30%.

Built and maintained modular dbt models for finance and claims analytics, reducing data defects by 35%.

Integrated REST APIs and external data sources using ADF to automate third-party data ingestion.

Deployed CI/CD pipelines using Terraform and Azure DevOps, ensuring consistent and secure infrastructure deployments.

Collaborated with business stakeholders to translate requirements into actionable SQL/Python-based analytics workflows.

Set up monitoring and alerting systems with Azure Monitor and Prometheus, reducing incident resolution time by 50%.

Azure & BI Engineer

Intact, Toronto
Jun 2022 – Jul 2023

Created ETL workflows with SSIS, ADF, and Python, supporting SCD Type 1/2 logic for clean historical tracking.

Migrated legacy SSIS logic to modular, dbt-style SQL models, improving maintainability and performance.

Built and published Power BI dashboards integrated with Snowflake and Synapse for real-time business reporting.

Engineered pipelines to ingest and clean third-party marketing data for campaign effectiveness analysis.

Version-controlled all data transformation scripts and models using Git, enabling reproducible workflows.

Modeled financial datasets in Snowflake, reducing query load times and improving reporting efficiency.

ETL Developer

AB InBev, India
Jun 2018 – Aug 2020

Developed and maintained SSIS and ADF pipelines to process data from SQL, Blob Storage, and APIs.

Automated ETL workflows using Python, improving data consistency and reducing manual effort.

Created metadata-driven ETL frameworks, allowing dynamic ingestion across multiple source systems.

Optimized T-SQL queries and indexing strategies to reduce ETL job runtime by 35%.

Built Power BI dashboards to visualize supply chain metrics and business KPIs.

Implemented role-based access controls and data monitoring using Azure tools, ensuring compliance with security policies.

Postgraduate Certificate in Business Insights & Analytics
Humber College, Toronto — 2022
Focused on data analytics, business intelligence, and applied statistics using tools like Power BI, SQL, and Python.

Bachelor of Technology in Computer Science
Bhagwant University, Rajasthan — 2018
Provided a strong foundation in software development, databases, and data structures, supporting a career in data engineering.