Report Developer - Senior

To apply, please email your resume to careers@lotusit.ca
Ref: RQ09505 Contract - Approx. 8.5 Months 21 College Street, Toronto or 200 First Ave, North Bay (Hybrid – 3 Days Onsite)
Posted Date: July 3, 2025
Location: 21 College Street, Toronto or 200 First Ave, North Bay (Hybrid – 3 Days Onsite)
Public Sector Experience: Justice Technology Services – Ministry of the Solicitor General
Contract End Date: March 31, 2026 *
Rate: $91/hr

The Ministry of the Solicitor General requires a Senior Report Developer to support BI reporting and modernization efforts for the Ministry of Attorney General. This role involves development using Power BI, Azure Data Factory, Databricks, and related technologies.

Key Responsibilities
  • Develop dashboards and reports using Power BI Desktop and Power BI Report Builder
  • Write advanced SQL queries (T-SQL, PL/SQL) and DAX for business logic implementation
  • Work with ETL tools like Azure Data Factory, Databricks, IBM InfoSphere DataStage
  • Participate in requirements gathering, QA, documentation, and knowledge transfer
  • Ensure compliance with accessibility standards (WCAG 2.1 AA)
Must-Have Skills
  • 2+ years with Power BI Desktop and Paginated Report Builder
  • 4+ years with SQL (T-SQL, PL/SQL)
  • 2+ years of DAX experience
  • 2+ years with ETL tools (ADF, Databricks, DataStage)
  • Strong communication, problem-solving, and documentation skills
Engagement Details
  • Start Date: July 21, 2025 | End Date: March 31, 2026
  • Closing Date: July 7, 2025 at 12:00 p.m. EST
  • Work Arrangement: Hybrid (Provisional – 3 Days Onsite)
  • Max Submissions: 1
* Final role details, responsibilities, and terms will be confirmed with shortlisted candidates. Compensation may vary based on experience. Errors and omissions excepted.