Power BI Lead

About the position

The role involves architecting, designing, and implementing scalable and high-performance Power BI solutions. The candidate will be responsible for developing Power BI solutions with Big Query on Google Cloud Platform, designing and developing data models, dashboards, reports, and visualizations to support business decision-making. The position requires optimizing Power BI performance by applying best practices in DAX, Power Query, and data modeling, as well as integrating Power BI with various data sources, including GBQ, Data Lakes, APIs, and other third-party sources. Additionally, the candidate will develop and implement row-level security and access control mechanisms in Power BI, work closely with stakeholders, business analysts, and data engineers to understand data needs, and define and enforce Power BI governance, including workspace management, data lineage, and documentation. The role also includes automating and optimizing Power BI deployments using DevOps practices (CI/CD pipelines) and staying updated on the latest Power BI and Microsoft data ecosystem advancements.

Responsibilities

• Design & develop end-to-end Power BI solutions, including data modeling, transformation, and report visualization.
• Define best practices for data ingestion, transformation, and visualization.
• Establish data security, governance, and compliance standards.
• Create optimized data models for performance efficiency.
• Connect Power BI with multiple data sources (GBQ, Azure, APIs, Excel, etc.).
• Implement DAX (Data Analysis Expressions) and Power Query for complex calculations.
• Optimize Power BI semantic models, reports, and dashboards for speed and efficiency.
• Implement governance & security policies for Power BI workspaces, datasets, and reports.
• Work with business analysts, data engineers, and developers to gather requirements.
• Collaborate with IT teams to align Power BI solutions with enterprise architecture.
• Automate report deployment using DevOps pipelines.
• Ensure scalability and maintenance of Power BI services in the cloud (Azure Power BI Service).
• Monitor performance and troubleshoot issues in production environments.
• Stay updated with the latest Power BI features and trends.
• Evaluate and integrate AI-powered analytics, custom visuals, and advanced analytics.
• Drive continuous improvement of BI solutions and data visualization techniques.

Requirements

• Must have 3 to 5 years of experience in architect roles.
• Extensive experience in implementing Power BI governance, security, and performance tuning.
• Ability to work in a team environment and possess client interfacing skills.
• Strong analytical and communication skills.