25-153 BI Developer

Morson Canada; Oshawa; Remote; CAD 80,000 - 110,000; Full time

Job summary

A leading consulting firm is seeking a BI Developer in Oshawa, ON. This role requires expertise in designing and maintaining semantic data models and BI solutions. Candidates should have over 5 years of experience in BI development and proficiency in Power BI and Azure Synapse. Strong SQL skills are essential, along with experience in data modeling and analytics. The position offers a remote work opportunity with a focus on collaborative data governance.

Qualifications

• 5+ years of experience in BI development focused on enterprise-scale data modeling.
• Certification in Power BI, Azure, or related technologies is an asset.
• Proven expertise in building and managing semantic models in BI tools.

Responsibilities

• Design and build robust and governed semantic data models for enterprise reporting.
• Develop and optimize data models within the enterprise solution stack.
• Engage with stakeholders to gather analytics requirements for data pipelines.

Skills

Power BI

Azure Synapse Analytics

SQL

Data Governance

DAX

Python

Education

Bachelor’s degree in computer science, Information Systems, Engineering, or Mathematics

Tools

Azure

Databricks

Job description

Overview

Title: BI Developer

Resume Due Date: Tuesday, September 23, 2025 (5:00PM EST)

Number of Vacancies: 2

Level: MP4

Duration: 12 months

Hours of work:40

Location: Oshawa, ON (100% remote)

Job Overview

JOB FUNCTIONS:

Semantic Modeling & Enterprise Reporting is responsible for designing, developing, and maintaining enterprise-grade semantic data models and scalable business intelligence solutions aligned with organizational reporting governance and data strategy. This role will ensure that Business Intelligence models and supporting data infrastructure will enable trusted, consistent, and self-service analytics across the organization. This role combines technical expertise in reporting applications such as Power Bl, enterprise data modeling, and cloud data platforms with a deep understanding of data governance and scalable analytics architecture.

Responsibilities

• Semantic Model Development: Design and build robust, reusable, and governed semantic data models, ensuring consistency and scalability for enterprise reporting and self-service analytics.
• Data Platform Integration: Develop and optimize data models within the enterprise solution stack (i.e. Azure, Databricks, Power Bl, etc.) to serve as authoritative sources for Power Bl or similar reporting applications and other Bl tools.
• Alignment with Governance: Collaborate as required with data governance, enterprise architecture, and business teams to ensure all Bl models adhere to data quality, security, and reporting governance frameworks.
• Scalable Architecture: Architect Bl solutions that scale across business units, leveraging best practices in data modeling, partitioning, and performance optimization.
• Requirements Gathering & Translation: Engage with business stakeholders as required to gather analytics requirements and translate them into technical design specifications for semantic models and data pipelines.
• Data Quality & Documentation: Implement as required data validation, lineage tracking, and metadata documentation to ensure transparency, trust, and ease of use for business users.
• Collaboration: Work with data engineers to design data flows and pipelines within existing enterprise technology solution stack (i.e. Azure, Data Bricks, etc.) to ensure seamless integration with the reporting platform.
• User Enablement: Develop and maintain reusable datasets, certified data models, and documentation to support self-service Bl and reduce reporting duplication.
• Continuous Improvement: Stay up to date with advancements in Power Bl, Azure Synapse, Databricks, and enterprise Bl best practices; proactively recommend improvements to data modeling and governance.

Qualifications

• Bachelor’s degree in computer science, Information Systems, Engineering, Mathematics, or a related field.
• Certification in Power Bl, Azure, or related technologies is an asset.
• 5+ years of experience in Bl development, with a focus on enterprise-scale data modeling and reporting.
• Proven expertise in building and managing semantic models in Power Bl or similar tools (including DAX, tabular modeling, and dataset certification).
• Hands-on experience with Azure Synapse Analytics and Databricks for data modeling, transformation, and integration.
• Strong SQL skills and experience working with cloud-based data warehousing solutions.
• Demonstrated experience aligning Bl solutions with data governance, security, and quality standards.
• Experience collaborating with data engineering, governance, and business teams in a cross-functional environment.
• Strong and proven experience with Cl/CD for Power Bl and data models.
• Strong and proven familiarity with data cataloging and lineage tools (e.g., data cataloging software).
• Strong and proven experience with SQL, Python, DAX advanced data transformation.
• Strong and proven knowledge of security models (e.g., row-level security) in Power Bl and Azure.