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