BI Reporting Specialist

Vantix Systems Inc.; Calgary, Edmonton; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading company in the data solutions sector seeks a seasoned professional for reporting and dashboard development. In this role, you will focus on developing and maintaining SSRS reports and Power BI dashboards while managing report cycles, data integration workflows, and cross-functional collaborations. Ideal candidates will possess strong SQL, SSRS, and Power BI expertise, with a proven ability to engage effectively with technical and business stakeholders.

Qualifications

• 5+ years of hands-on experience with SSRS, Power BI, SQL, SSIS.
• Strong understanding of relational databases and data warehousing.
• Proven ability to work independently and manage competing priorities.

Responsibilities

• Develop and maintain SSRS reports and Power BI dashboards.
• Write, review, and optimize SQL queries for reports.
• Support ETL workflows using SSIS and SQL.

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.