Microsoft Power BI Technical Lead (IN)
HCLTech
HCLTech
Join us as a Senior Power BI Developer and Data Engineer specializing in Web Analytics. This role is pivotal in designing and implementing enterprise-level Power BI solutions. You will focus on transforming raw data into actionable insights, driving business decisions through comprehensive reporting and self-service analytics.
Your expertise will be crucial in building robust data pipelines and optimizing the performance of our analytical tools. We are seeking a highly skilled individual with a proven track record in Power BI development and Azure Data Engineering to elevate our data capabilities.
This is an onsite opportunity in India, offering a challenging and rewarding environment for a dedicated professional.
Design and develop sophisticated Power BI dashboards, reports, and scorecards, alongside self-service analytics solutions. Craft advanced DAX calculations, Power Query transformations, semantic models, and reusable datasets. Construct and maintain scalable ETL/ELT pipelines utilizing Azure Data Services. Seamlessly integrate diverse data sources including web, marketing, telemetry, application, and enterprise data.
Develop in-depth analytics for web traffic, customer acquisition, engagement metrics, MAU, CTA performance, funnels, conversions, and content effectiveness. Continuously optimize Power BI reports, datasets, queries, refresh processes, and overall reporting performance. Implement robust data validation, monitoring, reconciliation, automation, and failure handling mechanisms. Proactively troubleshoot production data pipelines, report refresh failures, telemetry gaps, and data quality issues. Effectively translate complex business requirements into precise KPIs, data solutions, reports, and actionable insights.
A strong foundation in hands-on Power BI development is essential, including advanced proficiency in DAX, Power Query/M, semantic modeling, and dataset development. Expertise in Power BI Service features such as workspaces, gateways, refresh, security, deployment, and performance optimization is required. Solid SQL development skills are necessary, alongside experience with Azure Data Factory, Azure SQL, Azure Data Lake Storage, and Azure Synapse Analytics.
Familiarity with Kusto Query Language (KQL) or Azure Data Explorer is important, as is experience with Cosmos DB or similar telemetry platforms. Knowledge of Azure Analysis Services/SSAS, Azure Functions, Logic Apps, and Azure DevOps/CI/CD pipelines is expected. Understanding of Microsoft Fabric and Application Insights/Azure Monitor is beneficial.
Proficiency in ETL/ELT pipeline development and orchestration, data transformation, validation, reconciliation, and monitoring is key. Experience integrating various data sources (API, file, telemetry, enterprise) is crucial. A strong grasp of web and digital analytics concepts, including clickstream, engagement, conversion, and user-behavior reporting, is vital. Proven experience in production support and troubleshooting data issues is a must.
HCLTech
IT Consulting