TASQ Staffing Solutions
Lead Consultant BI/A - WFH
About this role
About the job: Lead Consultant BI/A Schedule: 5pm-2am Due to logistical reasons, we can only accept Philippine-based applicants. Job Overview Power BI's basic functionality is rooted in having good quality data. We are looking for lead consultants who specialize in Power BI with a focus on data. You must have advanced knowledge of Power BI and its data components, including PowerQuery/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 the Databricks platform to develop, implement, and optimize data pipelines and workflows. You must have strong communication skills that allow you 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 columns and measures
- Creating Power BI solutions for customers, including importing data from multiple sources, building reports 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
- 5+ years working with data and business intelligence solutions on the Microsoft tool stack for Intelligence (SSRS, Power BI, or PowerPivot (Excel) or PerformancePoint), or other vendor Business Intelligence tools (Business Objects, MicroStrategy, Qlik, SAP)
- 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 the Databricks platform to develop, implement, and optimize data pipelines and workflows.