Lead Power BI Developer

Job Overview

Position: Lead Power BI Developer

Location: Torrance, CA
*** Day 1 Onsite***

Duration: 1 Years

Phone & Video

Client: HCL

Immediate Interview

The Power BI professional will design, develop, and deliver scalable Business Intelligence solutions using Microsoft Power BI. The role involves turning raw data into meaningful insights through interactive dashboards, reports, data models, and analytics solutions.

The position requires strong analytical skills, hands on technical expertise, and the ability to interact with business stakeholders to translate requirements into BI solutions.

• Design, develop, test, and deploy Power BI dashboards, reports, and data models based on business requirements.
• Create DAX calculations, calculated columns, and measures to support complex analytics.
• Build tabular/multidimensional models following data warehouse standards.
• Develop and maintain data pipelines, data transformations, and cleansing routines for analytics readiness.

• Connect Power BI to various data sources such as SQL Server, Excel, cloud services, APIs, Snowflake, ADF, Databricks, and other enterprise systems.
• Perform data extraction, transformation, and loading (ETL) for high quality reporting datasets.
• Implement row-level security, performance tuning, and optimization of datasets and reports.

• Collaborate with business teams, SMEs, and leadership to understand BI needs.
• Gather requirements and convert them into technical BI specifications and architecture.
• Provide regular demos, presentations, and deliver insights that support operational and strategic decisions.

• Publish reports to Power BI Service, configure gateways, schedule refreshes, and manage work spaces.
• Support governance, documentation, metadata management, and version control.

• From enterprise JDs that include Power BI + Power Apps + automation.
• Build Power Apps (Canvas/Model-driven) apps and integrate with BI.
• Use Power Automate for workflow automation.
• Write automation scripts using Python/VBA as required for data prep or internal tooling.

• Strong experience with Microsoft Power BI (Desktop + Service).
• Proficiency in DAX, Power Query (M), data modeling, and visualization best practices.
• Strong SQL experience; comfortable with joins, stored procedures, views.
• Experience connecting to enterprise data sources (SQL, ADF, Databricks, Snowflake, Excel, APIs).
• Solid understanding of data warehousing concepts and BI architecture.
• Ability to analyze complex datasets and drive business insights.
• Strong communication and stakeholder management skills.

• Experience with Power Apps, Power Automate, and Microsoft Dataverse.
• Knowledge of Azure services (ADF, Databricks, Synapse), AWS or cloud data platforms.
• Python scripting, VBA automation, Excel modeling.
• Experience in Agile, Dev Ops, CI/CD for analytics solutions.
• Exposure to embedding Power BI into applications via APIs.