TASQ Staffing Solutions

Lead Consultant - Power BI&A | Remote

United States remote Senior Salary not listed
remote Senior level Technology & IT Curated
Sign in to apply Free account — we bring you straight back to this role.

About the role

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

Originally posted on Himalayas

Interview prep

Walk in with sharper answers.

Use this as a quick practice sheet before you speak with the employer.

Senior
Technology & IT Data Analysis Excel MySQL Python Remote Collaboration Senior level

Likely questions

  1. Tell us about work you have done that is close to the Lead Consultant - Power BI&A | Remote role.
  2. How would you approach your first 30 days at TASQ Staffing Solutions?
  3. Which of Data Analysis, Excel and MySQL have you used recently, and what did it help you achieve?
  4. How have you led people, improved a process, or made a hard decision in a previous role?
  5. How do you stay organised and communicate clearly when working remotely?

Prepare before the call

  • A recent example that proves your experience with Data Analysis, Excel and MySQL.
  • One short story with a problem, your action, and the result.
  • Two examples that show the strengths listed on your CV.
  • A clear reason why this role and company interest you.
  • Your availability, preferred work style, and salary expectations.

Ask them

  • What would success look like in the first 90 days?
  • What are the main problems this hire should help solve?
  • How does the team give feedback and measure good work?
  • What does a normal working week look like for this role?
Practice line

I am interested in the Lead Consultant - Power BI&A | Remote role because I can bring practical experience in Data Analysis, Excel and MySQL, learn the team quickly, and contribute to the outcomes TASQ Staffing Solutions needs from this hire.

Related jobs.

More roles from this company or category.