Microsoft Power BI Senior Technical Specialist
Technology, Data & Digital · Data, AI & Analytics · Business Intelligence · Data Engineering
In short
Highly experienced Power BI/Microsoft Fabric Technical Architect needed to lead the design, modernization, and delivery of enterprise analytics solutions. Responsibilities include defining architecture, developing semantic models, optimizing performance, and mentoring teams. Requires 10+ years in BI/Data Analytics with 7+ years of hands-on Power BI experience.
Responsibilities
- Own end-to-end architecture for Power BI and Microsoft Fabric-based analytics solutions.
- 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 storage and connectivity patterns (Import, DirectQuery, Direct Lake, Composite Models, Aggregations, incremental refresh).
- Lead Microsoft Fabric adoption across Lakehouse, Warehouse, OneLake, Direct Lake, Dataflows Gen2, Pipelines, Notebooks, and Power BI semantic models.
- Ensure BI solutions meet enterprise standards for performance, scalability, security, data quality, maintainability, and compliance.
- Build and optimize 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.
- Work with SQL databases, data warehouses, lake houses, APIs, cloud data platforms, and enterprise data sources.
- Design medallion-style analytical layers and curated reporting datasets.
- Implement security concepts including Row-Level Security, Object-Level Security, workspace access strategy, sensitivity labels, and data governance controls.
- Partner with business stakeholders, data engineers, application teams, and leadership to convert business needs into solutions.
- Mentor developers and analysts on Power BI, DAX, modeling, Fabric capabilities, performance optimization, and governance best practices.
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.
Desired Qualifications
- 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.
- Microsoft Certified: Power BI Data Analyst (PL 300)
- Microsoft Certified: Azure Data Engineer / Solutions Architect
- Microsoft Fabric certifications (preferred)
Benefits
- Supercharge your potential at HCLTech.
- Find your career at HCLTech.
- Find your spark at HCLTech.
- A place that knows that helping its customers stay on top starts by putting its people first.
- Be part of a global technology company with over 223,000 people across 60 countries.
- Deliver industry-leading capabilities centered around digital, engineering, cloud, and AI.
- Work with clients across all major verticals including Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services.
#Power BI#Microsoft Fabric#Data Architecture#DAX#SQL#BI