Senior Sybase Expert / BI Modernization Consultant
- Mississauga, ON, Canada
$71.25 to $95 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $71.25 to $95 CAD / hour
- Job type
- Contract
- Work location
- Mississauga, Ontario, Canada; Hybrid with 2 days in the office.
- Posting language
- English
- Posted
Original job description
Senior Sybase Expert / BI Modernization Consultant:
On behalf of our client, Procom is searching for a Senior Sybase Expert / BI Modernization Consultant for a 3 to 6 months role. This position is a hybrid position with 2 days onsite at our client’s Mississauga, Ontario office.
Senior Sybase Expert / BI Modernization Consultant - Job Description:
Our client requires a Senior Sybase SME to support an active Power BI deployment initiative. The project involves providing deep expertise in the existing Sybase environment while assisting with data integration, modernization, and transition into the Power BI reporting ecosystem.
Senior Sybase Expert / BI Modernization Consultant - Responsibilities:
- Act as the primary Sybase SME supporting the Power BI deployment.
- Assess and document the existing Sybase environment, data structures, dependencies, and reporting logic.
- Support integration and/or migration of data from Sybase into the Power BI ecosystem.
- Develop, troubleshoot, and optimize complex SQL queries and stored procedures.
- Perform Sybase database performance tuning and troubleshoot data/integration issues.
- Help map legacy data and business logic into the new Power BI reporting environment.
- Validate data accuracy between legacy reports and new Power BI outputs.
Senior Sybase Expert / BI Modernization Consultant - Mandatory Skills:
- 7+ years of database/data platform experience
- 5+ years of hands-on Sybase experience, ideally Sybase ASE and/or Sybase IQ
- Advanced SQL, stored procedures, and query optimization
- Sybase database administration, troubleshooting, and performance tuning
- Experience working with complex enterprise/legacy database environments
- Experience extracting and integrating Sybase data with modern BI/data platforms
- Strong documentation, communication, and knowledge-transfer skills
Senior Sybase Expert / BI Modernization Consultant – Nice-to-Have Skills:
- Power BI development/integration experience
- Power Query / M and DAX
- Microsoft SQL Server
- SSIS / ETL
- Azure SQL
Senior Sybase Expert / BI Modernization Consultant – Assignment Length:
The contract is for 3 to 6 months, with potential extension depending on deployment/migration requirements.
Senior Sybase Expert / BI Modernization Consultant - Start Date:
ASAP
Senior Sybase Expert / BI Modernization Consultant - Assignment Location:
Mississauga, Ontario, Canada; Hybrid with 2 days in the office.
More about this job
Responsibilities
The Senior Sybase Expert will act as the primary Sybase specialist for the Power BI project. They will assess and document the legacy database, write and tune SQL and stored procedures, and move data and business logic into Power BI.
Requirements
Candidates need 7+ years of database experience, including 5+ years hands-on with Sybase ASE and/or IQ. They should be strong in advanced SQL, performance tuning and complex legacy environments, and skilled at documenting and explaining their work.
Skills
- Sybase ASE
- Sybase IQ
- Advanced SQL
- Stored procedures
- Query optimization
- Database performance tuning
- Database administration
- Troubleshooting
- Data integration
- Data migration
- Power BI
- Power Query (M)
- DAX
- Microsoft SQL Server
- SSIS
- ETL
- Azure SQL
- Legacy database analysis
- Technical documentation
- Knowledge transfer
Categories
- Technology
- Data & Analytics
- Software
- Consulting
Keywords
- Sybase
- Sybase ASE
- Sybase IQ
- Power BI
- SQL
- stored procedures
- query optimization
- performance tuning
- database administration
- data migration
- data integration
- ETL
- Power Query
- DAX
- Microsoft SQL Server
- SSIS
- Azure SQL
- business intelligence
- BI modernization
- legacy systems
Seniority
Senior
Tools
- Sybase ASE
- Sybase IQ
- Power BI
- Microsoft SQL Server
- SSIS
- Azure SQL
Languages
- English