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

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