Remote Lead BI & Analytics Consultant - Power BI

Carbon Data Solutions; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

TASQ is seeking Lead and Senior Consultants for Power BI and Analytics in a fully remote setup. The role involves engaging with clients to identify reporting needs, designing star schemas, and delivering Power BI solutions using DAX, queries, and data sources.

Expect collaboration with clients on licensing, gateways, and data refresh processes. The ideal candidate has 5+ years in BI with Power BI and related tools, strong SQL skills, and hands-on Databricks experience.

Qualifications

• Bachelor's degree in computer science, engineering, data science, or related fields, or equivalent professional experience.
• Over 5 years of experience with data and business intelligence solutions using Microsoft tools (SSRS, Power BI, PowerPivot, PerformancePoint) or other BI platforms (Business Objects, MicroStrategy, Qlik, SAP).
• Proficiency in TSQL, data modeling, and reporting with Power BI or similar tools.
• Proven experience designing comprehensive Power BI reports with interactive features, drilldowns, and nested parameters.
• Expertise in creating dynamic measures with advanced DAX.
• Knowledge of data mashups and transformations using Power Query/M.
• Hands-on experience with Databricks for developing and streamlining data workflows.
• Ability to select appropriate visualizations and design interactive report interfaces.
• Skilled in gathering requirements and conducting focus groups to improve business processes.

Responsibilities

• Engage with clients to identify reporting needs through discovery meetings.
• Advise clients on Power BI licensing options, explaining the benefits and limitations of each.
• Develop efficient star schema data models, including calculated columns and measures.
• Build Power BI solutions by importing data from diverse sources, creating reports, dashboards, and data elements using DAX and source queries.
• Support clients in deploying Power BI solutions to the Power BI service, including setting up gateways, DirectQuery, data flows, and data refreshes.

Skills

Power BI

DAX

TSQL

Data Modeling

Query Tuning

Databricks

Education

Bachelor's degree in CS/Engineering/Data Science

Tools

SSRS

PowerPivot

PerformancePoint

Business Objects

MicroStrategy

Qlik

SAP

Power Query/M

Databricks

Job description

TASQ is seeking Lead and Senior Consultants for Power BI and Analytics in a fully remote setup. The role involves engaging with clients to identify reporting needs, designing star schemas, and delivering Power BI solutions using DAX, queries, and data sources.

Expect collaboration with clients on licensing, gateways, and data refresh processes. The ideal candidate has 5+ years in BI with Power BI and related tools, strong SQL skills, and hands-on Databricks experience.