Lead Consultant Power BI - Remote

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

Due to logistical reasons, we are only selecting Philippine-based applicants.

Job Summary: Power BI's core strength lies in high-quality data. We are seeking Lead Consultants with expertise in Power BI, especially focused on data management. Candidates should possess advanced knowledge of Power BI and its data components, including PowerQuery/M, DAX, and dimensional modeling, along with experience in basic report design. Familiarity with SQL Server (data warehouse design, SSIS, SSRS) and DirectQuery is advantageous. Additionally, you should understand Power BI licensing models and be capable of collaborating with clients to determine the most suitable licensing options for their needs. Experience with Databricks for developing, deploying, and optimizing data pipelines and workflows is essential. Strong communication skills are required to interact regularly with clients, their teams, and specialists such as database developers and software engineers. Your analytical mindset, problem-solving abilities, and understanding of both technical and business aspects of business intelligence, combined with staying current on Power BI updates, will make you an ideal candidate. If you are passionate about Power BI and data-focused work, and enjoy working closely with customers, you might 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

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

Build Power BI solutions by importing data from various sources, creating reports and dashboards, and developing data elements with DAX and source queries

Guide clients on deploying Power BI solutions via the Power BI service, including setting up gateways, DirectQuery, DataFlows, and data refreshes

Qualifications:

Bachelors degree in Computer Science, Engineering, Data Science, or related fields, or equivalent work experience

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

Proficient in T-SQL, data modeling, and report creation using Power BI or similar Microsoft tools

Skilled in designing comprehensive Power BI reports with features like drilldowns, linked content, and nested parameters

Advanced DAX techniques for dynamic measure creation

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

Experience with Databricks for developing and optimizing data pipelines and workflows

Ability to articulate visual design choices and interactions

Capable of designing user interfaces that are intuitive and require minimal training for end users

Skilled in gathering requirements and conducting focus groups to support business growth

Professional Skills:

Team-oriented with a proactive attitude

Excellent written and verbal communication skills for technical and non-technical audiences

Eagerness to learn new technologies

Strong analytical skills with the ability to leverage 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 visualizations and analytics in Power BI using Python or R

Advanced SQL skills, including query tuning

Experience in data quality assessment

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

Using Power BI Embedded for solution deployment

Implementing cloud-based Power BI solutions with Azure Data Factory, Azure Data Lake, and Azure SQL Database

Originally posted on Himalayas