Power BI Developer

Symbiotic Digital•Unorganized North Algoma, ON

9d•Onsite

About The Position

An experienced Software Developer is required to design and develop Business Intelligence (BI) solutions using Microsoft Power BI to meet diverse business needs. The role involves working closely with cross-functional technology and business teams to analyze requirements, design scalable solutions, and lead development activities while following established standards, best practices, and existing technology frameworks.

Requirements

10+ years of experience as a Software Designer/Developer
Strong expertise in Power BI (Desktop and Service)
Advanced knowledge of DAX and Power Query (M Language)
Strong SQL skills for data querying and management
Experience in data modeling (star schema, fact and dimension tables)
Hands-on experience with ETL processes and data integration
Ability to design interactive dashboards and reports
Experience connecting to multiple data sources including databases, APIs, and cloud platforms
Knowledge of performance tuning for datasets and reports
Implementation of Row-Level Security (RLS) and data governance
Familiarity with cloud analytics platforms (e.g., Azure, Microsoft Fabric)
Experience with Microsoft BI stack (SSIS, SSAS, SSRS, Azure Data Factory)
Experience in data warehousing, large-scale data migration, and transformation
Proficiency in scripting (PowerShell, Python) for automation
Experience with CI/CD pipelines and release automation
Strong understanding of version control and deployment processes
Knowledge of ETL tools such as Informatica and reporting tools like Cognos
Strong analytical and problem-solving abilities
Ability to define technical roadmaps and provide strategic recommendations
Experience with system design, data flow, and data integration practices
Skilled in stakeholder engagement, facilitation, and negotiation
Ability to design solutions aligned with architectural standards and cloud best practices
Experience working with Agile and Waterfall methodologies
Experience with enterprise Power BI deployments (on-premise and cloud)
Strong report design and data visualization capabilities
Data modeling expertise and warehouse architecture design
ETL development including ingestion, cleansing, staging, and integration
Experience creating semantic models and supporting analytics environments
Experience managing production releases and deployment documentation
Ability to troubleshoot and support production environments
Knowledge of change management and environment governance
Hands-on experience with automated testing and rollback processes

Nice To Haves

Relevant Power BI certifications (e.g., PL-300 Power BI Data Analyst) are an asset
Previous public sector experience is considered an asset
Knowledge of information management principles and business analysis practices
Experience with business process modeling and requirements analysis techniques
Awareness of accessibility standards and compliance regulations
Familiarity with CASE tools and documentation frameworks
Understanding of emerging IT trends and technologies
Experience working in large-scale public sector environments

Responsibilities

Develop BI solutions using Microsoft Power BI aligned with industry best practices and established standards
Collaborate with business stakeholders and technical teams to gather and translate requirements into actionable solutions
Lead analysis, design, and development phases of BI initiatives
Ensure seamless integration of new and existing systems, applications, and platforms
Evaluate and recommend appropriate technology stacks, tools, and platforms
Design secure, compliant, and data-privacy-focused solutions
Build scalable and reliable systems optimized for future growth
Provide technical support across development, testing, and production environments
Facilitate communication between technical teams (Dev, QA) and business stakeholders during requirements clarification and UAT
Develop and manage solutions using technologies such as Power BI, MS SQL Server, Oracle, SSIS, .NET, and source control tools
Support release activities, infrastructure updates, and time-sensitive system enhancements
Create and maintain technical documentation including data models, ETL processes, and data dictionaries
Ensure documentation supports auditing, troubleshooting, and compliance
Conduct structured knowledge transfer sessions and ensure documentation is stored in approved repositories
Provide final walkthroughs and ensure continuity of knowledge across teams