Business Intelligence 7234-2111

2 weeks ago

Toronto, Ontario, Canada Foilcon Full time

Description:

A Senior Business Intelligence Specialist with strong Cognos development and AWS Redshift experience.

The resource will help the client with the following tasks:

  • Mentor and support our Cognos developers in their transition to Cloud version
  • Help with Cognos reports code conversion from onpremises environment to CP4D on AWS
  • Update embedded SQL code in Cognos reports from Oracle to AWS Redshift
  • Support the issues encountered during Cognos migration
  • Provide knowledge transfer to other team members as needed.

Responsibilities:

  • Prepare a detailed BI user requirement document
  • 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
  • Migrate standard reports from Cognos v11.1 onpremises to Cognos v11.2 on Cloud Pak for Data on Amazon Web Services (AWS)
  • Develop reports in Cognos on Cloud Pak for Data and AWS Redshift database
  • Test, debug, reengineer standard reports and dashboards in Cognos on AWS
  • Convert Dynamic Cubes functionality to 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 selfserve 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.

Skills:

Experience and Skill Set Requirements

Public Sector Experience:5 points**- Experience working in the OPS and familiarity with I&IT project management processes

Technical Skills:50 points**- 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 pointintime architecture; testing with Life Cycle Manager (5+ years)
  • Excellent requirements analysis skills
  • Indepth knowledge and experience with Cognos report development in Cognos Analytics and Administration v11.2.x (reporting, dashboarding, embedded JavaScript, embedded SQL)
  • 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:35 points**- 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 in Cognos migration and testing skills (reporting, dashboarding, embedded JavaScript, embedded SQL)
  • Experience with Agile/scrum and waterfall methodologies, using tools such as JIRA and Confluence

General Skills:10 points**- 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, detailoriented and creative team player with perseverance, excellent organization and multitasking abilities, and a proven track record for meeting strict deadlines.

