Jun 2024 – Present · 1 yr 11 mos · Gurugram · On-site

• Data Engineer | Azure Analytics & Automation
• Tech Stack: Azure Data Factory, Azure DevOps, Power BI, Python, SQL, DAX, SSMS, Jira
• Designed and delivered automated Power BI dashboards for QA and workforce analytics using SQL and DAX, enabling real-time visibility for leadership and delivery teams.
• Built and automated data pipelines integrating Azure DevOps, Jira, and SQL Server using Python and REST APIs, significantly reducing manual reporting and operational effort.
• Implemented end-to-end data ingestion from on-premises SSMS into Azure Data Factory following a Bronze–Silver–Gold architecture to support scalable analytics and reporting.
• Performed data transformations, validation, and quality checks using mapping sheets and business rules to ensure analytics-ready, high-quality datasets.
• Published curated Gold-layer datasets to Power BI, supporting business KPIs related to utilization, sprint tracking, and defect analysis across multiple teams.
• Monitored and maintained daily production pipelines, handling failures, reruns, and automated email notifications to ensure data reliability and SLA compliance.
• Collaborated with agile delivery and QA teams to replace manual Excel-based reports with automated, cloud-based analytics solutions