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)

- Solid 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.

📌 BI Reporting Specialist (Calgary)
🏢 Vantix Systems
📍 Calgary