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.

#J-18808-Ljbffr

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