I'm Pavani Pagada, a data engineer with 8 years of experience in building scalable data models, designing ETL pipelines, and creating interactive dashboards using Microsoft BI tools and cloud services. I thrive on turning complex data into actionable insights and ensuring data security, governance, and reliable delivery across data lakes and analytics platforms. I collaborate with cross-functional teams to drive business decisions and deliver value through Power BI, Snowflake, and cloud integrations. I focus on data governance, security, and robust data pipelines across Azure, AWS, and on-premises environments, delivering insights and storytelling through dashboards and reports, while continuously improving data quality and operational resilience.

Pavani Pagada

I'm Pavani Pagada, a data engineer with 8 years of experience in building scalable data models, designing ETL pipelines, and creating interactive dashboards using Microsoft BI tools and cloud services. I thrive on turning complex data into actionable insights and ensuring data security, governance, and reliable delivery across data lakes and analytics platforms. I collaborate with cross-functional teams to drive business decisions and deliver value through Power BI, Snowflake, and cloud integrations. I focus on data governance, security, and robust data pipelines across Azure, AWS, and on-premises environments, delivering insights and storytelling through dashboards and reports, while continuously improving data quality and operational resilience.

Available to hire

I’m Pavani Pagada, a data engineer with 8 years of experience in building scalable data models, designing ETL pipelines, and creating interactive dashboards using Microsoft BI tools and cloud services. I thrive on turning complex data into actionable insights and ensuring data security, governance, and reliable delivery across data lakes and analytics platforms. I collaborate with cross-functional teams to drive business decisions and deliver value through Power BI, Snowflake, and cloud integrations.

I focus on data governance, security, and robust data pipelines across Azure, AWS, and on-premises environments, delivering insights and storytelling through dashboards and reports, while continuously improving data quality and operational resilience.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
See more

Work Experience

Data Engineer at Hexagon
May 1, 2024 - November 6, 2025
Designed and enforced data protection policies in PostgreSQL; built data lineage and impact assessments for ETL workflows; published and distributed Power BI dashboards with access control; integrated data lake with Azure cataloging tools; developed Snowflake ETL pipelines for multi-source data loading and cleansing; extended Azure Purview metadata with custom enhancements to increase data asset visibility; performed churn prediction and retention modeling using Azure Databricks; delivered SSRS reports with matrix, tabular, and chart layouts; leveraged Power BI natural language queries for conversational reporting; implemented Snowflake encryption, RBAC, and data masking; automated data extraction using Python; monitored and optimized Azure Data Factory pipelines; maintained disaster recovery for Azure Databricks; implemented Git-based versioning and SSAS cube validation; synchronized Azure Synapse key vaults with on-premises systems; orchestrated OLTP to OLAP ETL flows; established da
BI and Cloud Developer at ONxpress Operations Inc.
May 1, 2024 - May 1, 2024
Built and tuned SQL queries and stored procedures for Power BI/Tableau reporting; implemented data masking policies in AWS Redshift; enabled secure collaboration in AWS Glue and Databricks; used anomaly detection and trend analysis in Power BI/Tableau; administered SQL Server data distribution; configured AWS Glue Data Catalog to track data lineage; provided guidance on SSIS integration; implemented cryptographic key rotation in AWS KMS and supported Snowflake data masking; documented SSAS mappings and lineage; enabled drill-through and parameterized reporting in Power BI/Tableau; set up MongoDB backup/recovery; integrated OAuth/JWT in Python apps; developed metadata management and data lineage in BI tools and AWS; standardized report rendering/export; integrated data lake with AWS S3 and Data Exchange; built parameterized ETL pipelines in AWS Glue/Step Functions; established governance and access controls.
BI Engineer at Mphasis – Bengaluru, IN
November 1, 2021 - November 1, 2021
Optimized data deduplication and ETL workflows for OLAP-OLTP integrations; contributed to transfer learning in speech recognition; troubleshot Azure Data Lake performance; developed PostgreSQL triggers; leveraged Azure Purview for data lineage; configured security roles in SSAS; authored SQL in SSIS; supported BI deployments and user access security in SSRS; created SQL migration scripts; used Git reflog for recovery; integrated Power BI with Excel/Teams/SharePoint; collaborated with data scientists on Azure Databricks; deployed Redis cache for performance; created and maintained SSAS/SSIS documentation and data models; coordinated multi-application data integration and governance; monitored ADF data flow profiling; planned capacity for growing workloads; adopted SSIS enhancements and SSAS best practices.
Jr MSBI Engineer at Bajaj Allianz General Insurance, Pune, IN
June 1, 2019 - June 1, 2019
SQL Server encryption and masking; standardized BI reporting templates; established data archiving and purging; applied SCD techniques in data warehouses; implemented report parameter validation in SSRS; configured SSAS tabular roles; enhanced SSIS logging/monitoring; performed data analysis and modeling; kept SSRS features up-to-date; managed SSIS deployments with version control; built event-driven SSIS workflows.
BI and Cloud Developer at ONxpress Operations Inc.
January 1, 2022 - May 1, 2024
Built and optimized SQL queries and ETL pipelines for Power BI/Tableau reporting, implemented data masking policies, configured AWS Glue and Databricks access controls, and established data cataloging and governance across multi-cloud sources.
BI Engineer at Mphasis
June 1, 2019 - November 1, 2021
Designed and implemented OLAP/OLTP data integration workflows, mentored teams on SSIS/SSAS, configured governance via Azure Purview, and supported BI applications with robust ETL and data modeling.
Jr MSBI Engineer at Bajaj Allianz General Insurance
September 1, 2017 - June 1, 2019
Implemented SQL Server encryption, masking, and archiving; developed SSIS/SSRS/SSAS components and data models; collaborated with teams to enable secure and scalable BI reporting.

Education

Add your educational history here.

Qualifications

Bachelor of Technology
January 11, 2030 - November 6, 2025
Microsoft Azure Fundamentals (AZ-900)
January 11, 2030 - November 6, 2025
Bachelor of Technology
January 11, 2030 - January 27, 2026
Microsoft Azure Fundamentals (AZ-900)
January 11, 2030 - January 27, 2026

Industry Experience

Software & Internet, Professional Services, Computers & Electronics