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