Title

Report Developer

Assignment Type: Onsite, 7.25 hours/day between 8:00 AM–5:00 PM, Monday–Friday.

Scope

- Provide planning, assessment, and development effort for BI reporting enablement supporting Ministry of Attorney General program areas.
- Collaborate with Project Manager and business areas to evaluate requirements, model/process data (ETL & warehousing), and develop reports/dashboards/visualizations using Power BI Desktop and Report Builder.
- Ensure QA and compliance with WCAG 2.1 Level AA.
- Complete documentation, knowledge transfer, and communication to support project completion.

Deliverables
- Participate in requirements gathering.
- Define approach with project team/stakeholders to deliver BI solutions.
- Perform data modelling and pipelines using Azure Data Factory and Databricks.
- Design/develop reports/dashboards in Power BI Desktop or Report Builder.
- Troubleshoot and resolve BI issues during testing.
- Provide documentation for migration and knowledge transfer.
- Participate in KT activities.

Mandatory Requirements
- Power BI Desktop & Paginated Report Builder (≥2 yrs).
- SQL query languages (T-SQL, PL-SQL) (≥4 yrs).
- DAX programming (≥2 yrs).
- ETL tools (Azure Data Factory, Databricks) & data modelling (≥2 yrs).

Nice-to-Have
- Troubleshooting BI/reporting issues with SQL queries.
- Data analysis for quality issues and validation.
- Team-based troubleshooting/problem resolution.
- Solid oral/written communication,



facilitation, interpersonal skills.
- Experience preparing documentation.

Desired Skills
- BI team experience delivering reports/dashboards.
- Power BI Desktop & Report Builder for design/redesign.
- Writing DAX for business logic.
- Troubleshooting SQL queries, BI reports, and validation.
- Knowledge of SQL Server & Oracle.
- Familiarity with ETL tools (Azure Data Factory, SSDT, IBM InfoSphere DataStage).

Resume Evaluation Criteria

Technical Knowledge (50 pts):

- T-SQL (≥4 yrs).
- Power BI Desktop & Report Builder (≥2 yrs).
- DAX, data modelling (≥2 yrs).
- ETL tools (≥2 yrs).

Analytical/Problem-Solving (30 pts):

- Troubleshooting BI/reporting issues.
- Data analysis & validation.
- Team-based technical problem resolution.

Communication (20 pts):

- Oral/written communication, facilitation, interpersonal skills.
- Team contributions: progress updates, risk/issues communication, explaining technical tasks to non-technical members.
- Documentation experience.

Knowledge Transfer What: Documentation of designs, vendor/internal solutions, best practices, lessons learned, codes, scripts, PBIX files. To Whom: Project Manager / Team members. When: Ongoing via meetings and SharePoint during project lifecycle.

Contract Notes

- VOR Master Service Agreement expires April 5, 2027, with survival clause until Oct 5, 2027.
- Extensions only via unused days/funds.

📌 Report Developer | Power BI, SQL (T-SQL/PL-SQL), DAX, ETL (Azure Data Factory, Databricks), Data Modeling, BI Dashboards
🏢 CCI- Computer Consultants International
📍 Toronto