Microsoft Power BI Senior Technical Specialist

Job description

We are seeking a highly experienced Power BI Technical Architect / Microsoft Fabric Architect to lead the design, modernization, and delivery of enterprise-grade analytics solutions. This role requires strong hands-on expertise in Power BI, Microsoft Fabric, semantic modeling, DAX, SQL, data architecture, performance optimization, and governance. The ideal candidate will act as a technical authority who can translate business requirements into scalable BI architecture, define best practices, guide development teams, and ensure analytics platforms are secure, reliable, performant, and aligned with enterprise data strategy. Key Responsibilities Architecture & Solution Design Own end-to-end architecture for Power BI and Microsoft Fabric-based analytics solutions across enterprise environments. Design scalable semantic models using dimensional modeling, star schema, reusable datasets, calculation groups, and enterprise-grade modeling standards. Define architecture blueprints, HLDs, LLDs, data model designs, workspace structures, deployment patterns, and governance frameworks. Evaluate and recommend the right storage and connectivity patterns, including Import, DirectQuery, Direct Lake, Composite Models, Aggregations, and incremental refresh. Lead Microsoft Fabric adoption across Lakehouse, Warehouse, OneLake, Direct Lake, Dataflows Gen2, Pipelines, Notebooks, and Power BI semantic models. Ensure all BI solutions meet enterprise standards for performance, scalability, security, data quality, maintainability, and compliance. Power BI, Fabric & Data Engineering Expertise Build and optimize complex Power BI reports, dashboards, paginated reports, semantic models, DAX measures, Power Query transformations, and dataflows. Develop efficient DAX calculations, optimize model performance, troubleshoot refresh issues, and improve report responsiveness using best practice tuning techniques. Work with SQL databases, data warehouses, lake houses, APIs, cloud data platforms, and enterprise data sources to deliver reliable analytics solutions. Design medallion-style analytical layers and curated reporting datasets for downstream consumption by Power BI and business users. Implement security concepts including Row-Level Security, Object-Level Security, workspace access strategy, sensitivity labels, and data governance controls. Leadership, Governance & Delivery Partner with business stakeholders, data engineers, application teams, and leadership to convert business needs into robust analytical solutions. Mentor developers and analysts on Power BI, DAX, modeling, Fabric capabilities, performance optimization, and governance best practices. Skill Requirements 10+ years of experience in Business Intelligence, Data Analytics, Data Warehousing, or Data Platform delivery, with strong enterprise implementation exposure. 7+ years of hands-on Power BI experience, including semantic modeling, DAX, Power Query, Power BI Service, deployment pipelines, and performance tuning. Practical experience with Microsoft Fabric, including Lakehouse, Warehouse, OneLake, Direct Lake, Dataflows Gen2, Pipelines, and Fabric workspace design. Strong SQL skills with experience in relational databases, data warehouses, lakehouse architecture, ETL/ELT pipelines, and large-volume data environments. Strong understanding of governance, security, access management, data lineage, quality controls, and enterprise BI lifecycle management. Preferred / Advanced Skills: Exposure to Azure Data Factory, Synapse, Databricks, Spark, Python, REST APIs, Power BI automation, Power Apps, and Power Automate integration. Experience with Power BI Copilot, Microsoft Fabric Copilot, GenAI-assisted analytics, responsible AI practices, and automation-led development acceleration Other Requirements Preferred Certifications • Microsoft Certified: Power BI Data Analyst (PL 300) • Microsoft Certified: Azure Data Engineer / Solutions Architect • Microsoft Fabric certifications (preferred) Apply now Information at a Glance Why HCLTech? At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first. HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion. Disclaimer Privacy Statement Terms of use Sitemap Raise a Grievance We use cookies on our site. Please read more about cookies policy here. Opens in a new tab. Opens in a new tab. Opens in a new tab. Opens in a new tab. Opens in a new tab. Opens in a new tab. Copyright © 2026 HCL Technologies Limited Cookie Consent Manager When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. Because we respect your right to privacy, you can choose not to allow some types of cookies. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer. Required Cookies These cookies are required to use this website and can't be turned off. Required Cookies Required Cookies Provider Description Enabled SAP as service provider We use the following session cookies, which are all required to enable the website to function: "route" is used for session stickiness "careerSiteCompanyId" is used to send the request to the correct data center "JSESSIONID" is placed on the visitor's device during the session so the server can identify the visitor "Load balancer cookie" (actual cookie name may vary) prevents a visitor from bouncing from one instance to another Cookies from provider SAPasserviceprovider are required and cannot be turned off Functional Cookies These cookies provide a better customer experience on this site, such as by remembering your login details, optimizing video performance, or providing us with information about how our site is used. You may freely choose to accept or decline these cookies at any time. Note that certain functionalities that these third-parties make available may be impacted if you do not accept these cookies. Consent to all Functional Cookies Functional Cookies Provider Description Enabled Vimeo Vimeo is a video hosting, sharing, and services platform focused on the delivery of video. Opting out of Vimeo cookies will disable your ability to watch or interact with Vimeo videos. Cookie Policy Privacy Policy Terms and Conditions Consent to cookies from provider Vimeo YouTube YouTube is a video-sharing service where users can create their own profile, upload videos, watch, like, and comment on videos. Opting out of YouTube cookies will disable your ability to watch or interact with YouTube videos. Cookie Policy Privacy Policy Terms and Conditions Consent to cookies from provider YouTube Advertising Cookies These cookies serve ads that are relevant to your interests. You may freely choose to accept or decline these cookies at any time. Note that certain functionality that these third parties make available may be impacted if you do not accept these cookies. Consent to all Advertising Cookies Advertising Cookies Provider Description Enabled Google Analytics Google Analytics is a web analytics service offered by Google that tracks and reports website traffic. Cookie Information Privacy Policy Terms and Conditions Consent to cookies from provider GoogleAnalytics Google Tag Manager Google Tag Manager is a tag management system for conversion tracking, site analytics, remarketing, and more. Privacy Policy Terms and Conditions Consent to cookies from p