Microsoft Power BI Senior Technical Specialist (IN)
HCLTech
HCLTech
Seeking a seasoned Power BI Technical Architect or Microsoft Fabric Architect to spearhead the design, modernization, and deployment of enterprise-grade analytics solutions. This role demands profound hands-on experience in Power BI, Microsoft Fabric, semantic modeling, DAX, SQL, data architecture, performance optimization, and governance.
The ideal candidate will serve as a technical leader, translating business needs into scalable BI architectures, establishing best practices, guiding development teams, and ensuring analytics platforms are secure, reliable, performant, and aligned with enterprise data strategy.
Spearhead the end-to-end architecture for Power BI and Microsoft Fabric-based analytics solutions within enterprise settings. Design scalable semantic models using dimensional modeling, star schema, reusable datasets, and enterprise-grade modeling standards. Develop architecture blueprints, HLDs, LLDs, data model designs, workspace structures, deployment patterns, and governance frameworks. Evaluate and recommend optimal 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 adhere to enterprise standards for performance, scalability, security, data quality, maintainability, and compliance.
Possess 10+ years of experience in Business Intelligence, Data Analytics, Data Warehousing, or Data Platform delivery, with extensive enterprise implementation experience. Demonstrate 7+ years of hands-on Power BI expertise, encompassing semantic modeling, DAX, Power Query, Power BI Service, deployment pipelines, and performance tuning. Exhibit practical experience with Microsoft Fabric, including Lakehouse, Warehouse, OneLake, Direct Lake, Dataflows Gen2, Pipelines, and Fabric workspace design. Showcase strong SQL skills with experience in relational databases, data warehouses, lakehouse architecture, ETL/ELT pipelines, and large-volume data environments. Possess a deep understanding of governance, security, access management, data lineage, quality controls, and enterprise BI lifecycle management. Preferred: Exposure to Azure Data Factory, Synapse, Databricks, Spark, Python, REST APIs, Power BI automation, Power Apps, Power Automate, Power BI Copilot, Microsoft Fabric Copilot, GenAI-assisted analytics, and responsible AI practices.
HCLTech
IT Consulting