Business Intelligence Specialist with Cognos expertise for public sector initiative in Toronto. Focus on BI development, data modeling, and reporting using Cognos Analytics, Cloud Pak, and AWS Redshift.
Responsibilities
Gather and document business requirements and develop analysis/design documentation. Build Cognos Framework Manager models and BI business models. Develop and maintain Cognos reports, dashboards, and metadata structures. Implement security models, user groups, and BI object folder structures. Develop reports using Cognos on Cloud Pak for Data with AWS Redshift. Perform testing, debugging, and optimization of reports and dashboards. Develop complex SQL / PL-SQL logic and performance tuning. Support UAT, system implementation, and knowledge transfer to internal teams. Train SMEs and deliver self-serve BI reporting demonstrations.
Requirements
5+ years with Cognos Analytics reporting and modeling. Strong experience with Framework Manager, Dynamic Cube Designer, Transformer, Data Modules, and Datasets. Experience with AWS Redshift and cloud BI environments. Strong SQL / PL-SQL development and performance tuning skills. Experience designing Data Marts / Data Warehouses. Familiarity with Agile / Scrum and tools like JIRA & Confluence. Public Sector experience preferred. Strong analytical and troubleshooting skills. Experience presenting technical solutions to business and technical stakeholders. Detail-oriented professional who thrives in complex enterprise environments.
Senior BI Engineer building data models, semantic layers, and dashboards for Jobber’s small - business service platform. Driving governed self - service analytics and trusted business metrics.
Senior BI Data Engineer building data pipelines, warehouses, and reporting solutions for Trillium Health Partners hospitals. Leading Microsoft BI architecture, integration, and technical delivery.
Business intelligence consultant building Sage Intacct and Sage 300 CRE financial reports. Supporting accounting and operations teams with SQL - integrated, multi - entity reporting solutions.
Senior BI Developer designing SAP Datasphere data solutions for Aecon, an infrastructure construction company. Enabling SAP analytics, integration, governance, and secure enterprise data products.
Senior BI Analyst building Power BI dashboards and data solutions for TD, a global financial institution. Delivering actionable insights through SQL, Databricks, DAX, and Power Query.
Senior Data and BI Engineer building enterprise data lakes, pipelines, and real - time analytics platforms. Supporting utility software provider Systems & Software’s trusted customer insights and operations.
Data Analytics & BI Analyst building dashboards, models, and reporting for CoVet’s AI tools supporting veterinary professionals. Partnering across teams to improve business decisions and data quality.
Business Intelligence Analyst developing data products, dashboards and insights for the Government of Alberta. Supporting data strategy, governance and evidence - based decisions across departments.
Développeur BI chez BEEM, transformant les données d’entreprises en dashboards Power BI et solutions IA. Conception de semantic layers, SQL avancé et livraison de solutions data auprès des clients.