Job Title: Universe Designer
Duration: 4 months
Possibility of Extension/Conversion: Yes (TBD)
Location: Downtown Toronto – Sheppard/North York (Atria). Preference for North York, but Waterloo is acceptable.
1. Hybrid – expected onsite once per month for town halls and monthly team events (subject to change).
2. Work Hours: Monday–Friday, flexible between 8:00–4:00, 8:30–4:30, or 9:00–5:00. Start time must be no later than 9:00 AM.
*Must be eligible for Reliability Status Clearance (must have been in Canada for last 5 years and not traveled for a period longer than 6 months at a time)
Role Overview
This is a specialized role focused on building the GRS Universe. The position does not involve data analysis. The ideal candidate will have strong experience designing, building, testing, and implementing SAP BusinessObjects Universes. The team is currently working with legacy platforms (including mainframe) and is transitioning components off mainframe into modern environments. Experience with ETL tools and data warehouse/BI ecosystems is important.
Key Responsibilities
3. Lead the initiative end-to-end (status updates, time tracking, coordination).
4. Collaborate with business partners and DAOP to gather requirements.
5. Build the GRS Universe.
6. Test the GRS Universe.
7. Create documentation.
8. Support implementation activities.
9. Train DAOP on the Universe (structure, potential changes, maintenance).
Required Skills & Experience
SAP Tools:
10. BusinessObjects Universe Designer
11. Web Intelligence Developer
Databases:
12. SQL Server
13. DB2
14. Oracle and flat files
Experience:
15. 5+ years hands-on IT Application/Technical Support
16. 2–3+ years ETL experience (Informatica PowerCenter or IDMC – nice to have)
17. 2–3+ years in Data Warehouse / BI environments
18. Technical Knowledge:
19. Strong understanding of SAP tools: Business Objects Universe Designer and Web Intelligence
20. Ability to map technical SQL/data structures into business-friendly semantic layers
21. Windows and Unix experience
Ideal Candidate Profile: Someone who has previously built Universes from scratch, understands semantic layer design deeply, and can translate SQL-based technical data into business terms. Experience in enterprise environments (SAP, financial industry) is preferred.
Interview Process
· 1 interview – virtual