Lead Consultant Power BI

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