Business Intelligence and Analytics Senior Consultant - WFH

TASQ Staffing Solutions; Makati; Remote; PHP 1,200,000 - 2,400,000; Full time

Job summary

TASQ Staffing Solutions is seeking a Senior Consultant for Business Intelligence and Analytics to work fully remote from the Philippines. The role emphasizes data management, architecture, and advanced Power BI capabilities, including DAX, PowerQuery/M, and SQL Server components.

Ideal candidates will lead client engagements, design scalable data models, and guide licensing strategies while collaborating with technical teams and stakeholders. Remote, Philippines-based, with a 5 p.m.–2 a.m.

Qualifications

• BS/related field or equivalent professional experience.
• Over 5 years with data/BI solutions in Microsoft ecosystem or other BI platforms, with 4+ years leadership.
• Proficiency in T-SQL, data modeling, and Power BI report development.

Responsibilities

• Lead discovery sessions with clients to determine reporting requirements.
• Explain and select Power BI licensing options for clients.
• Design star schema data models with calculated columns and measures.
• Develop Power BI solutions by importing data, creating reports/dashboards, and modeling data.
• Support deployment of Power BI solutions via service, gateways, DirectQuery, and DataFlows.

Skills

Power BI

DAX

Data modeling

T-SQL

Databricks

SQL Server

Power Query/M

DirectQuery

Leadership

Stakeholder communication

Education

Bachelor's degree in CS/Engineering/Data Science

Tools

Power BI

SSRS

SSIS

SQL Server

Databricks

Job description

Business Intelligence and Analytics Senior Consultant - WFH

Job Openings Business Intelligence and Analytics Senior Consultant - WFH

About the job Business Intelligence and Analytics Senior Consultant - WFH

Position: Senior Consultant for Business Intelligence and Analytics | Remote
Work Arrangement: Fully Remote
Schedule: 5 p.m. to 2 a.m.
At least 5 years of relevant experience and at least 4 years of relevant leadership experience would be needed for the job.

Please note that, for logistical reasons, we are only considering applicants based in the Philippines.

Job Overview:
Power BIs effectiveness hinges on high-quality data management. We are looking for Lead Consultants with strong expertise in Power BI, particularly in data handling and architecture. Ideal candidates will have advanced knowledge of Power BI and its data components, such as PowerQuery/M, DAX, and dimensional modeling, along with foundational report development skills. Familiarity with SQL Server (including data warehouse design, SSIS, SSRS) and DirectQuery is a plus. Additionally, you should understand Power BI licensing options and be capable of advising clients on the best licensing strategies for their needs. Experience with Databricks for building, deploying, and optimizing data pipelines and workflows is essential. Strong communication skills are necessary to work effectively with clients, their teams, and technical specialists like database developers and software engineers. A solid analytical mindset, problem-solving capabilities, and a good grasp of both technical and business intelligence conceptsplus a commitment to staying updated on Power BI developmentsare key qualities. If youre passionate about Power BI, data-driven solutions, and client collaboration, this role could be a great fit.

Key Responsibilities:

• Lead discovery sessions with clients to determine reporting requirements
• Collaborate with clients to explain and select 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 multiple sources, creating reports, dashboards, and data models using DAX and queries
• Support clients in deploying Power BI solutions via the Power BI service, including configuring gateways, DirectQuery, DataFlows, and data refresh processes

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 BI solutions within the Microsoft ecosystem (such as SSRS, Power BI, PowerPivot, PerformancePoint) or other BI platforms like Business Objects, MicroStrategy, Qlik, SAP with at least 4 years of leadership experience
• Proficiency in T-SQL, data modeling, and report development using Power BI or similar tools
• Proven ability to design comprehensive Power BI reports with features like drilldowns, linked content, and nested parameters
• Advanced skills in creating dynamic measures with DAX
• Experience with data transformation and mashups using Power Query/M language
• Hands-on experience with Databricks for developing and refining data pipelines
• Ability to communicate visual design choices and interaction features effectively
• Skilled in designing user interfaces that are intuitive and require minimal training
• Experience in gathering requirements and conducting focus groups to enhance business processes

Professional Skills:

• Collaborative team player with a proactive approach
• Excellent written and verbal communication skills, capable of engaging both technical and non-technical audiences
• Enthusiastic about learning new technologies
• Strong analytical and problem-solving skills, leveraging technology to address 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 optimization
• Experience in data quality assessment
• Deploying Power BI solutions on-premises using Power BI Report Server
• Embedding Power BI reports with Power BI Embedded
• Building cloud-based Power BI solutions utilizing Azure services such as Azure Data Factory, Azure Data Lake, and Azure SQL Database