BI Reporting Specialist

Vantix Systems Inc.

Edmonton, Calgary

On-site

CAD 85,000 - 120,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Vantix Systems Inc. in Edmonton, Canada, is seeking a Reporting & Dashboard Developer to design, build, and maintain SSRS reports and Power BI dashboards that support operational and strategic decisions.

Responsibilities include managing end-to-end report development cycles, refining Power BI datasets and data models, and ensuring reliable production performance of the reporting stack, with strong collaboration across business units.

Qualifications

  • 5+ years hands-on experience with SSRS, Power BI, SQL, and SSIS.
  • Strong understanding of relational databases, data warehousing, and enterprise data management.
  • Experience monitoring and supporting production reporting environments.
  • Ability to work independently and manage competing priorities.
  • Excellent communication with technical and business stakeholders.

Responsibilities

  • Develop and maintain SSRS reports and Power BI dashboards for operational and strategic needs.
  • Manage report development cycles, testing, stakeholder sign-off, and production migration.
  • Refine and maintain Power BI datasets, models, and visualizations.
  • Create visually appealing dashboards beyond standard Power BI basics.
  • Collaborate with business units to gather requirements and prioritize tasks.
  • Support data integration, ETL processes, and data warehouse activities.

Skills

SSRS
Power BI
SQL
SSIS

Job description

Reporting & Dashboard Development
  • Develop and maintain SSRS reports and Power BI dashboards for operational and strategic needs.

  • Manage report development cycles including testing, stakeholder sign-off, and migration to production.

  • Maintain and refine existing Power BI datasets, models, and visualizations.

  • Create visually appealing dashboards beyond the standard Power BI basics.

SQL Development & Source Control
  • Write, review, and optimize SQL queries for reports, dashboards, and ETL processes.

  • Manage BI code repositories, source control, and migration processes across Dev, Test, and Prod environments.

Production Monitoring & Maintenance
  • Support environment monitoring, including Dev/Test resource balancing.

  • Ensure availability and performance of critical reporting infrastructure.

  • Aid in monitoring nightly data refreshes, SSRS report executions, and DW load stability.

Cross-Functional Collaboration
  • Participate in recurring meetings with business units to gather requirements and provide updates.

  • Review and approve changes to data models and support prioritization of report development tasks.

  • Collaborate on BI access reviews, security audits, and production deployment governance.

Data Integration & Warehouse Support
  • Support ETL workflows using SSIS and SQL.

  • Perform daily monitoring and troubleshooting of data pipelines and scheduled loads.

  • Assist with data warehouse support and ongoing data model optimization.

  • 5+ years of hands-on experience with:

    • SQL Server Reporting Services (SSRS)

    • Power BI

    • SQL

    • SQL Server Integration Services (SSIS)

  • Strong understanding of relational databases, data warehousing, and enterprise data management.

  • Experience monitoring and supporting production environments and load processes.

  • Proven ability to work independently while managing competing priorities and deadlines.

  • Effective communicator, comfortable engaging with both technical and business stakeholders.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Scientist
Data Scientist

Cyient Limited • Montreal

On-site
CAD 70,000 - 110,000
Data Reporting Analyst
Data Reporting Analyst

Compunnel Inc. • Southwestern Ontario

On-site
CAD 55,000 - 65,000
RQ09097 - Business Intelligence Specialist - Senior
RQ09097 - Business Intelligence Specialist - Senior

Rubicon Path • Toronto

Hybrid
CAD 80,000 - 110,000
Sr. Report Developer
Sr. Report Developer

DCM Infotech Limited • Toronto

Hybrid
CAD 90,000 - 120,000
Business Intelligence Architect Developer
Business Intelligence Architect Developer

EXL • Canada

On-site
CAD 80,000 - 110,000
Senior Power BI Developer | PowerBI | BI Developer
Senior Power BI Developer | PowerBI | BI Developer

Resource Informatics Group, Inc • Pickering

Hybrid
CAD 80,000 - 110,000
Senior BI Specialist - Power BI & Data Modeling Lead (Hybrid)
Senior BI Specialist - Power BI & Data Modeling Lead (Hybrid)

Rubicon Path • Toronto

Hybrid
CAD 80,000 - 110,000
Senior Power BI Reports Architect (Hybrid)
Senior Power BI Reports Architect (Hybrid)

Rubicon Path • Toronto

Hybrid
CAD 80,000 - 100,000
Power BI Developer
Power BI Developer

BI Control • Halifax

On-site
CAD 75,000 - 90,000
RQ08930 - Business Intelligence Specialist - Senior
RQ08930 - Business Intelligence Specialist - Senior

Rubicon Path • Toronto

On-site
CAD 80,000 - 100,000