Lead Consultant Power BI and Analytics - Fully WFH

TASQ Staffing Solutions; Manila; Hybrid; PHP 1,339,000 - 2,009,000; Full time

Job summary

TASQ Staffing Solutions is hiring a Lead Consultant Power BI and Analytics for a fully remote role based in the Philippines. You will lead data-driven BI initiatives, design robust data models, and guide clients on BI solutions and licensing.

Strong communication with clients and teams is essential for success. Candidate should have extensive Power BI experience, Databricks skills, and a solid background in SQL and data warehousing.

Qualifications

• Degree or equivalent with BI/data analytics experience.
• Proficient in Power BI, DAX and data modeling.
• Strong SQL and data warehousing knowledge.

Responsibilities

• Conduct discovery sessions to understand reporting needs
• Advise on Power BI licensing options and governance
• Design star schema data models and measures
• Build Power BI solutions with reports, dashboards, data elements
• Deploy solutions to Power BI service with gateways and DirectQuery

Skills

Power BI

DAX

SQL

Data modeling

Data analysis

Client engagement

Communication

Education

Bachelor's degree in Computer Science/Engineering/Data Science or related

Tools

SSRS

SSIS

PowerQuery/M

Databricks

Job description

Lead Consultant Power BI and Analytics - Fully WFH

Job Openings Lead Consultant Power BI and Analytics - Fully WFH

About the job Lead Consultant Power BI and Analytics - Fully WFH

TASQ is currently seeking candidates to fill this role. The position involves a fully remote work schedule from 5 PM to 2 AM. Due to logistical reasons, we can only consider applicants based in the Philippines.

Job Title: Lead Consultant Power BI and Analytics | REMOTE

Job Overview:

Success with Power BI depends on high-quality data management. We are looking for experienced lead consultants with strong expertise in Power BI and data administration. Ideal candidates will have advanced skills in Power BI components such as PowerQuery/M, DAX, and dimensional modeling, along with foundational report design abilities. Familiarity with SQL Server, including data warehouse architecture, SSIS, SSRS, and DirectQuery, is a plus. Knowledge of Power BI licensing options and the ability to advise clients on optimal licensing arrangements are essential. Experience with Databricks for building and optimizing data pipelines is required. Excellent communication skills are necessary to collaborate effectively with clients, their teams, and technical specialists like database developers and engineers. Candidates should demonstrate strong analytical and problem-solving skills, a good understanding of both technical and business intelligence concepts, and a proactive approach to staying updated on Power BI developments. If you are passionate about data-driven solutions and excel at client engagement, this could be the right opportunity for you.

Key Responsibilities:

• Conduct discovery sessions with clients to understand their reporting needs
• Advise clients on Power BI licensing options, highlighting benefits and limitations
• Design efficient star schema data models, including calculated columns and measures
• Develop Power BI solutions by importing data from various sources, creating reports, dashboards, and data elements using DAX and source queries
• Assist clients in deploying Power BI solutions to the Power BI service, including configuring gateways, DirectQuery, data flows, and refresh mechanisms

Required Qualifications:

• Bachelors degree in Computer Science, Engineering, Data Science, or related fields, or equivalent professional experience
• Over 5 years of experience working with data and business intelligence solutions using Microsoft tools (SSRS, Power BI, PowerPivot, PerformancePoint) or other BI platforms (e.g., Business Objects, MicroStrategy, Qlik, SAP)
• Proficiency in T-SQL, data modeling, and report development with Power BI or similar tools
• Proven track record in designing interactive Power BI reports with drilldowns and nested parameters
• Advanced knowledge of DAX for creating dynamic measures
• Experience with Power Query/M for data mashups and transformations
• Hands-on experience with Databricks for developing and optimizing data workflows
• Ability to select suitable visualizations and craft user-friendly, interactive reports
• Skilled in requirements gathering and conducting focus groups to enhance business processes

Professional Skills:

• Team-oriented with a proactive approach
• Excellent verbal and written communication skills, capable of engaging with both technical and non-technical audiences
• Eagerness to learn new technologies
• Strong analytical and problem-solving abilities, leveraging technology to resolve business challenges
• Adaptability to fast-paced work environments

Preferred Additional Experience:

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