BI Reporting Specialist

Vantix Systems Inc.; Edmonton, Calgary; On-site; CAD 85,000 - 120,000; Full time

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.