Design and build Power BI reports, datasets and data models. Extract, profile, clean and load data using Power Query and SQL Server. Partner with stakeholders to capture requirements, ensure IT standards, support testing/UAT, and perform knowledge transfer. Perform performance tuning, refresh management and deliver documentation and visualizations for varied audiences.
Deliverables:
- Create Power BI report(s), data models
- Undertake special assignments/sub-projects as assigned
- Conduct, assess, evaluate and document stakeholder interests
and business needs
- Ensure alignment and adherence to IT processes and standards
- Support the testing team during system and UAT testing
- Participate in Knowledge transfer
Skills and Knowledge:
- Proven experience as a Microsoft Power BI developer,
building Business Intelligence reports and dashboards
- Demonstrated experience with M, DAX and Power Query
- Demonstrated knowledge and experience with Microsoft Azure
ecosystem, Power BI service, Azure Datafactory, SQL Server
- Proven experience with SQL Server and other database
technologies
- Proven, demonstratable experience in data modeling and data
visualization; working with different data schemas and BI implementation
methodologies
- Knowledge of data analysis, data management
- Proven ability to partner with internal/external
stakeholders and liaise with technical experts and non-technical colleagues
- Experience in understanding, capturing, and analyzing
complex and sometimes competing business requirements to develop Power BI and
Business Intelligence products
- Excellent verbal and written communication skills,
interpersonal and facilitation skills
- Strong written, presentation and interpersonal communication
skills with special attention to correct use of tense, grammar/spelling and
terminology
- Demonstrated effective time management and organizational
skills, including the ability to plan and prioritize workload, ensuring
timelines are met and respond to demands of a dynamic environment
- Mandatory Requirements: At least 5 years of experience
- All roles procured are required to be cleared through the
Contractor Security Clearance Process of the OPS.
- Security Clearance process, levels, roles etc. are subject
to change without prior notice. Candidates may be required to undergo
revised/new process (or levels) any time prior or during the term of the
contract.
Requirements
Experience and Skill Set Requirements:
Must Haves:
- Proven work experience as a Power BI Report Developer
- Demonstrated experience with M, DAX and Power Query
- Knowledge of Microsoft Azure ecosystem and the Power
Platform
- Proven experience with SQL Server and Power BI Datasets
- Proven, demonstratable experience in data modeling and data
visualizations for Power BI; working with different data schemas and BI
implementation methodologies
Skill Set Requirements:
Mandatory Requirements:
- Use Power Query to extract data from different data sources
and choose a storage mode and connectivity type.
- Profile, clean, and load data into Power BI
- Design data models that are intuitive, high-performing, and
simple to maintain
- Create compelling Power BI report designs and report
formatting, including report navigation for all audience types (executive,
operational)
- Examine, sort and present data using Power BI in a cohesive
manner
- Connect Power BI reports to data sources
Technical Skills:
- Proven work experience as a Power BI Report Developer
- Demonstrated experience with M, DAX and Power Query
- Demonstrated knowledge of Microsoft Azure ecosystem and the
Power Platform, including Azure Data Factory
- Proven experience with SQL Server and Power BI Datasets
- Proven, demonstratable experience in data modeling and data
visualizations for Power BI; working with different data schemas and BI
implementation methodologies
- Knowledge of data analysis, data management
- Experience in understanding, capturing, and analyzing
complex and sometimes competing business requirements to develop Power BI and
Business Intelligence products
- Demonstrated experience with performance tuning in Power BI
including measures, relationships and visuals
- Demonstrated experience with data sources for Power BI
including DirectQuery, Import and appropriate Considerations and limitations
- Demonstrated experience with Power BI datasets
- Demonstrated experience with Power BI refresh
Documentation, Collaboration & Communication Skills:
- Ability to partner with internal/external stakeholders and
liaise with technical experts and non-technical colleagues, regarding project
deliverables
- Proven experience in developing documentation
- Demonstrated experience collaborating with Developers,
Testers and Program Managers
- Proven experience in producing diagrams, videos, and other
visual content
- Experience analyzing customer feedback and responding to it
to improve the customer experience
- Experience in bringing clarity to complex business
challenges and conflicting articulation of business issues through techniques
that result in common understanding of the issues, as well as agreement on
business process requirements vs technology requirements to solve the issues.
- Experience in understanding, capturing, and analyzing
complex and sometimes competing business requirements to develop Business
Intelligence products
- Excellent verbal and written communication skills,
interpersonal and negotiation skills
- Facilitation skills, Interpersonal and consultative skills
- Stakeholder management skills. Demonstrated strong
problem-solving and organizational skills
- A team player with a track record for meeting
deadlines.
- Working knowledge and experience developing reports for use
by a wide spectrum of stakeholders
- Strong written, presentation and interpersonal communication
skills with special attention to correct use of tense, grammar/spelling and
terminology.
- Demonstrated effective time management and organizational
skills, including the ability to plan and prioritize workload, ensuring
timelines are met and respond to demands of a dynamic environment
Similar Jobs
Fintech • Machine Learning • Payments • Software • Financial Services
Leads multiple software engineering teams developing full-stack customer management capabilities for international card users. Responsibilities include people leadership, talent and succession planning, hands-on development, application craftsmanship, availability, resilience, scalability, fraud reduction, customer experience improvement, technology innovation, and mentoring. The role requires extensive software engineering experience, agile leadership, stakeholder influence, and knowledge of secure, highly available continuous-delivery practices.
Top Skills:
Automated TestingAWSCi/CdFull-Stack Software DevelopmentGCPAzure
Fintech • Machine Learning • Payments • Software • Financial Services
Build and maintain features for a mobile Open Banking Connected Accounts Dashboard across frontend and backend systems. Responsibilities include writing clean code, participating in design sessions and code reviews, conducting unit, component, and integration testing, joining Agile ceremonies, collaborating with product and UX teams, and learning AWS cloud infrastructure. The role involves mobile interfaces, RESTful APIs, microservices, and cloud-native development.
Top Skills:
Aws AuroraAws Ecs FargateAws LambdaClaude CodeCloudfrontCloudwatchDockerDynamoDBGitIam RolesIntellijJavaJavaScriptJenkinsKotlinMavenMicroservicesMySQLNew RelicOnepipelineRestful ApisS3Security GroupsSplunkSpring BootSqsSwiftVscodeWindsurf
Fintech • Machine Learning • Payments • Software • Financial Services
Develop full-stack features for an internal onboarding tool across frontend, backend, databases, infrastructure, testing, deployment, monitoring, and cybersecurity. Collaborate throughout the software development lifecycle, participate in Agile ceremonies, conduct design and code reviews, document technical work, and collaborate with Product and Analyst stakeholders. The role includes learning AWS cloud infrastructure and contributing to requirements definition, system architecture, and continuous improvement.
Top Skills:
Amazon Route 53Amazon S3Api DesignAWSAws IamAws LambdaAws Security GroupsClaudeGitIntellijJavaJenkinsMicroservicesNode.jsOnepipelineOpenspecPostgresReactVscodeWindsurf
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.

