Microsoft Fabric and Power BI Lead

About Our Company

Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 20 years. We are part of Ameriprise Financial Inc., a US financial planning company headquartered in Minneapolis with a global presence and diversified financial services leader with more than $1.5 trillion in assets under management, administration and advisement as of year-end 2024. The firm’s focus areas include Asset Management and Advice, Retirement Planning and Insurance Protection.

Be part of an inclusive, collaborative culture that rewards you for your contributions, and work with other talented individuals who share your passion for doing great work. You’ll also have plenty of opportunities to make your mark at the office and a difference in your community. So, if you're talented, driven and want to work for a strong, ethical company that cares, take the next step and create a career at Ameriprise India LLP.

Job Description

The Power BI and Microsoft Fabric Engineer is a hands-on technical role responsible for Power BI development, administration, platform support, performance optimization, governance, and Microsoft Fabric enablement. The role supports enterprise reporting and data-platform operations, troubleshoots complex technical issues, establishes platform standards, and collaborates with technical teams and business stakeholders to deliver secure, scalable, and supportable Power BI and Fabric solutionsKey Responsibilities

• -----------------------
• Develop, enhance, troubleshoot, and optimize Power BI reports, semantic models, Dataflows, and Paginated Reports.
• Design and support solutions using DAX, Power Query/M, data modeling, Import, DirectQuery, and Composite Models.
• Analyze and resolve performance issues involving reports, visuals, DAX, semantic models, refreshes, data sources, and capacity utilization.
• Use Performance Analyzer, DAX Studio, and Tabular Editor to assess and improve solution performance.
• Administer and support the enterprise Power BI Service, including workspaces, apps, semantic models, dataflows, gateways, refreshes, security, and access.
• Monitor Power BI Premium and Microsoft Fabric capacity utilization, workload performance, and operational health.
• Troubleshoot gateway, connectivity, refresh, capacity, deployment, and service-related issues.
• Support Power BI REST APIs, deployment processes, automation, and operational improvements.
• Provide technical guidance, design recommendations, and code or model reviews to Power BI developers.
• Support Power BI governance, access controls, compliance, audit, risk-management, and technical-review activities.
• Establish and maintain standards for workspace design, security, naming, content lifecycle, access, capacity usage, and certified or promoted content.
• Identify technical risks, governance gaps, and technical debt, and recommend appropriate remediation.
• Maintain platform documentation, operational standards, runbooks, and knowledge articles.
• Support Microsoft Fabric architecture and workloads, including OneLake, Lakehouse, Warehouse, Data Factory/Pipelines, Dataflows Gen2, Notebooks, Semantic Models, Fabric Capacity, and Monitoring Hub.
• Support Microsoft Fabric readiness, onboarding, migration, architecture, security, monitoring, and production implementation.
• Establish sustainable support and operating processes for Microsoft Fabric as organizational adoption increases.
• Provide L2/L3 production support and own incidents from investigation through resolution, including root-cause analysis for recurring issues.
• Coordinate with database, cloud, network, security, infrastructure, Microsoft, and vendor-support teams to resolve platform issues.
• Communicate incidents, risks, dependencies, and technical recommendations clearly to technical teams, business users, and other stakeholders.
• Promote Power BI and Microsoft Fabric best practices, supportability, documentation, and knowledge sharing.

Required Technical Skills

• Power BI Service and Power BI Desktop
• Microsoft Fabric architecture and platform concepts
• OneLake, Lakehouse, Warehouse, and Semantic Models
• Data Factory/Pipelines, Dataflows Gen2, and Notebooks
• Power BI administration and enterprise platform support
• Power BI Premium and Microsoft Fabric Capacity
• DAX, Power Query/M, and data modeling
• Import, DirectQuery, and Composite Models
• Power BI gateways, Dataflows, and Paginated Reports
• Workspaces, apps, semantic models, security, and access management
• Power BI REST APIs and deployment processes
• Microsoft Fabric monitoring, governance, security, and capacity management
• Performance Analyzer, DAX Studio, and Tabular Editor
• Report, semantic model, refresh, and capacity performance optimization

Preferred Skills

• PowerShell or Python and SQL Queries
• Microsoft Azure or Azure Data Factory
• Git and CI/CD
• Deployment Pipelines
• ServiceNow or a similar IT service-management platform

Experience and Qualifications

• Seven or more years of experience in Power BI, data analytics, or data-platform engineering.
• Proven experience in Power BI administration, development, troubleshooting, and production support.
• Strong experience in report and semantic-model performance optimization.
• Hands-on experience with Paginated Reports, Dataflows, and enterprise gateways.
• Working knowledge of Microsoft Fabric architecture and platform workloads.
• Experience with enterprise governance, access management, risk, compliance, or similar platform controls.
• Experience working within a structured production-support or IT service-management environment is preferred.

Key Competencies

• Strong analytical, diagnostic, and troubleshooting skills.
• Hands-on technical approach across both development and platform administration.
• Strong ownership and incident-management capabilities.
• Effective communication and stakeholder-manag