Microsoft Power BI Technical Lead (IN)

HCLTech

6+ yrs India Full Time Work from office
HCLTech logo
Posted : today
Actively hiring

Job description

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.

Responsibilities

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.

Qualifications

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.

Essential Skills

Power BIDAXPower QuerySemantic ModelingDataset DevelopmentPower BI ServiceWorkspacesGatewaysRefreshSecurityDeploymentPerformance OptimizationSQLAzure Data FactoryAzure SQLAzure Data Lake StorageAzure Synapse AnalyticsKusto Query LanguageAzure Data ExplorerCosmos DBTelemetry PlatformsAzure Analysis ServicesSSASAzure FunctionsLogic AppsAzure DevOpsCI/CDMicrosoft FabricApplication InsightsAzure MonitorETL/ELTData TransformationData ValidationData ReconciliationData MonitoringAPI IntegrationFile IntegrationTelemetry IntegrationEnterprise Data Source IntegrationWeb AnalyticsDigital AnalyticsClickstream AnalysisEngagement AnalysisConversion AnalysisUser Behavior ReportingProduction SupportTroubleshooting

Good to Have

PythonAdobe AnalyticsDynamics 365Power PlatformDataverseDatabricksSparkPower AutomateAnomaly DetectionAdvanced Telemetry AnalysisData Quality Analysis

Highlights

  • Actively hiring

More Details

RoleMicrosoft Power BI Technical Lead (IN)
Employment TypeFull Time, Work from office

About the Company

HCLTech logo

HCLTech

IT Consulting

Microsoft Power BI Technical Lead (IN) at HCLTech | SkillMX | SkillMX