Lead Consultant Power BI - Remote / WFH

Position : Lead Consultant Power BI | Remote

Work Arrangement : Remote

Schedule : Midshift (5 p.m. to 2 a.m.)

Overview :

Power BI's core strength lies in having high-quality data. We are seeking Lead Consultants who specialize in Power BI with a strong focus on data management. Candidates should possess advanced expertise in Power BI and its data components, including PowerQuery / M, DAX, and dimensional modeling, along with experience in basic report design. Familiarity with traditional SQL Server (data warehouse design, SSIS, SSRS) and DirectQuery is advantageous. Additionally, you should understand Power BI licensing models and be capable of working with clients to help them select the most suitable licensing options for their needs. Experience with Databricks in developing, implementing, and optimizing data pipelines and workflows is required. Strong communication skills are essential for engaging regularly with clients, their teams, and technical specialists such as database developers and software engineers. Your excellent analytical, problem-solving abilities, and understanding of both technical and business aspects of business intelligence, along with a commitment to staying current with Power BI updates, will make you a strong candidate. If you are passionate about Power BI technologies with a data-centric approach and enjoy working with customers, you may be the perfect fit for this role.

Responsibilities :

Conduct discovery sessions with clients to identify reporting needs

Collaborate with clients on Power BI licensing options, understanding the benefits and limitations of each platform

Design efficient star schema data models for Power BI, including proper calculated columns and measures

Develop Power BI solutions for clients, integrating data from multiple sources, building reports and dashboards, and creating data elements with DAX and source queries

Support clients in deploying Power BI solutions to the Power BI service, including gateways, DirectQuery, DataFlows, and data refreshes

Qualifications :

Bachelor's degree in Computer Science, Engineering, Data Science, or related fields; or equivalent work experience

Over 5 years of experience working with data and business intelligence solutions within the Microsoft ecosystem (SSRS, Power BI, PowerPivot, PerformancePoint) or other BI tools (Business Objects, MicroStrategy, Qlik, SAP)

Minimum of 4 years of leadership experience in business intelligence and analytics

Proficient in T-SQL, data modeling, and reporting using Power BI or similar tools

Experience creating comprehensive Power BI reports with linked content, drill-downs, and nested parameters

Advanced DAX skills for dynamic measure creation

Knowledge of data mashups and transformations using Power Query / M language

Hands-on experience with Databricks for developing, implementing, and optimizing data pipelines

Ability to communicate visual choices and interactions effectively

Skilled in designing user interfaces that are user-friendly and require minimal training for end-users

Capable of gathering requirements and conducting focus groups to identify business process improvements

Professional Skills :

Enthusiastic team player willing to contribute collaboratively

Excellent written and oral communication skills for both technical and non-technical audiences

Passionate about learning new technologies

Analytical mindset with strong problem-solving skills, leveraging technology to address business challenges

Adaptable to fast-paced work environments

Additional Preferred Experience :

Managing Power BI tenants and workspaces for development, testing, and deployment

Creating custom visualizations in Power BI using Python or R

Advanced SQL skills, including query tuning

Experience in assessing and improving data quality

Deploying Power BI solutions on-premises via Power BI Report Server

Using Power BI Embedded for solution deployment

Implementing cloud-based Power BI solutions utilizing Microsoft Azure data services such as Azure Data Factory, Azure Data Lake, and Azure SQL Database