BI Developer

Job Title: BI Developer

Job Location: Canada (Remote)

Mode: Contract

Job Description

Role Overview

We are seeking a talented BI Developer to design, develop, and maintain interactive dashboards, analytical models, and reporting solutions. The BI Developer will translate business needs into intuitive visual analytics and help stakeholders make data-driven decisions by transforming complex datasets into meaningful insights.

This role requires strong analytical thinking, BI tool expertise, and the ability to work closely with business teams, data engineers, and data analysts.

Key Responsibilities

1. Dashboard & Report Development

Design and develop dashboards, scorecards, and visualizations using Power BI, Tableau, or similar BI tools.

Build interactive and self-service reporting solutions for business teams.

Create drill down, aggregated, and ad-hoc reports based on business requirements.

2. Data Modeling & Semantic Layer

Develop data models, star/snowflake schemas, fact/dimension tables.

Optimize data models for performance, scalability, and usability.

Create DAX/calculated fields, measures, hierarchies, and KPIs.

3. Requirement Gathering & Analysis

Collaborate with business stakeholders to translate functional requirements into BI specifications.

Convert complex business logic into analytical models and visualizations.

Provide insights, trend analysis, and decision-support analytics.

4. Data Preparation & Validation

Work with data engineers to understand data structures and sources.

Perform data exploration, profiling, and validation for reporting accuracy.

Ensure consistent data quality across BI platforms.

5. Performance Optimization

Optimize dashboards and data models for performance and scalability.

Implement best practices for data refresh, incremental loads, and caching.

Troubleshoot and resolve BI performance issues.

6. Documentation, Training & Support

Document BI solutions, data models, and report logic.

Train business users on self-service analytics and dashboard usage.

Provide ongoing support and enhancements for existing reports.

Required Skills

Strong hands-on experience with Power BI, Tableau, or similar tools.

Expertise in DAX, SQL, data modeling, and relational database concepts.

Experience working with star/snowflake schemas and OLAP concepts.

Strong analytical and visualization skills with attention to detail.

Ability to translate business requirements into technical solutions.

Understanding of ETL/ELT processes and collaboration with data engineering teams.

Preferred Qualifications

Experience with Power BI service, gateways, row-level security (RLS), and workspace management.

Exposure to Python/R for analytics (optional).

Familiarity with Azure Analysis Services or SSAS Tabular (optional).

Good knowledge of Agile methodologies.

Strong communication and stakeholder management skills.