The Ontario government is currently seeking a BI Specialist for a crucial project focused on migrating 13 billing services from IBM InfoSphere DataStage to Azure Data Factory. The project also involves the assessment and migration of approximately 136 billing reports developed within IBM Cognos Report Studio (v11.0.6) to Microsoft Power BI Desktop or Power BI Report Builder.
Demonstrated working knowledge of IBM Cognos Report Studio (version 11 or earlier) [At least 5 years of experience]
Demonstrated working knowledge of Power BI Desktop [At least 2 years of experience]
Demonstrated working knowledge of SQL query languages (T-SQL, PL-SQL) [At least 4 years of experience]
Demonstrated working knowledge of DAX programming (At least 2 years of experience)
The successful candidate will play a vital role in the technical migration phase of this effort, contributing their expertise to ensure a seamless transition and optimization of billing services and reports within the new Azure environment.