Senior Business Intelligence Developer

Mevotech; Mississauga; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading technology company in Canada is seeking a Senior Business Intelligence Developer to drive BI development projects. The role involves creating BI solutions, developing dashboards, and maintaining data models. Ideal candidates should have 7+ years of experience in the MSBI Suite and demonstrate strong skills in SQL and Power BI. This position offers a hybrid work setting, combining both remote and office work, alongside a fast-paced environment emphasizing detail and problem-solving.

Qualifications

• 7+ years of proven experience in MSBI Suite (SQL, SSIS, SSAS, SSRS).
• 5–7+ years of proven experience in T-SQL Programming.
• Proven hands-on experience with Power BI Development.

Responsibilities

• Create and implement BI solutions, including integration with databases.
• Develop dashboards, reports, and visualizations for data presentation.
• Document cube structure, data sources, and dependencies.

Skills

SQL

SSAS

SSIS

SSRS

Power BI

T-SQL Programming

Data governance

Problem-solving

Attention to detail

Education

Post-secondary degree in Computer Science or a related discipline

Tools

Azure Data Factory

Snowflake

Job description

Job Purpose

Reporting directly to the Manager, BI & Analytics, the Senior Business Intelligence Developer will be responsible for helping drive the success of our Business Intelligence development projects across functional teams within the organization. The ideal candidate will have a strong background in BI Development Stack such as SQL, SSAS, SSIS & SSRS. Also, extensive experience with Power BI and Snowflake would be valuable to build reports and dashboard for business users as well as data ingestion using Azure Data Factory. The incumbent will have a keen eye for detail and a commitment to delivering end to end solutions.

Key Duties and Responsibilities

• Create and implement BI solutions, including integration with databases and data warehousing.
• Develop dashboards, reports, and visualizations to present complex data in an understandable and actionable format.
• Review and analyze the existing SSAS (tabular and/or multidimensional) cubes to understand current data models, calculations, and business logic.
• Document cube structure, data sources, and dependencies to support accurate assessment of the existing SSAS environment.
• Build and maintain data models to ensure the accuracy and relevancy of the data.
• Oversee data extraction, transformation, and loading from various sources in data warehouse.
• Work closely with stakeholders to understand their data needs and translate business requirements into technical solutions.
• Provide ongoing support and training to users on BI tools and data analytics.
• Perform regular maintenance and updates to existing BI solutions to enhance functionality and incorporate new data sources or analytics capabilities.
• Create and maintain technical documentation for new and existing BI solutions and legacy systems mappings.
• Ensure the accuracy, completeness, and reliability of the data used for analysis.
• Implement data governance policies and practices.

Qualifications, Skills, and Educational Requirements

• Post‑secondary degree in Computer Science or a related discipline
• 7+ years of proven experience in MSBI Suite (SQL, SSIS, SSAS, SSRS)
• 5–7+ years of proven experience in T‑SQL Programming
• Proven hands‑on experience with Power BI Development and Azure Data Factory
• Data Vault & Azure Cloud related app knowledge required
• Snowflake development is an asset
• Relevant certifications or training in MSBI applications
• Strong problem‑solving skills and attention to detail
• Excellent written and verbal communication skills

Physical Demands and Working Conditions

• Standard office setting – hybrid arrangement
• Sitting for extended periods of time
• Fast paced office environment