RQ08739 - Business Intelligence Specialist - Senior

3 weeks ago


Toronto, Canada Rubicon Path Full time

RQ08739 - Business Intelligence Specialist - Senior Job Openings RQ08739 - Business Intelligence Specialist - Senior About the job RQ08739 - Business Intelligence Specialist - Senior Responsibilities: Document the new requirements and complete analysis and design document Convert the user requirements into business model for Cognos BI Convert the business model into Framework Manager Models Build the security model for the BI implementation Create metadata, user groups and folder structure for BI objects Develop reports in Cognos on Cloud Pak for Data and AWS Redshift database Test, debug, re-engineer standard reports and dashboards in Cognos on AWS Support converted Dynamic Cubes functionality in DMR or Transformer Cubes without any loss in performance Document test cases to ensure expected functionality of the reports Deploy reports using Cognos Framework Manager Develop SQL and PLSQL process and procedures to implement complex logic. Assist with SQL tuning and optimization activities related to the Cognos reports. Help to optimize the SQL and PL/SQL process for optimal report performance. Prepare scripts and documentation for the data preparation process and regular performance checks & monitoring. Support user acceptance testing and system implementation. Train SMEs or conduct demos on self-serve BI reporting. Any other deliverables as assigned by the Project/Resource Manager. Knowledge transfer to HSC staff in the form of a detailed guide or as per project requirements. SkillsExperience and Skill Set Requirements Public Sector Experience Experience working in the Public Sector and familiarity with I&IT project management processes. Technical Skills Experience in design and development of Data Marts or Data Warehouses on a wide range of data repositories (relational and multi-dimensional data stores). Experience in Cognos Analytics reporting; modeling with Framework Manager, Transformer, Dynamic Cube Designer, Data Module, Dataset, SDK; implementing point-in-time architecture; testing with Life Cycle Manager (5+ years) Excellent requirements analysis skills Demonstrated experience in working with Power Designer Tool to design logical and physical models, generating scripts and applying model changes. Knowledge of BI architecture patterns, best practices, processes, and artefacts Experience developing Cognos reports in the IBM Cloud Pak for Data environment. Core skills, database and domain knowledge Experience in Oracle 19 or higher including writing complex SQL/PL SQL queries and materialized views. Experience in AWS Cloud technologies, specifically AWS Redshift Experience in database performance and tuning skills Experience with Agile/scrum and waterfall methodologies, using tools such as JIRA and Confluence. General Skills Proven troubleshooting and critical thinking skills. Strong interpersonal skills with ability to work with client stakeholders to understand, interpret business requirements and its technical implications. Demonstrated ability to present technical solutions to client stakeholders, technical staff and to senior management. A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines. MUST HAVES Experience in AWS Cloud technologies, specifically AWS Redshift #J-18808-Ljbffr



  • Toronto, Canada Rubicon Path Full time

    RQ08739 - Business Intelligence Specialist - Senior Job Openings RQ08739 - Business Intelligence Specialist - Senior About the job RQ08739 - Business Intelligence Specialist - Senior Responsibilities: Document the new requirements and complete analysis and design document Convert the user requirements into business model for Cognos BI Convert the business...


  • Toronto, Canada Rubicon Path Full time

    RQ08739 - Business Intelligence Specialist - Senior Job Openings RQ08739 - Business Intelligence Specialist - Senior About the job RQ08739 - Business Intelligence Specialist - Senior Responsibilities: Document the new requirements and complete analysis and design document Convert the user requirements into business model for Cognos BI Convert the business...


  • toronto, Canada Randstad Full time

    We are seeking a highly proficient Senior Business Intelligence Specialist with at least 5 years of proven experience as a Microsoft Power BI Developer. This role is essential for the successful release of Business Intelligence reporting, focusing on end-to-end data preparation, modeling, visualization, and deployment within the Power BI and Azure...


  • toronto, Canada Randstad Full time

    We are seeking a highly specialized Senior Business Intelligence Specialist with in-depth knowledge and experience in Cognos Analytics v12.x. This role is crucial for designing, developing, and optimizing Cognos reports and dashboards, specifically leveraging IBM Cloud Pak for Data and AWS Redshift. The specialist will translate user requirements into...


  • Toronto, Canada Amica Senior Lifestyles Full time

    Job Description: **About Us** Amica Senior Lifestyles is setting a new standard for senior living in Canada by combining unparalleled premium hospitality and amenities with expert care and support to deliver a personalized senior living experience. Committed to enriching the lives of seniors now and as their needs change, Amica offers Independent Living...


  • toronto, Canada Randstad Full time

    Do you have proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features? Do you have demonstrated experience with data analytics and reporting from Dynamics 365 CE and/or F&O? If so, this would be a great opportunity for you!Our client is looking for a Senior Business Intelligence Specialist...


  • Toronto, ON, Canada 2iSolutions Inc. Full time

    Our client is seeking a Senior Business Intelligence Specialist for a 4-month contract in Toronto, ON. This is a hybrid role. Must haves: In-depth knowledge and experience with Cognos report development in Cognos Analytics v12.x (reporting, dashboarding, embedded JavaScript, embedded SQL). Demonstrated experience in working with Power Designer Tool to design...


  • Toronto, Ontario, Canada 2iSolutions Inc. Full time $80,000 - $120,000 per year

    We are seeking a Senior Business Intelligence Specialist for a 10-month contract opportunity in Toronto, ON. This is an onsite role.Must haves:Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features.Demonstrated experience with data analytics and reporting from Dynamics 365 CE...


  • Toronto, Canada Itexpertus Full time

    **Job Title: Business Intelligence Specialist - Junior** **Location: Toronto, ON M5G2C8** **Contract** **Description**: **Required Knowledge / Skills**: **Key deliverables to be performed by the Business Intelligence Specialist role include, but are not limited to, the following**: - Supports Client’s wide-ranging business information requirements,...


  • Toronto, Ontario, Canada 2iSolutions Inc. Full time $80,000 - $120,000 per year

    **If interested please share your latest resume on RQ Business Intelligence Specialist - SeniorLocation:**Onsite / 595 Bay Street, TorontoStart Date: End Date: Duration: 10-monthMust HavesPower BI:Proficiency in Power BI, includingdata modeling,creating interactive reportsanddashboards, and utilizing advanced features.Demonstrated experience with data...