Senior BI Reporting Analyst- Canada

2 weeks ago


Old Toronto, Canada Zortechsolutions Full time
Senior BI Reporting Analyst

6+ months

Job Profile

Reporting to the Director, Data & Analytics the Senior Business Intelligence will be responsible for the following duties, and complete special initiatives and projects as assigned.

Responsibilities

  • Lead and/or partner with clients in planning, designing, implementing, optimizing, administering, and evaluating BI solutions, including big data solutions, open data, queries, reports, dashboards, and other visualizations based on stakeholders needs
  • Leverage business and statistical knowledge to transform data into information
  • Design and develop BI dashboards and reports based on business requirements
  • Elicit, document, and confirm business requirements and technical specifications.
  • Participate in the design and enhancement of data marts and data warehouse.
  • Define and evaluate conceptual, logical, and physical BI solution architectures.
  • Perform data quality assessments, data transformation, and data cleansing
  • Develop SQL Scripts/Procs/ETL flows to support reports, dashboards, and KPIs in SSRS, Cognos, and Power BI.
  • Create, support, and enhance SSAS OLAP cubes and MDX/DAX scripts.
  • Develop test scripts and perform testing of BI solutions to ensure seamless transition to production environment.
  • Proactively seek relevant technology enhancements to current and future BI and Reporting initiatives.

Requirements

  • Degree in Computer Science, MIS, Engineering, Mathematics or related field from an accredited college or university.
  • 5+ years' experience in design, development, and modeling of data warehouses.
  • 5+ years' demonstrable experience working with BI tools like SSRS, Microsoft Power BI or IBM Cognos (Cognos Dashboards, Report Studio, Cubes, Framework Manager), Tableau etc.
  • 5+ years' experience in creating ETL packages in SSIS, ADF or IBM DataStage.
  • 5+ years' developing solutions using standard RDBMS, No-SQL, Azure, semi-structured data sources such as MongoDB, Dyanmo DB, Redis, JSON, etc.
  • Expert-level T-SQL query development.
  • Demonstrated clear and effective professional communication skills, both written and verbal.
  • Outstanding attention to detail, and the ability to uphold high quality control standards.
  • Experienced in estimating complexity, time, and effort, planning, and worked closely with Project Managers to successfully meet requirements and timelines
  • Proficient with the Microsoft Office suite of tools (Word, Excel, PowerPoint, Visio)
  • Ability to work both independently and collaboratively with Business Intelligence stakeholders
  • Demonstrable organizational, analytical, and innovative thinking skill.
  • Exceptional interpersonal, organizational, prioritization, and follow-up skills, with a strong commitment to being a team player and meeting the client's needs
  • Strong time management skills (ability to simultaneously manage multiple tasks and projects)
