高级顾问 Power BI - 远程/居家办公
Lead Consultant Power BI - Remote/WFH
职位：高级顾问 Power BI | 远程办公
工作安排：远程办公
时间安排：中班（下午5点至凌晨2点）
简介：
Power BI 的核心优势在于高质量的数据。我们正在寻找专注于 Power BI 的高级顾问，重点在数据管理方面。候选人应具备 Power BI 及其数据组件（包括 PowerQuery/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、PerformancePoint）或其他 BI 工具（Business Objects、MicroStrategy、Qlik、SAP）中，有超过 5 年的数据和商业智能解决方案工作经验
- 至少 4 年在商业智能和分析领域的领导经验
- 熟练
查看英文原文
Position: Lead Consultant Power BI | Remote
Work Arrangement: Remote
Schedule: Midshift (5 p.m. to 2 a.m.)
Overview:
Power BI's core strength lies in having high-quality data. We are seeking Lead Consultants who specialize in Power BI with a strong focus on data management. Candidates should possess advanced expertise in Power BI and its data components, including PowerQuery/M, DAX, and dimensional modeling, along with experience in basic report design. Familiarity with traditional SQL Server (data warehouse design, SSIS, SSRS) and DirectQuery is advantageous. Additionally, you should understand Power BI licensing models and be capable of working with clients to help them select the most suitable licensing options for their needs. Experience with Databricks in developing, implementing, and optimizing data pipelines and workflows is required. Strong communication skills are essential for engaging regularly with clients, their teams, and technical specialists such as database developers and software engineers. Your excellent analytical, problem-solving abilities, and understanding of both technical and business aspects of business intelligence, along with a commitment to staying current with Power BI updates, will make you a strong candidate. If you are passionate about Power BI technologies with a data-centric approach and enjoy working with customers, you may be the perfect fit for this role.
Responsibilities:
- Conduct discovery sessions with clients to identify reporting needs
- Collaborate with clients on Power BI licensing options, understanding the benefits and limitations of each platform
- Design efficient star schema data models for Power BI, including proper calculated columns and measures
- Develop Power BI solutions for clients, integrating data from multiple sources, building reports and dashboards, and creating data elements with DAX and source queries
- Support clients in deploying Power BI solutions to the Power BI service, including gateways, DirectQuery, DataFlows, and data refreshes
Qualifications:
- Bachelor's degree in Computer Science, Engineering, Data Science, or related fields; or equivalent work experience
- Over 5 years of experience working with data and business intelligence solutions within the Microsoft ecosystem (SSRS, Power BI, PowerPivot, PerformancePoint) or other BI tools (Business Objects, MicroStrategy, Qlik, SAP)
- Minimum of 4 years of leadership experience in business intelligence and analytics
- Proficient in T-SQL, data modeling, and reporting using Power BI or similar tools
- Experience creating comprehensive Power BI reports with linked content, drill-downs, and nested parameters
- Advanced DAX skills for dynamic measure creation
- Knowledge of data mashups and transformations using Power Query/M language
- Hands-on experience with Databricks for developing, implementing, and optimizing data pipelines
- Ability to communicate visual choices and interactions effectively
- Skilled in designing user interfaces that are user-friendly and require minimal training for end-users
- Capable of gathering requirements and conducting focus groups to identify business process improvements
Professional Skills:
- Enthusiastic team player willing to contribute collaboratively
- Excellent written and oral communication skills for both technical and non-technical audiences
- Passionate about learning new technologies
- Analytical mindset with strong problem-solving skills, leveraging technology to address business challenges
- Adaptable to fast-paced work environments
Additional Preferred Experience:
- Managing Power BI tenants and workspaces for development, testing, and deployment
- Creating custom visualizations in Power BI using Python or R
- Advanced SQL skills, including query tuning
- Experience in assessing and improving data quality
- Deploying Power BI solutions on-premises via Power BI Report Server
- Using Power BI Embedded for solution deployment
- Implementing cloud-based Power BI solutions utilizing Microsoft Azure data services such as Azure Data Factory, Azure Data Lake, and Azure SQL Database
Originally posted on Himalayas