Must haves:

  • Experience in Cognos Analytics reporting; modeling with Framework Manager, Transformer, Dynamic Cube Designer, Data Module, Dataset, SDK; implementing pointintime architecture; testing with Life Cycle Manager (5+ years)
  • Experience in AWS Cloud technologies, specifically AWS Redshift
  • Experience in Cognos migration and testing skills (reporting, dashboarding, embedded JavaScript, embedded SQL)

  • Business Intelligence

    2 weeks ago

    Toronto, Ontario, Canada Accentio Group Full time

    Head of Business Intelligence Our client is one of the fastest growing Canadian tech companies. As a Head of Business Intelligence, you should have a vision for how BI helps move the company faster and make better business decisions. You will lead business/functional analysts, programmer/analysts, database/data warehouse administrators, and data...

  • Business Intelligence

    2 weeks ago

    Toronto, Ontario, Canada WCG Services Full time

    Program:Cooperate**:Location:Canada wide**:Who we're looking for:Business Intelligence & Reporting ManagerLike WCG, you believe in the power of work to transform lives. As the Business Intelligence & Reporting Manager, you're part of a team that makes a difference by establishing and maintaining systems which increase the efficiency and effectiveness of our...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada Altus Group Full time

    Job Category:SoftwareOpportunity Awaits at Altus GroupThe OpportunityThis is your chance to develop, build, and grow business intelligence at a global tech company. In this role, you will work closely with teams across the organization, translating their business needs into BI and Analytics solutions. As our next BI Specialist, you will deliver insights,...

  • Business Intelligence Developer

    2 weeks ago

    Toronto, Ontario, Canada Altis Technology Full time

    Senior Business Intelligence Developer – MicroStrategy Project: Insight Med EchoBackground: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project.Responsibilities:Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients.Responsibilities: Assist with gathering business and information requirements. Provide...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada Lancesoft Full time

    Must Haves: Create a cohesive performance measurement and reporting framework through consultations with stakeholders across DO business areas. Design, refine, and validate key performance indicators (KPIs) to accurately reflect business objectives. Create and deploy user-friendly reporting tools such as dashboards tailored to the diverse needs of DO's...

  • Business Intelligence Analyst

    2 weeks ago

    Toronto, Ontario, Canada FLEETCOR Full time

    What We NeedFLEETCOR is currently looking to hire a Business Intelligence Analyst (FP&A) within our Corpay division. This position falls under our Corpay Cross Border line of business and is located in 212 King Street West, Toronto ON. We are thrilled to announce we are setting up a key new Function to focus on Analytics and Strategy within our Data,...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled Business Intelligence Specialist - Intermediate for one of our clients.Position: Business Intelligence Specialist - IntermediateLocation: Toronto, Ontario (Hybrid)Duration: Long Term ContractMust Haves: Power BI Experience Microsoft Dynamics 5 years of experienceExperience and...

  • Business Intelligence Developer

    2 weeks ago

    Toronto, Ontario, Canada GTT, LLC Full time

    Business Intelligence DeveloperContract Duration 6 monthsJob Responsibilities:The Business Intelligence Developer will develop and understand business drivers, definitions, and metrics to interpret findings, take action, and provide meaningful business direction. Develop and maintain specialized Business Intelligence (BI) packages, dashboards, and scorecards...

  • Technical Lead, Business Intelligence

    2 weeks ago

    Toronto, Ontario, Canada Ontario Health Full time

    Want to make a difference in your career? Consider this opportunity.Reporting to the Manager, Business Intelligence (BI), the Lead, Technical (Business Intelligence) will help outline the Business Intelligence strategy and processes considering that within OH there will be centralized and de-centralized teams building Business Intelligence solutions. The...

  • Business Intelligence Analyst

    2 weeks ago

    Toronto, Ontario, Canada BenchSci Full time

    We are looking for aBusiness Intelligence Analyst to join our team. You will report to the Manager, Business Intelligence & Analytics. You will empower our organization by increasing access to data and delivering essential dashboards that answer important questions and guide strategic decisions. BenchSci is a remotefirst organization. At this moment, we are...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada V-Tech Solutions Full time

    Job Title:Bi Specialist**Location:Toronto, Ontario (Hybrid)**Duration: 6 Months ContractOntario Tourism Marketing Partnership Corporation (operating as Destination Ontario) would like to engage the People Placement Service to procure a resource that can help our President & CEO's Office in establishing and implementing standardized measurement and reporting...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada Net2Source Inc. Full time

    Job Title:Business Intelligence Specialist Duration: 8 Months Location: Toronto, Ontario, Canada (3 days onsite and 2 days WFH)MUST HAVES:Experience with a wide range of methods, tools, and techniques for business analysis such as, but not limited to business functional modeling, business even

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada TD Bank Full time

    TD DescriptionStay current and competitive. Carve out a career for yourself. Grow with us.Department OverviewWhat does TD Data & Analytics stand for? For starters, we believe in visionary leadership and insights. We believe in using every resource at our disposal to better serve our clients, and this includes our vast data. Key objectives include driving...

  • ON - Business Intelligence Specialist - Senior

    2 weeks ago

    Toronto, Ontario, Canada Teacup Tech Systems Inc Full time

    RQ Business Intelligence Specialist - Senior Toronto, ON, Canada Job Openings RQ Business Intelligence Specialist - Senior About the job RQ Business Intelligence Specialist - Senior Experience in business intelligence software development and a number of years of practical experience (minimum 3+ years) Experience in providing with recommend best option...

  • Senior Business Intelligence

    2 weeks ago

    Toronto, Ontario, Canada CenterWell Full time

    CenterWell Senior Business Intelligence Analyst Madison , Wisconsin Apply Now Become a part of our caring community and help us put health first Are you the type of person who is skilled at taking a problem and leveraging data to help solve it? We're looking for a Senior Business Intelligence Analyst to help create intelligence through analytics, utilizing...

  • Business Intelligence Lead

    2 weeks ago

    Toronto, Ontario, Canada Canada Life Assurance Company Full time

    Job Description:Are you a Business Intelligence professional with strong Leadership and Communication skills looking for a challenging and rewarding opportunity? Canada Data Team is looking for a Business Intelligence Team Lead to join our team.The BI Team Lead is responsible for leading the Canada Data Business Intelligence team, acting as a high-level...

  • Business Intelligence Developer

    2 weeks ago

    Toronto, Ontario, Canada Munich Re Full time

    Our team at Munich Re is responsible for rethinking and reshaping the way we look at our core business and we are seeking a Business Intelligence Specialist to join our team. As a member of our Data and BI team you will be working on data delivery, transformation, and BI analytics for Munich Re Life and Health by working collaboratively across a variety...

  • Senior Business Intelligence

    2 weeks ago

    Toronto, Ontario, Canada Outhire Inc. Full time $90,000

    Senior Analyst, Business Intelligence Flexible Hours Home Office Support THE OFFICE A great project focused business analyst type opportunity that will provide hands-on support and maintenance of the Business Intelligence functions in a high visibility position.~30% Data Governance ~Design and develop interactive dashboards using PowerBI or other...

  • Business Intelligence, Senior Analyst

    2 weeks ago

    Toronto, Ontario, Canada Home and Community Care Support Services Full time

    Job Description CARE AND BE CARED FOR – THIS IS YOUR HOME Are you a collaborative Business Intelligence professional with expertise in multiple business intelligence tools and methodologies? Do you enjoy analyzing and refining operational processes to improve efficiency? Are you passionate about exceptional health care and driven by a desire to help...