#J-18808-Ljbffr

  • Toronto, ON, Canada Zortechsolutions Full time

    Senior BI Reporting Analyst 6+ months Job Profile Reporting to the Director, Data & Analytics the Senior Business Intelligence will be responsible for the following duties, and complete special initiatives and projects as assigned. Responsibilities Lead and/or partner with clients in planning, designing, implementing, optimizing, administering, and...


  • Toronto, Canada VS Consulting Group Full time

    The BI & Reporting Analyst is a member of the Finance and Accounting team, reporting to the Director, Business Intelligence and Financial Systems. The BI & Reporting Analyst role supports the reporting and analytic needs of the Firm in all aspects of the management reporting and business intelligence function. Primary Responsibilities - Design, build,...

  • Senior BI Analyst

    4 days ago


    Toronto, Canada North Horizon Holdings Inc. Full time

    Job summary: The Senior BA/BI Analyst is mainly responsible for collecting, sorting, and analyzing business needs (BA) from the different business units, and leveraging the Microsoft 365 and Power Platform to quickly find an intelligent solution (BI) to fulfill the business need and ultimately hel


  • Old Toronto, Canada Canada Life Full time

    Permanent Full Time Reporting to the Associate Manager, Corporate Financial Reporting, the Senior Financial Reporting Analyst will be a key member of the global financial reporting team, with a focus on segregated funds financial reporting. Along with exposure to Great-West Lifeco’s operating segments and great opportunities to expand your knowledge base,...


  • Old Toronto, Canada Canada Life Full time

    Permanent Full Time Reporting to the Associate Manager, Corporate Financial Reporting, the Senior Financial Reporting Analyst will be a key member of the global financial reporting team, with a focus on segregated funds financial reporting. Along with exposure to Great-West Lifeco’s operating segments and great opportunities to expand your knowledge base,...


  • Old Toronto, Canada Canada Life Full time

    Permanent Full Time Reporting to the Associate Manager, Corporate Financial Reporting, the Senior Financial Reporting Analyst will be a key member of the global financial reporting team, with a focus on segregated funds financial reporting. Along with exposure to Great-West Lifeco’s operating segments and great opportunities to expand your knowledge base,...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Toronto - Hybrid model (1 -2 days a week in office) Contract Duration: 5-6 months Possibility of extension & conversion to FTE – Depending on performance and business needs Number of Positions: 1 Schedule Hours: 9am-5pm Monday-Friday (No overtime) Reason: Extra support Purpose We are seeking a highly skilled Senior Looker Developer...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Toronto - Hybrid model (1 -2 days a week in office) Contract Duration: 5-6 months Possibility of extension & conversion to FTE – Depending on performance and business needs Number of Positions: 1 Schedule Hours: 9am-5pm Monday-Friday (No overtime) Reason: Extra support Purpose We are seeking a highly skilled Senior Looker Developer...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Toronto - Hybrid model (1 -2 days a week in office) Contract Duration: 5-6 months Possibility of extension & conversion to FTE – Depending on performance and business needs Number of Positions: 1 Schedule Hours: 9am-5pm Monday-Friday (No overtime) Reason: Extra support Purpose We are seeking a highly skilled Senior Looker Developer...

  • Senior BI Analyst

    1 week ago


    Toronto, Canada North Horizon Holdings Inc. Full time

    Job summary:The Senior BA/BI Analyst is mainly responsible for collecting, sorting, and analyzing business needs (BA) from the different business units, and leveraging the Microsoft 365 and Power Platform to quickly find an intelligent solution (BI) to fulfill the business need and ultimately help the business department to improve the productivity and...


  • Old Toronto, Canada 2i Solutions, Inc Full time

    There is 3 months contract opportunity, with possible extension for a Senior BI Developer, in Mississauga, Toronto.Work would be done remotely until the pandemic situation normalizes.Must haves:• Reliability level security clearance is mandatory• 3-5 years of relevant experience• Strong knowledge of Tableau 10 and above in design and development•...


  • Old Toronto, Canada 2i Solutions, Inc Full time

    There is 3 months contract opportunity, with possible extension for a Senior BI Developer, in Mississauga, Toronto.Work would be done remotely until the pandemic situation normalizes.Must haves:• Reliability level security clearance is mandatory• 3-5 years of relevant experience• Strong knowledge of Tableau 10 and above in design and development•...


  • Old Toronto, Canada 2i Solutions, Inc Full time

    There is 3 months contract opportunity, with possible extension for a Senior BI Developer, in Mississauga, Toronto.Work would be done remotely until the pandemic situation normalizes.Must haves:• Reliability level security clearance is mandatory• 3-5 years of relevant experience• Strong knowledge of Tableau 10 and above in design and development•...

  • Senior BI Analyst

    48 minutes ago


    Toronto, Canada North Horizon Holdings Inc. Full time

    Job summary:The Senior BA/BI Analyst is mainly responsible for collecting, sorting, and analyzing business needs (BA) from the different business units, and leveraging the Microsoft 365 and Power Platform to quickly find an intelligent solution (BI) to fulfill the business need and ultimately help the business department to improve the productivity and...


  • Old Toronto, Canada Zortechsolutions Full time

    Role: BI Developer-Business IntelligenceLocation: Remote (Canada only) Duration: 6+ Months Job DescriptionQualifications: Business Intelligence Engineer Job Description: This position is for a Business Intelligence / Reporting engineer with a background in SQL and data warehousing for enterprise level systems. Strong Power BI experience is a must especially...


  • Old Toronto, Canada Zortechsolutions Full time

    Role: BI Developer-Business IntelligenceLocation: Remote (Canada only) Duration: 6+ Months Job DescriptionQualifications: Business Intelligence Engineer Job Description: This position is for a Business Intelligence / Reporting engineer with a background in SQL and data warehousing for enterprise level systems. Strong Power BI experience is a must especially...


  • Old Toronto, Canada Zortechsolutions Full time

    Role: BI Developer-Business IntelligenceLocation: Remote (Canada only) Duration: 6+ Months Job DescriptionQualifications: Business Intelligence Engineer Job Description: This position is for a Business Intelligence / Reporting engineer with a background in SQL and data warehousing for enterprise level systems. Strong Power BI experience is a must especially...

  • Senior BI Analyst

    1 week ago


    Toronto, ON, Canada North Horizon Holdings Inc. Full time

    Job summary:The Senior BA/BI Analyst is mainly responsible for collecting, sorting, and analyzing business needs (BA) from the different business units, and leveraging the Microsoft 365 and Power Platform to quickly find an intelligent solution (BI) to fulfill the business need and ultimately help the business department to improve the productivity and...

  • Senior BI Analyst

    1 week ago


    Toronto, ON, Canada North Horizon Holdings Inc. Full time

    Job summary:The Senior BA/BI Analyst is mainly responsible for collecting, sorting, and analyzing business needs (BA) from the different business units, and leveraging the Microsoft 365 and Power Platform to quickly find an intelligent solution (BI) to fulfill the business need and ultimately help the business department to improve the productivity and...

  • Senior BI Analyst

    1 week ago


    Toronto, ON, Canada North Horizon Holdings Inc. Full time

    Job summary:The Senior BA/BI Analyst is mainly responsible for collecting, sorting, and analyzing business needs (BA) from the different business units, and leveraging the Microsoft 365 and Power Platform to quickly find an intelligent solution (BI) to fulfill the business need and ultimately help the business department to improve the productivity and...