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 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 enterprise partners.
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.
Experience:
Experience in Power BI software development and a number of years of practical experience (minimum 3+ years)
Experience in other Microsoft BI stack e.g. SSAS, SSRS, SSIS
Experience with scripting and programming
Experience working with MS SQL Server on premise and within Azure Environment
Experience with data-specific tasks including database management, SQL querying, data modelling, online analytical processing
Experience with designing and mapping multi-dimensional data models, report models into business insights
Ability to assist in the requirements gathering, analysis and subsequent developments
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
Understanding of accessibility compliance requirements e.g. AODA, WCAG 2.0
Skills:
Must Have:
3+ years using Power BI software development, including using DAX queries and functions
Microsoft Azure services such as Power Apps, Power Automate, Azure Database, Azure Analysis Services, Azure Synapse, etc.
SQL Server
Working knowledge of DataBricks
Ability to translate wireframes, low-fidelity and high-fidelity prototypes and business requirements into technical tasks towards functional reporting products or dashboards
Ability to present technical requirements to the business
Familiarity with accessibility compliance, usability testing e.g. AODA, WCAG 2.0
Nice to Have:
Some knowledge of user interface design and user interaction design is an asset but not required.