Business Intelligence Specialist – Power Bi Developer

RESPONSIBILITIES

• To integrate, translate and oversee design of business-driven issues and priorities into enterprise-level business intelligence and data analytics solutions, using leading-edge data development approaches, with expertise/knowledge in data modelling, data architecture and infrastructure, data development (including dimensional modelling) as well as reporting (e.g. dashboard) development.
• To lead data development and maintenance activities that support strategic initiatives and priority projects across the ministry, including the preparation of ad-hoc statistical information and developing research/analytical data for reporting and analytics, while ensuring appropriate data quality, integrity, privacy, and security.
• To project-manage (e.g. design, deliver and implement) complex I&IT projects and various agile, business solutions required to meet cross-ministry business intelligence and data analytics activities and priority projects, including leading and supporting enterprise-wide projects that may involve work with other ministries, jurisdictions and the broader public sector.
• To work within the ministry's business analytics data warehouse environment, and support efforts to enhance and maintain infrastructure and applications and providing technical expertise to the development and implementation of various I&IT solutions, while working with CYSSC, ITS and enterprise partners.

MUST HAVE

• SQL Server
• Ability to present technical requirements to the business
• 3+ years using Power BI software development, including using DAX queries and functions.
• Oracle
• Microsoft Azure services such as Power Apps, Power Automate, Azure Database, Azure Analysis Services, Azure Synapse, Customer Voice, etc.
• Familiarity with accessibility compliance, usability testing e.g. AODA, WCAG 2.0
• Ability to translate wireframes, lo-fidelity and high-fidelity prototypes and business requirements into technical tasks towards functional reporting products or dashboards

NICE TO HAVE

• Knowledge of Golden Gate is an asset but not required.
• Some knowledge of user interface design and user interaction design is an asset but not required.

SKILLS

• Experience with data-specific tasks including database management, SQL querying, data modelling, online analytical processing.
• Experience with scripting and programming
• Experience in Power BI software development and a number of years of practical experience (minimum 3+ years)
• Ability to assist in the requirements gathering, analysis and subsequent developments.
• Experience working with MS SQL Server on premise and within Azure Environment
• Experience prototyping to develop business requirements for future implementation.
• Experience in other Microsoft BI stack e.g. SSAS, SSRS, SSIS
• Ability to conduct unit tests and assist in test preparations to ensure data integrity.
• Work closely with Project Manager, UX/UI Designers, Quality Assurance Analysts, and other Developers
• Experience working within an Agile software development life cycle, e.g., Scrum/Kanban
• Experience building, testing and implementing complex reports, dashboards, and other objects.
• Experience with designing and mapping multi-dimensional data models, report models into business insights.
• Understanding of accessibility compliance requirements e.g., AODA, WCAG 2.0