Power BI Report Application Developer and Data Analyst

Description

What NAV CANADA offers you:

• Challenging, team-oriented work environment
• Competitive compensation and benefits
• Defined benefit pension plan
• Opportunities for growth and development
• Flexible work arrangements
• Diverse and inclusive workforce

Key Accountabilities:

• Provide expertise in Microsoft Power BI technology and Microsoft Fabric, including data design and development, reporting, dashboards, metrics, analytics and governance.
• Participate in complex or multiple complex projects across the full lifecycle (requirements gathering, analysis, design development, testing, and implementation) for new features and enhancements to applications. This includes solution evaluation, cost-benefit analysis, planning, resource estimation, solution architecture design, coaching others on project issues and recommending solutions.
• Develop and maintain communications with business stakeholders to understand their needs, advise on changes to plans, priorities, and shifts in processes affecting business requirements, processes, and workflow.
• Actively support the on-going life-cycle activities, platform maintenance, performance optimum, capacity assessment, monitoring, availability, security and communications interfaces, and technical support. Ensure Fabric governance, workspace management, and security controls are implemented and maintained.
• Monitor incident, request, and change management tickets and processes to ensure service levels are met. Establish procedures, standards, and best practices.
• Lead and participate in the Power BI user group community to share emerging technology advancements, maintain the engagement with stakeholders and support the development of self-service workloads.
• Leverage Microsoft Copilot within Power BI to enhance report development, DAX generation, data exploration, and insight discovery; coach and support team members and business users in the effective, responsible, and governed use of Copilot capabilities.
• Design and implement Power Automate workflows to support reporting automation, data refresh notifications, approval processes, and integration between Power BI and other enterprise systems.
• Recommend and / or champion ideas and innovations aligned with organizational goals.
• Lead and participate in the development, documentation, and execution of test cases and test scripts for solutions to identify and correct issues.
• Support the team in day-to-day tasks and ad-hoc assignments, proactively taking responsibility for planned and unplanned work required by clients.

Education/Occupational Certification:

• Graduated from a recognized university or college with a degree/certification in Computer Science, Computer/Software Engineering, Management Information Systems

Experience:

• 3+ year experience with Microsoft Power BI, requirements gathering, design, development, testing and implementation of reporting solutions. Experience designing semantic models using best practices in DAX, and data modeling.
• 3+ year experience with Microsoft Power BI, administration, developing best practices, standards, processes, and methodologies.
• 3+ year experience promoting and supporting Power BI platform and user group community.
• 3+ year experience working with database technology, Azure SQL Server, Azure Data Lake, and programming languages such as DAX and SQL.
• Experience in Microsoft Fabric - workspaces, apps, semantic models, dataflows, notebooks, pipelines, OneLake, SQL analytics.
• Experience with Azure Databricks.

Knowledge:

• Strong knowledge of business intelligence, data management, and analytics methodologies, including data warehousing, data quality, reference/master data, and delivery using SDLC, Agile, and DevOps practices.
• Expertise in Power BI and Fabric data modeling and design, including star/snowflake schemas, fact/dimension tables, semantic models, and advanced DAX and SQL for optimized calculations and queries.
• Experience with Microsoft Fabric enablement, Lakehouse architecture, Direct Lake, dataflows, semantic model integration. Experience using Power BI Copilot to accelerate development and adoption.
• Knowledge of Azure Databricks, Delta Lake, and notebooks for building structured data pipelines supporting downstream analytics and reporting.
• Knowledge of user interface, and data visualization design and best practices.

Abilities:

• Strong problem-solving and analytical skills.
• Skilled at translating complex data into compelling stories that highlight insights and business value, and communicating clearly to both technical and non-technical audiences.
• Ability to persuade, influence, and lead, while coaching and supporting others in their areas of expertise.
• Ability to manage multiple initiatives simultaneously.

Personal Suitability:

• Team-oriented, customer service and quality focused.
• High degree of initiative, responsibility, judgement, reliability, maturity, and timeliness in delivering solutions.
• Passionate about data, analytics, and technology solutions, driven to learn about them and keep up with market evolution.

Working conditions:

• This position is a hybrid position with a minimum – 3 day(s) per week on site.

NAV CANADA is committed to building a skilled, diverse workforce reflective of Canadian society. If you do not believe that you match every job requirement listed on this job posting, we still encourage you to apply. NAV CANADA encourages a culture of learning and growth, and recognizes that although some technical skills are mandatory, many others can be taught.

Our Company strives to create an inclusive and barrier-free selection process and work environment. If you require accommodations during this competition process, please ensure that you inform the interview coordinator or hiring manager of any accommodation measures you may require. NAV CANADA will provide accommodations throughout the recruitment and selection process to applicants with disabilities as required.

The successful candidate must meet the security requirement of the position and be legally able to work in Canada.

We thank all applicants for their interest; only those selected for next steps will be contacted.

-