Lead Consultant - Power BI&A | Remote

Tasq Work; Philippines; Remote; PHP 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Remote work

Night shift hours

Job summary

Tasq Work is seeking an experienced BI Professional in the Philippines to design and optimize Power BI solutions, leveraging Data Modeling, DAX, and Databricks pipelines. You will collaborate with clients, understand licensing options, and deliver robust BI dashboards tailored to business needs.

The role requires advanced knowledge of Power BI components, SQL Server data warehousing concepts, and strong communication across technical and nontechnical teams.

Qualifications

• Bachelor's degree or equivalent work experience in a related field.
• 7+ years working with data and BI solutions on the Microsoft stack (Power BI/SSRS/PowerPivot) or similar.
• 3–4 years of experience managing a team.
• Experience with T-SQL and data modeling for Power BI reporting.
• Experience creating Power BI reports with drilldowns, parameters, and linked content.
• Advanced DAX techniques and dynamic measure design.
• Knowledge of Power Query/M language data mashups and transformations.
• Experience with Databricks for data pipelines and workflows.
• Ability to report on visual design and interactions.
• Ability to gather requirements and run focus groups.

Responsibilities

• Conduct customer discovery meetings to determine reporting requirements.
• Understand Power BI licensing and its limits/advantages for customers.
• Create star schema data models for Power BI with calculated columns and measures.
• Build Power BI solutions including multi-source data imports, reports and dashboards.
• Guide customers on deploying Power BI solutions to the service, Gateways, DirectQuery, Dataflows, and Data Updates.

Skills

Team collaboration

Excellent communication

Learning mindset

Analytical problem solving

Fast-paced environment

Education

Bachelor's degree in computer science, engineering, data science or related field

Tools

Power BI

Power Query/M

DAX

SSRS

SSIS

SQL

Databricks

Azure data services

Power BI Report Server

Job description

Job Details

You must have advanced knowledge of Power BI and its data components including Power Query/M, DAX, and dimensional modeling, with knowledge and experience in basic report design. Having a working knowledge of conventional SQL Server (data warehouse design, SSIS and SSRS) and DirectQuery is helpful. You will also need to understand Power BI License models and be able to work with customers to help them achieve the most optimal licensing model for their business needs. You must have experience using Databricks platform to develop, implement, and optimize data pipelines and workflows. You must have strong communication skills that allow them to regularly deal with clients and their staff, as well as with specialists from related fields, including database developers, and software engineers. Your outstanding analytical and problem-solving skills and good grasp of both the technical and business side of business intelligence, and your ability to always keep up to date with the latest updates for Power BI will make you a good candidate for this role. If you are an individual who is highly interested in using Power BI technologies with a focus on data, and you work well with customers, you may be who we are looking for.

Responsibilities

• Conduct customer discovery meetings to determine reporting requirements
• Understand and work with customer on Power BI Licensing, and understand the limits/advantages of each licensing platform
• Create well performing star schema data models for use with Power BI, including proper calculated columns and measures
• Creating Power BI solutions for customers including importing data from multiple sources, building reports and dashboards, and creating appropriate data elements using DAX and source queries
• Guide customers on deploying Power BI solutions to the Power BI service (Gateways, DirectQuery, DataFlows, Data Updates)

Qualifications

• Bachelor’s degree in computer, engineering, data science or a related field; or equivalent work experience
• 7+ years working with data and business intelligence solutions on the Microsoft tool stack for Business Intelligence (SSRS, Power BI, or PowerPivot (Excel) or PerformancePoint), or other vendor Business Intelligence tools (Business Objects, MicroStrategy, Qlik, SAP)
• 3 – 4 years of experience managing a team.
• Working knowledge of TSQL, data modeling, reporting using Power BI or other Microsoft tools
• Experience creating complete Power BI report solutions based on business questions with linked content, drilldowns, and nested parameters
• Dynamic measure designs using advanced DAX techniques
• Knowledge of data mashups and transformations using Power Query/M language
• Utilize Databricks platform to develop, implement, and optimize data pipelines and workflows.
• Ability to report visual choices and visual interactions
• Design, develop and implement user interfaces to ensure ease of use and minimal knowledge by the functional work group that will be using the database
• Ability to gather requirements and conduct focus groups to determine the processes needed to assist and grow the business

Professional Skills:

• Eagerness to contribute in a team-oriented environment
• Excellent communication (written and oral) and interpersonal skills for both technical and nontechnical teams
• Passionate about learning new technologies
• Analytical approach to problem-solving; ability to use technology to solve business problems
• Ability to work in a fast-paced environment

Additional Preferred Experience:

• Power BI tenant and workspace management to support development, testing and deployment
• Experience with analytics and custom visualizations for Power BI using Python, R
• Advanced SQL including some query tuning
• Experience in the identification of data quality
• Experience deploying Power BI solutions to the Power BI Report Server (on-premises)
• Experience deploying Power BI solutions using Power BI Embedded
• Deploying cloud-based solutions using Microsoft Azure data services including Azure Data Factory, Azure Data Lake, and Azure SQL DB

Additional Details:

• Work arrangement: Remote with equipment provided
• Work schedule: 5PM - 2AM Monday - Friday