Data Analytical Specialist/Scientist
To apply, please email your resume to
careers@lotusit.ca
Ref: RQ09504
Contract - Approx. 6 Months
21 College Street, Toronto (Hybrid – 3 Days Onsite)
Posted Date: July 03, 2025
Location: 21 College Street, Toronto (Hybrid – 3 Days Onsite)
Public Sector Experience: Justice Technology Services – Ministry of the Solicitor General
Contract End Date: March 31, 2026 *
Rate: $83/hr
The Ministry of the Solicitor General seeks a Senior Data Analytical Specialist to join Justice Technology Services. The role supports advanced data analytics and business intelligence development, with a focus on Microsoft Azure platforms and Power BI. This position will contribute to projects like the SOLGEN Inspectorate of Policing and other ministry data initiatives.
Key Responsibilities
- Design and implement data pipelines, ETLs/ELTs, and data lake/lakehouse architectures
- Develop and maintain business intelligence dashboards using Power BI
- Conduct stakeholder interviews, gather requirements, and document findings
- Provide subject matter expertise on analytics strategy, data visualization, and solution optimization
- Support development, UAT testing, training sessions, and knowledge transfer
Must-Have Skills
- 5+ years of experience as a Data Engineer or ETL Developer
- Expertise in Azure Data Factory, Azure Synapse, Databricks, Power BI
- Strong SQL skills across Microsoft SQL Server, Snowflake, Databricks Delta Lake
- Experience with business intelligence solution lifecycles
- Excellent documentation, presentation, and collaboration abilities
Engagement Details
- Start Date: October 6, 2025 | End Date: March 31, 2026
- Closing Date: July 7, 2025 at 12:00 p.m. EST
- Work Arrangement: Hybrid (Provisional Onsite, 3 Days/Week)
- Security Clearance: OPP Level 4 (must be obtained before start)
- 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.