Senior Business Intelligence Developer

Mississauga, ON, Canada

Full Time

Information Technology

Experienced

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

Apply for this position

Required*

First Name*

Last Name*

Email Address*

Phone*

Address

Resume*

We've received your resume. Click here to update it.

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Are you legally entitled to work in Canada, and can you provide proof of your legal entitlement to work in Canada if requested?*

Are you willing to undergo a background check, in accordance with local law and regulations?*

This role follows a hybrid work model, requiring on-site presence 3 days per week. Are you comfortable with this arrangement?*

Do you have at least 7 years of proven experience in MSBI Suite (SQL, SSIS, SSAS, SSRS)?*

Do you have 5- 7proven experience in T-SQL Programming?*

Do you have experience with Data Vault and Azure Cloud–related applications?*

Human Check*

Submit Application