Talent.com
Junior Business Intelligence Specialist
Junior Business Intelligence SpecialistRandstad Canada • Toronto, Ontario, CA
Junior Business Intelligence Specialist

Junior Business Intelligence Specialist

Randstad Canada • Toronto, Ontario, CA
1 day ago
Job type
  • Temporary
  • Quick Apply
Job description

We are seeking a Business Intelligence Specialist to lead high-priority data warehousing and migration initiatives. This role is focused on the transition from legacy systems to modern, cloud-based BI platforms. You will be responsible for gathering complex requirements, analyzing diverse datasets, and designing sophisticated reporting solutions. The ideal candidate will bridge the gap between technical ETL processes and executive-level guided analysis, ensuring that business data is transformed into actionable strategic insights.

Pay Rate : $347.18- $386.31 / Diem

Advantages

  • Strategic Influence : Shape the organization’s transition to modern cloud-based analytics and high-performance BI tools.
  • Technical Depth : Work with a robust variety of technologies, including Oracle, DB2, and SQL Server, in a complex multi-platform environment.
  • Executive Visibility : Develop and deliver presentations that translate complex data relationships into business recommendations for senior management.
  • Professional Growth : Gain hands-on experience in business process re-engineering for large-scale enterprise applications.

Responsibilities

  • Requirement Elicitation : Lead the gathering and documentation of functional requirements for Cognos and Power BI applications, specifically focusing on data migration and cloud transitions.
  • Solution Design : Develop customized query applications, guided analysis, and drill-down functionality to assist in quantitative business analysis.
  • Data Migration : Oversee the design and concepts of data migration across multiple platforms (e.g., Oracle to SQL Server or Cognos to Power BI).
  • ETL & Scripting : Create and optimize complex SQL scripts for data profiling, cleansing, and automated extraction to ensure data integrity across large datasets.
  • Reporting & Dashboards : Design and support BI reports and dashboards using Cognos 10+ and Microsoft Power BI, including the implementation of "key-trend" alerts.
  • Process Engineering : Conduct business process re-engineering and process mapping (UML) to align application designs with modern business objectives.
  • Troubleshooting : Investigate and resolve production issues and defects within ETL pipelines (SSIS) and BI deployments using tools like Microfocus ALM.
  • Knowledge Transfer : Provide 1-on-1 sessions and documentation to internal staff to ensure the sustainability of the developed solutions.
  • Qualifications

  • Technical Ecosystem : Deep experience in environments utilizing Oracle, Informatica, SSIS, and SQL Server for data warehousing and ETL.
  • BI Tool Mastery : Demonstrated proficiency in designing enterprise-wide solutions using Cognos 10 or higher and Microsoft Power BI.
  • Advanced SQL : Expertise in writing complex SQL for data profiling and query optimization across diverse database environments (Oracle 10x+, DB2, SQL Server).
  • Data Migration : Proven understanding of data warehouse design and seamless integration concepts for transitioning to modern BI platforms.
  • Analytical Skills : Strong ability to analyze data source systems for cleanliness issues and develop automated cleansing / load scripts.
  • Modern Tech Stack : (Asset) Working knowledge of cloud infrastructure, including Azure, Databricks, and Power Query.
  • Education & Methodologies : Experience across the full SDLC using both Agile and Waterfall methodologies.
  • Summary

    If you're interested in the Business Intelligence Specialist role based in Toronto, we encourage you to apply online at www.randstad.ca.

    Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

    Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary / gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

    Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.

    Create a job alert for this search

    Junior Business Intelligence Specialist • Toronto, Ontario, CA

    Similar jobs
    Mortgage Specialist

    Mortgage Specialist

    BMO Financial • Newmarket, ON, Canada
    Part-time
    Retail Banking Sales & Service.Join BMO – imagine the possibilities.Are you looking for a chance to let your entrepreneurial spirit shine and turn potential into performance with great ea...Show more
    Last updated: 1 day ago • Promoted
    L&D Project Manager (Financial)

    L&D Project Manager (Financial)

    SPECTRAFORCE • Greater Toronto Area, Canada
    Full-time
    Position Title : Project Manager III.Duration : 1 year (Possible extension and conversion).Business Unit : 4 - HR Learning & Development. Schedule : Monday to Friday – 8 : 30-5.Location : Toronto, Ontario ...Show more
    Last updated: 9 hours ago • Promoted • New!
    Business System Analyst - richmond hill

    Business System Analyst - richmond hill

    HISH IT SERVICES • richmond hill, on, ca
    Full-time
    Job type : Contract(6 Months) - High possibility of Extention.The Data Product Analyst serves as a critical bridge between business stakeholders, analytics teams, and data management groups.This rol...Show more
    Last updated: 5 hours ago • Promoted • New!
    RQ09934 - Sr. Business Intelligence Specialist

    RQ09934 - Sr. Business Intelligence Specialist

    Source Code • Toronto
    Full-time
    Business Intelligence Specialist.Business Intelligence Specialist.Business Intelligence Specialist.Contract 1 year, possible year extension(contractstarting January). Work with project teams to ensu...Show more
    Last updated: 2 days ago • Promoted
    IAM-Business Analyst - Hays

    IAM-Business Analyst - Hays

    Hays • toronto, on, ca
    Full-time
    We are seeking a Business Analyst with experience in Identity and Access Management (IAM) to support requirements gathering, process documentation, and solution delivery for security and access gov...Show more
    Last updated: 5 hours ago • Promoted • New!
    Business Intelligence Developer

    Business Intelligence Developer

    freelance.ca • Toronto, Canada
    Full-time
    Location : Toronto, ON (Hybrid).Proficiency in OBIEE (Oracle Business Intelligence Enterprise Edition) and OAS.Experience in developing interactive dashboards, reports, and data visualizations.Stron...Show more
    Last updated: 21 days ago • Promoted
    OFSAA Developer / BSA

    OFSAA Developer / BSA

    Smart IT Frame LLC • Greater Toronto Area, Canada
    Full-time
    Location : Toronto, ON | Vancouver, BC | Halifax, NS.Work Model : Hybrid – 4 days onsite.Domain : Banking & Financial Services. At Smart IT Frame, we connect top talent with leading organizations acros...Show more
    Last updated: 9 hours ago • Promoted • New!
    Junior Treasury Analyst

    Junior Treasury Analyst

    LeverageTek Staffing Solutions • richmond hill, on, ca
    Permanent +1
    LeverageTek is actively seeking a.Assist with the implementation and setup of Diapason, including system configuration, data entry, and testing. Support the transition to a new corporate banking par...Show more
    Last updated: 5 hours ago • Promoted • New!
    Business Intelligence Developer

    Business Intelligence Developer

    Manulife Insurance Malaysia • Toronto
    Full-time
    Nous utilisons des • •pour fournir des statistiques qui nous aident à vous offrir la meilleure expérience sur note site.Vous y trouverez des renseignements sur les témoins, ou vous pouvez les désac...Show more
    Last updated: 7 days ago • Promoted
    Financial Analyst, Contract

    Financial Analyst, Contract

    Vaco by Highspring • Markham, ON, CA
    Full-time
    Collaborate with internal teams to monitor and consolidate capital project expenses into active project accounts within Microsoft Dynamics 365. Conduct detailed reviews of procurement activities and...Show more
    Last updated: 1 day ago • Promoted
    Manager, Business Intelligence & Data Analytics

    Manager, Business Intelligence & Data Analytics

    Sapling Financial Consultants Inc. • Toronto C6A, ON, Canada
    Remote
    Full-time +1
    Manager, Business Intelligence & Data Analytics.Manager, Business Intelligence & Data Analytics.Sapling Financial Consultants Inc. Sapling Financial Consultants is a management consulting firm, foun...Show more
    Last updated: 22 days ago • Promoted
    Manager, Drug Intelligence & Business Process - newmarket

    Manager, Drug Intelligence & Business Process - newmarket

    pan-Canadian Pharmaceutical Alliance • newmarket, on, ca
    Full-time +1
    The pan-Canadian Pharmaceutical Alliance (pCPA) brings together provincial, territorial, and federal governments for the purpose of increasing and managing access to clinically relevant and cost-ef...Show more
    Last updated: 5 hours ago • Promoted • New!
    Business System Analyst

    Business System Analyst

    Cognizant • Greater Toronto Area, Canada
    Full-time
    Job Title - Financial Business Systems Analyst.Location - Toronto- 3 days / week.Our Data Platform is a cross‑asset pricing and risk management platform. The Data Platform team maintains the strategi...Show more
    Last updated: 9 hours ago • Promoted • New!
    Business System Analyst

    Business System Analyst

    TechDoQuest • Markham, ON, Canada
    Full-time
    Document Authoring Business Systems Analyst II.We are currently recruiting for a positive and collaborative Document Authoring Business Systems Analyst II for our Markham office.You will work close...Show more
    Last updated: 9 hours ago • Promoted • New!
    Crypto Market Maker - Colibri AM (Asset Management)

    Crypto Market Maker - Colibri AM (Asset Management)

    Colibri AM (Asset Management) • richmond hill, on, ca
    Full-time
    Colibri AM (Asset Management) is a boutique investment management firm based in Libourne, France, specializing in the marketing and management of responsible and sustainable investment funds (ISR)....Show more
    Last updated: 5 hours ago • Promoted • New!
    Business Intelligence Specialist -Junior

    Business Intelligence Specialist -Junior

    Bevertec • toronto, on, ca
    Full-time
    Experience in environments where Oracle, Informatica, SSIS, and SQL Server are utilized for data warehousing, ETL processes, and business intelligence solutions. Experience working with data warehou...Show more
    Last updated: 5 hours ago • Promoted • New!
    Business Analyst

    Business Analyst

    UniSysTech Consulting • Greater Toronto Area, Canada
    Full-time
    We’re looking for a Business Analyst with 3–5 years of experience supporting AI projects.You will work with AI / ML, engineering, and business stakeholders to translate business needs into clear requ...Show more
    Last updated: 9 hours ago • Promoted • New!
    Business Intelligence Developer

    Business Intelligence Developer

    Manulife • Toronto
    Full-time
    John Hancock Manulife Investment Management is a world‑class provider of asset management and investment strategies.The Global Business Intelligence Team, as part of the wider Global Retail Sales E...Show more
    Last updated: 7 days ago • Promoted