About the Opportunity

We are seeking an experienced Senior Sybase Expert / BI Modernization Consultant to support a Power BI deployment initiative.

As the primary Sybase subject matter expert, you will assess the existing database environment, resolve technical challenges, and support data integration and modernization. You will work closely with IT, operations, and Power BI delivery teams to ensure legacy data and reporting logic are accurately transitioned into the new reporting environment.

Key Responsibilities

- Assess and document the existing Sybase environment, including data structures, dependencies, stored procedures, and reporting logic.
- Support the extraction, integration, and migration of Sybase data into the Power BI reporting ecosystem.
- Develop, troubleshoot, and optimize complex SQL queries and stored procedures.
- Perform Sybase database performance tuning and resolve database and integration issues.
- Map legacy data and business logic to current reporting requirements.
- Validate data accuracy and consistency between legacy reports and Power BI outputs.
- Support testing, migration, cutover, and post-deployment stabilization.
- Collaborate with Power BI, data, infrastructure, and application teams.
- Prepare technical documentation and provide knowledge transfer to internal teams.

Required Qualifications

- 7+ years of database or data platform experience.
- 5+ years of hands-on Sybase experience,



ideally with Sybase ASE and/or Sybase IQ.
- Advanced proficiency in SQL, stored procedures, and query optimization.
- Strong experience in Sybase administration, troubleshooting, and performance tuning.
- Experience working with complex enterprise and legacy database environments.
- Experience extracting and integrating Sybase data with modern BI or data platforms.
- Experience supporting database migration or modernization initiatives.
- Strong understanding of data modelling, ETL processes, and data validation.
- Ability to independently assess legacy environments and identify technical dependencies.
- Strong communication, documentation, and knowledge-transfer skills.

Preferred Qualifications

- Power BI development or integration experience.
- Familiarity with Power Query, M, DAX, Power BI gateways, and on-premises connectivity.
- Experience with Microsoft SQL Server, SSIS, Azure SQL, or Azure Data Factory.
- Exposure to Microsoft Fabric or Azure Synapse.
- Experience migrating Sybase databases to SQL Server or Azure.
- Knowledge of data warehousing and dimensional modelling.
- Transportation or logistics industry experience.
- Relevant SAP/Sybase or Microsoft data certifications.

The downstream data platform is still being finalized. Experience with Microsoft data technologies beyond Power BI is an asset.

Pay: $80.00 per hour

Work Location: Hybrid remote in Mississauga, ON

📌 Senior Sybase Expert / BI Modernization Consultant (Mississauga)
🏢 Ultimate HR
📍 Mississauga