负责人顾问 - Power BI&A | 远程
Lead Consultant - Power BI&A | Remote
职位详情
您必须精通Power BI及其数据组件，包括Power Query/M、DAX和维度建模，具备基本报告设计的知识和经验。了解常规SQL Server（数据仓库设计、SSIS和SSRS）和DirectQuery是有帮助的。您还需要了解Power BI许可模型，并能够与客户合作，帮助他们实现最适合其业务需求的许可模型。您必须有使用Databricks平台开发、实施和优化数据管道和工作流的经验。您必须具备良好的沟通能力，能够定期与客户及其员工以及相关领域的专家（包括数据库开发人员和软件工程师）进行交流。您出色的分析和解决问题的能力，以及对商业智能技术和业务方面的良好掌握，以及始终保持对Power BI最新更新的了解，将使您成为该职位的合适人选。如果您是一位对使用以数据为重点的Power BI技术充满热情的人，并且与客户合作良好，您可能就是我们正在寻找的人。
职责
- 与客户进行发现会议，确定报告需求
- 理解并协助客户处理Power BI许可，并了解每个许可平台的限制/优势
- 为Power BI创建性能良好的星型模式数据模型，包括适当的计算列和度量值
- 为客户创建Power BI解决方案，包括从多个来源导入数据、构建报告和仪表板，并使用DAX和源查询创建适当的数据元素
- 指导客户将Power BI解决方案部署到Power BI服务（网关、DirectQuery、DataFlows、数据更新）
资格
- 计算机、工程、数据科学或相关领域的学士学位；或同等的工作经验
- 在微软商业智能工具栈（SSRS、Power BI或PowerPivot（Excel）或PerformancePoint）或其它供应商商业智能工具（Business Objects、MicroStrategy、Qlik、SAP）上拥有7年以上数据和商业智能解决方案的工作经验
- 3-4年管理团队的经验
- 熟悉TSQL、数据建模、使用Power BI或其他微软工具进行报告
- 有创建完整Power BI报告解决方案的经验
查看英文原文
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