About this role
About us 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:
• 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 #LI-NP1
• 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