Overview
Senior System Analyst Jobs in Winnipeg, Manitoba, Canada at TEEMA
Title: Senior System Analyst
Company: TEEMA
Location: Winnipeg, Manitoba, Canada
Senior Systems Analyst (Contract) –
Winnipeg, MB (Hybrid) 1–2 days onsite per week
6-month contract with potential extensions
Candidates must be based in the area or willing to relocate for the duration of the contract.
What You’ll Do
You’ll join a Data & Analytics initiative focused on transitioning reporting systems from a legacy Operational Data Store (ODS) to modern data platforms.
Key responsibilities include:
- Analyze existing reports and collaborate with business stakeholders to understand their purpose
- Reverse engineer SQL queries and identify required data sources
- Redesign SQL to align with new data sources (e.g., Data Warehouse, Data Lake)
- Create detailed specifications for report redevelopment
- Support development teams by providing clear documentation
- Perform unit testing and coordinate business validation
- Assist with deployment of reports to production environments
Key Requirements
- 10+ years as a Systems or Data Analyst
- 10+ years of experience with Oracle SQL
- 10+ years of PL/SQL development experience
- 10+ years working with Microsoft SQL Server (Cloud)
- 5+ years of experience with T-SQL and SQL Server
- Experience with Microsoft Azure
- Experience developing reports with Power BI
- Strong analytical and problem-solving skills
- Excellent communication (written and verbal)
Nice-to-Have
- Experience with Argos reporting tools
- Experience in a Higher Education environment
- Experience working with Solution Architects
- Familiarity with PRINCE2 or Agile methodologies
What You’ll Deliver
- Documentation of existing report logic and data structures
- Migration specifications for transitioning reports to new platforms
- Validated and tested reports ensuring accuracy and performance
- Knowledge transfer documentation to support ongoing operations