商业智能分析师 - 中级 JP919
Business Intelligence Analyst - Intermediate JP919
项目名称：
数字监管保障系统
范围：
阿尔伯塔省政府的现代化计划正在从根本上改变各部用户收集、管理、分析和使用数据的方式，随着旧系统转变为现代数据管理和地理空间平台。这种转变需要专门的分析能力，以确保现代化数据资产的价值得到充分实现。
DRAS 是阿尔伯塔省政府环境与保护部门（EPA）领导的一项监管转型计划，旨在现代化、数字化并简化环境和自然资源监管流程。DRAS 通过一个统一的数字平台支持整个监管生命周期，包括申请和授权、监测、合规、补救和关闭。
DRAS 数据规模的增加带来了对专门的商业智能和分析能力的持续强烈需求，以支持运营监控、合规监督、绩效衡量和战略决策。这些需求涵盖整个数据生命周期，包括数据收集和集成、数据质量管理、趋势、模式、合规和监管报告分析，以及通过仪表板和可视化交付清晰、可操作的见解。
该职位将主要支持数字监管保障系统（DRAS）项目，高质量、及时的分析对于监管和合规职能至关重要。随着数据和分析成熟度的提高，该角色可能会扩展到支持其他企业级数据项目。
职责：这是标准的服务描述——根据需要进行修改。
设计和开发复杂的仪表板、评分卡和可视化分析，使用 Power BI
设计、开发和维护使用 Microsoft Power BI 和基于 Azure 的数据平台的数据模型和可视化
数据建模与 ETL 开发
使用 DAX 和 Power Query M 创建优化、可重用的数据模型用于全企业报告
使用 Microsoft Power BI 构建针对业务需求的交互式仪表板和报告
将 Power BI 与各种 Microsoft Azure 数据源和本地数据库集成
与业务用户、数据架构师和数据工程师紧密合作，管理数据管道、暂存区和语义模型
与业务部门合作，收集报告需求和 KPI
将模糊的业务问题转化为具体的 BI 解决方案
以清晰的方式呈现见解和发现
查看英文原文
Project Name:
Digital Regulatory Assurance System
Scope:
Modernization initiatives across the Government of Alberta are fundamentally changing how ministry users collect, manage, analyze, and use data as legacy systems are transformed into modern Data Management and Geospatial Platforms. This shift requires dedicated analytical capacity to ensure that the value of modernized data assets is fully realized.
DRAS is a Government of Alberta regulatory transformation initiative led by Environment and Protected Areas (EPA) to modernize, digitize, and streamline environmental and natural resource regulatory processes. DRAS supports the full regulatory lifecycle, from application and authorization to monitoring, compliance, remediation, and closure through a single, consolidated digital platform.
The increasing scale of DRAS data creates a strong and ongoing need for dedicated business intelligence and analytics capability to support operational monitoring, compliance oversight, performance measurement, and strategic decision‑making. These needs span the full data lifecycle, including data collection and integration, data quality management, analysis of trends, patterns, compliance and regulatory reporting, and the delivery of clear, actionable insights through dashboards and visualizations.
This position will primarily support the Digital Regulatory Assurance System (DRAS) program, where high‑quality, timely analytics are essential to regulatory and compliance functions. As data and analytics maturity increases, the role may be expanded to support additional enterprise data initiatives.
Duties: This is the standard description of services – revise as needed.
Design and develop complex dashboards, scorecards, and visual analytics using Power BI
Design, develop, and maintain data models and visualizations using Microsoft Power BI and Azure-based data platforms
Data Modeling & ETL Development
Create optimized, reusable data models using DAX and Power Query M for enterprise-wide reporting
Build interactive dashboards and reports tailored to business needs using Microsoft Power BI
Integrate Power BI with various Microsoft Azure data sources and on-premises databases
Work closely with Business users, data architects and data engineers to manage data pipelines, staging areas, and semantic models.
Work with business units to gather reporting requirements and KPIs.
Translate ambiguous business questions into concrete BI solutions.
Present insights and findings in clear, executive-friendly formats.
Provide end-user training and support to ensure adoption of BI tools
Maintain and publish datasets and dashboards in Power BI Service with scheduled refreshes and alerts
Optimize dashboards and reports for performance
Implement security and user access controls within Power BI
Implement incremental data refresh, row-level security (RLS), and performance tuning strategies in Power BI.
Conduct deep-dive analytics to uncover trends, anomalies, and business opportunities.
Ensure data accuracy, consistency, and security compliance across all reporting assets
Integrate AI capabilities to augment analytical processes by automating data exploration identifying trends and anomalies and generating insights.
Other duties as needed
Originally posted on Himalayas