Senior Consultant Power BI - Remote, Midshift

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