Senior Power BI Consultant - Remote/WFH

Position: Senior Consultant Power BI | Remote
Schedule: Midshift (5 p.m. to 2 a.m.)

Overview:
Power BIs effectiveness hinges on access to high-quality data. We are looking for Lead Consultants with expertise in Power BI, emphasizing data management. Ideal candidates will have advanced skills in Power BI and its data tools, including PowerQuery/M, DAX, and dimensional modeling, as well as experience in basic report development. Familiarity with SQL Server components such as data warehouse design, SSIS, SSRS, and DirectQuery is a plus. You should also understand Power BI licensing options and be able to advise clients on selecting the most appropriate licensing models for their business needs. Experience working with Databricks to develop, implement, and optimize data pipelines and workflows is required. Excellent communication skills are essential for collaborating with clients, their teams, and other technical professionals like database developers and engineers. Your strong analytical and problem-solving skills, combined with a solid grasp of both technical and business intelligence aspects, along with a commitment to keeping up-to-date with Power BI developments, will make you a valuable candidate. If you are passionate about Power BI with a data-driven approach and enjoy working directly with clients, this role could be an ideal fit.

Responsibilities:

• Conduct discovery sessions to understand client reporting requirements
• Collaborate with clients on Power BI licensing options, understanding the pros and cons of each platform
• Design efficient star schema data models for Power BI, including calculated columns and measures
• Build Power BI solutions by integrating data from multiple sources, developing reports and dashboards, and creating data elements using DAX and source queries
• Assist clients in deploying Power BI solutions to the Power BI service, including setting up gateways, DirectQuery connections, DataFlows, and managing data refreshes

Qualifications:

• Bachelors degree in Computer Science, Engineering, Data Science, or related fields; or equivalent work experience
• Over 4 years of experience working with data and BI solutions within the Microsoft ecosystem (SSRS, Power BI, PowerPivot, PerformancePoint) or other BI tools (Business Objects, MicroStrategy, Qlik, SAP)
• Proficiency in T-SQL, data modeling, and report creation using Power BI or similar platforms
• Experience developing comprehensive Power BI reports with linked content, drill-downs, and nested parameters
• Strong DAX skills for creating dynamic measures
• Knowledge of data mashups and transformations using Power Query/M language
• Practical experience with Databricks in building, implementing, and optimizing data pipelines
• Ability to communicate visual design choices and interactions effectively
• Skilled in designing user interfaces that are intuitive and require minimal training
• Able to gather requirements and facilitate focus groups to identify business process improvements

Professional Skills:

• Enthusiastic team player willing to collaborate
• Excellent communication skills, both written and verbal, for technical and non-technical audiences
• Eagerness to learn new technologies
• Analytical mindset with strong problem-solving abilities, leveraging technology to solve business challenges
• Adaptable to fast-paced work environments

Additional Preferred Experience:

• Managing Power BI tenants and workspaces for development, testing, and deployment
• Creating custom Power BI visualizations using Python or R
• Advanced SQL skills, including query tuning
• Experience assessing and improving data quality
• Deploying Power BI solutions on-premises using Power BI Report Server
• Using Power BI Embedded for deployment
• Implementing cloud-based Power BI solutions utilizing Microsoft Azure services such as Azure Data Factory, Azure Data Lake, and Azure SQL Database