Assistant Manager_MS Fabric

About Us

JOB DESCRIPTION

KPMG is a leading professional services firm comprising over 174,000 professionals who work together to deliver value in more than 155 countries through in-depth industry insights in Audit, Tax & Advisory. The firm recorded more than USD 24.4 billion in revenues in 2015.

The position in discussion is with the Tax –Technology - Global Trade and Customs - Managed Services team at KPMG Global Services (KGS) which is an integral part of the firm's strategy to enhance innovation, build scalability, and improve profitability, globally.

Responsibilities

• Responsibilities :
• We are recruiting for Assistant Manager profiles with the following responsibilities:
• Build and orchestrate data ingestion workflows using Fabric Data Factory and Pipelines.
• Develop ETL/ELT processes using Dataflows, Pipelines, SQL, and Notebook transformations.
• Implement advanced data transformations using Fabric Notebooks (Python / PySpark).
• Build and optimize Fabric Warehouses, SQL endpoints, and data models for analytics consumption.
• Integrate Fabric datasets with Power BI using Direct Lake, Import, and DirectQuery.
• Schedule, monitor, and optimize pipeline performance and compute consumption.
• Ensure adherence to OneLake governance, security, lineage tracking, and workspace best practices.
• Build interactive dashboards, reports, and semantic models aligned with business needs.
• Create optimized DAX calculations, measures, and relationships.
• Implement row-level security, incremental refresh, and data model optimizations.
• Collaborate with UI/UX and business teams to design visually compelling reports.
• Good Analytical and Problem-solving skills
• Able to manage offshore by providing technical guidance and working with onsite to understand business problems and provide quality solutions and architecture
  
  

#KGS

Qualifications

• Core Skills (Must Have)
• Microsoft Fabric: Lakehouse, Data Factory, Warehouse, Pipelines, Notebooks, OneLake
• Python / PySpark, SQL
• Power BI: DAX, modeling, visualizations, Direct Lake
• Excel: Advanced formulas, Power Query, data manipulation
• Good-to-Have Skills
• SharePoint (integration, Lists, content access)
• Power Platform:
• Power Apps – form apps, connectors
• Power Automate – workflow automation
• Prior knowledge of Tax Compliance and Tax Systems