Experienced Azure Data Engineer Needed -- 2

About the project

Professional Summary Results-driven Azure Data Engineer and Power BI Developer with 13+ years of experience in Business Intelligence, Data Warehousing, Azure Data Platform, Microsoft Fabric, Power BI, SQL Server, SSIS, and Azure Synapse Analytics. Experienced in designing scalable ETL pipelines, developing interactive Power BI dashboards, migrating on-premises solutions to Azure, and delivering enterprise reporting solutions. Strong expertise in SQL performance tuning, Azure Data Factory, Synapse Pipelines, Microsoft Fabric, Git, Azure DevOps, and data modeling. Adept at working with global clients in Agile environments and delivering freelance consulting assignments independently. Key Skills • Cloud Platforms: Azure Data Factory, Azure Synapse Analytics, Azure SQL, Microsoft Fabric • Databases: SQL Server, Azure SQL Database, PostgreSQL • Programming: T-SQL, DAX, Python (basic for data analysis) • BI Tools: Power BI (DAX, Power Query), SSRS, SSIS, SSAS • Data Orchestration Modeling: Dagster, dbt (data build tool) • Data Modeling: Star/Snowflake schema, Tabular Model • Visualization: Dashboards, KPIs, Drill-down reports • Others: Git, Agile methodology, DevOps pipelines for BI deployment Professional Experience Senior Azure Data Engineer | Leading IT services company (06/2022 – Present) Responsibilities • Developed end-to-end ETL pipelines. • Integrated data from disparate sources (SQL, flat files, APIs) into Azure Synapse and built dataflows in Microsoft Fabric. • Automated ETL processes using SSIS and Azure Data Factory, reducing manual efforts by 40%. • Designed and deployed tabular models in SSAS, improving data query performance by 60%. • Developed interactive dashboards and reports using Power BI, optimizing key business metrics. • Coordinated with cross-functional teams to deliver BI solutions under Agile methodology. BI Developer | Global IT Services (2017 to 2022) • Migrated legacy ETL packages to Azure Data Factory, enhancing scalability and security. • Worked with various Control Flow items (For Loop, For Each loop, Sequence, Data flow Task, Execute SQL task, File System task, Script task) and Data Flow items (Flat File and OLEDB source and Destination, Derived column, Sort, Lookup, Conditional Split, Multicast, etc.). • Loaded data into various tables through incremental SCD approaches. • I worked on drill-down and drill-through on SSRS reports. • Attended daily and weekly status meetings. • Created stored procedures and SQL queries to pull data into the Power Pivot model. • Wrote DAX expressions and functions as per the business need. • Conducted knowledge transfer and end-user training sessions on Power BI report usage. BI Developer | IT consulting Company (20144 – 2019) • Migrated legacy ETL packages to Azure Data Factory, enhancing scalability and security. • Implemented Row-Level Security (RLS) for role-based data access in Power BI. • Conducted knowledge transfer and end-user training sessions on Power BI report usage. • Built custom SSRS reports and dashboards to support financial and operational analysis. Education Master's in Computer Science from Kakatiya University. Certifications • Microsoft Certified: Fabric Analytics Engineer Associate(DP-600) • Microsoft Certified: Power BI Data Analyst Associate Projects • Sales Performance Dashboard: Developed a Power BI dashboard for a retail chain to track sales, returns, and regional performance using Azure Synapse and DAX.Azure Data Lake + Microsoft Fabric Integration: Built a prototype using Microsoft Fabric Lakehouse to enable real-time analytics for marketing campaign data. FREELANCE SERVICES • Power BI Dashboard Development • Azure Data Factory Development • Azure Synapse Analytics • Microsoft Fabric Implementation • SQL Performance Tuning • ETL Development • Data Warehouse Design • Report Migration • Production Support • Data Visualization • Power BI Administration ACHIEVEMENTS • Successfully delivered enterprise BI solutions for global clients. • Developed scalable Azure data pipelines processing millions of records. • Built executive dashboards with interactive KPIs and drill-through analysis. • Optimized SQL and Power BI solutions to reduce report execution times significantly.

Skills required