Business Intelligence Specialist Senior

Connvertex Technologies Inc.; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading technology firm in Toronto is seeking a skilled Power BI Report Developer to design and develop business intelligence reports and dashboards. Responsibilities include data modeling, report creation, and stakeholder collaboration. Candidates must have at least 5 years of relevant experience and expertise in Microsoft Power BI, SQL Server, and data management. This role offers competitive compensation and requires full-time commitment.

Qualifications

• At least 5 years of experience in Power BI development.
• Strong understanding of data analysis and management.
• Ability to manage stakeholder expectations effectively.

Responsibilities

• Design data models that are intuitive and high-performing.
• Create and format Power BI reports.
• Connect Power BI reports to various data sources.

Skills

Proven work experience as a Power BI Report Developer

Demonstrated experience with M, DAX, and Power Query

Knowledge of Microsoft Azure ecosystem

Proven experience with SQL Server

Data modeling and data visualization skills

Excellent verbal and written communication skills

Tools

Power BI

SQL Server

Azure

Job description

Experience and Skill Set Requirements

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
• Knowledge of Microsoft Azure ecosystem
• 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

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.

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 Power BI report designs and report formatting including report navigation.
• Examine, sort, and present data using Power BI in a cohesive manner.
• Connect Power BI reports to on-premise data sources.
• 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.
• Knowledge of data analysis data management.
• Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop 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.

Criteria Ratings

Criteria 1: Technical Skills

• 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.
• 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.

Criteria 2: 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 a 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.

Knowledge Transfer

• Knowledge to be transferred (at the end of the contract):
• Completed deliverables details.
• Processes used for developing the deliverables.
• Power BI models.
• All source code created in development of deliverables.
• Knowledge to be transferred to: Team lead / Team members.
• Details of transfer: 1:1 meetings / team meetings / throughout the duration of the project life cycle etc.

Key Skills

• Business Intelligence
• Cognos
• SQL
• Power BI
• QlikView
• Data Visualization
• SSRS
• Tableau
• SSIS
• Data Modeling
• Data Warehouse
• Data Analysis Skills

Employment Type: Full Time

Experience: years

Vacancy: 1