Job Title: Senior Sybase Expert / BI Modernization Consultant
Job Type: 2.5-month Contract (392 hours, approx. 10 weeks; possibility of extension)
Location: Mississauga, Ontario (hybrid)
Start Date: November 16, 2026
Schedule: Monday to Friday, 40 hours/week, 8 hours/day
Pay Rate: $70/hr T4 OR $85/hr Inc
Job Overview
Our client seeking a highly experienced Senior Sybase Expert/BI Modernization Consultant to support with an active Power BI deployment initiative. The successful candidate will serve as the primary Sybase Subject Matter Expert (SME), bringing extensive experience working with legacy Sybase database environments, complex SQL queries, database optimization, and enterprise data integration. This individual will help bridge our client’s existing Sybase infrastructure with its evolving Power BI reporting environment, supporting data extraction, integration, modernization, migration, and validation activities. The ideal candidate will be comfortable independently assessing complex legacy database environments, identifying dependencies, troubleshooting performance issues, and collaborating with Power BI developers and broader IT teams.
Key Responsibilities:
Sybase Database Expertise
- Act as the primary Sybase SME supporting the Power BI deployment.
- Assess and document existing Sybase database environments, structures, dependencies, and reporting logic.
- Troubleshoot and optimize Sybase database performance.
- Develop, troubleshoot, and optimize complex SQL queries and stored procedures.
- Identify database dependencies and potential challenges within legacy environments.
Data Integration & BI Modernization
- Support the extraction and integration of data from Sybase into the Power BI ecosystem.
- Map legacy data structures and business logic into the new reporting environment.
- Collaborate with Power BI developers and data resources to support reporting requirements.
- Validate data accuracy between legacy reports and new Power BI outputs.
- Troubleshoot data inconsistencies and integration issues.
Migration & Project Support
- Support database migration and modernization activities.
- Assist with testing, deployment, cutover, and post-implementation stabilization.
- Work alongside Loomis IT, infrastructure, application, and Power BI delivery teams.
- Provide technical documentation and knowledge transfer to internal Loomis resources.
Required Qualifications
- 7+ years of database and data platform experience.
- 5+ years of hands-on Sybase experience, ideally Sybase ASE and/or Sybase IQ.
- Advanced SQL development, stored procedures, and query optimization experience.
- Strong Sybase database administration, troubleshooting, and performance tuning capabilities.
- Experience working within complex enterprise and legacy database environments.
- Experience extracting and integrating Sybase data into modern BI or data platforms.
- Previous involvement in database migration or modernization initiatives.
- Understanding of data modelling, ETL processes, and data validation.
- Ability to independently assess legacy database environments and identify dependencies.
- Strong documentation, communication, and knowledge-transfer skills.
Preferred Qualifications
- Power BI development and integration experience.
- Power Query (M) and DAX.
- Microsoft SQL Server.
- SQL Server Integration Services (SSIS) and ETL.
- Azure SQL.
- Azure Data Factory.
- Microsoft Fabric and/or Azure Synapse.
- Experience migrating Sybase databases to SQL Server or Azure.
- Data warehousing and dimensional modelling.
- Power BI gateways and on-premises connectivity.
- Previous experience within the transportation or logistics industry.
Note: Azure, Microsoft Fabric, Synapse, and SQL Server are preferred qualifications only. The confirmed downstream Microsoft data architecture has not yet been established.
