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
2 days 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
    Business Intelligence Developer

    Business Intelligence Developer

    Manulife • Toronto, Canada
    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: 9 days ago • Promoted
    Business Intelligence Analyst III

    Business Intelligence Analyst III

    TD Securities • Toronto
    Full-time
    Business Intelligence Analyst III.Work Location : Toronto, Ontario, Canada.The Compliance Data Enablement & Transformation (CDET) team supports the effective and sustainable implementation and execu...Show more
    Last updated: 7 days ago • Promoted
    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
    Business Intelligence Engineer

    Business Intelligence Engineer

    Brooksource • Toronto
    Full-time +1
    This range is provided by Brooksource.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Hybrid (2–3 days on-site per week).Early - Mid February (f...Show more
    Last updated: 7 days ago • Promoted
    Sales Business Intelligence (BI) Lead

    Sales Business Intelligence (BI) Lead

    Vendasta Technologies • Toronto, Canada
    Full-time
    Sales Business Intelligence (BI) Lead, Saskatoon, SK At Vendasta, we’re leading the AI revolution from right here in Saskatoon—and beyond. We work together to empower our partners and customers thro...Show more
    Last updated: 15 days ago • Promoted
    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
    Professional, Business Intelligence - 12 Month Contract - $50,200 - $92,500 A Year

    Professional, Business Intelligence - 12 Month Contract - $50,200 - $92,500 A Year

    Definity Financial • Toronto, Canada
    Temporary
    Design and develop data stories with visualizations.Collaborate with BI professionals and communicate effectively with partners.Show more
    Last updated: 1 day ago • Promoted
    Business Intelligence Specialist - Junior

    Business Intelligence Specialist - Junior

    Connvertex Technologies Inc. • Toronto, ON, Canada
    Full-time
    Quick Apply
    Experience and Skill Set Requirements Technical Skills - 40% Demonstrates business analysis experience in an environme...Show more
    Last updated: 7 days ago
    Business Intelligence Developer

    Business Intelligence Developer

    Rakuten Kobo Inc. • Toronto, Canada
    Full-time
    Our employees rank us highly in terms of commitment to work / life balance.We realize that for our people to be innovative, creative and passionate they need to feel valued and supported.We believe i...Show more
    Last updated: 15 days ago • Promoted
    RQ06224 - Business Intelligence Specialist - Senior

    RQ06224 - Business Intelligence Specialist - Senior

    Teacup Tech Systems Inc • Toronto
    Full-time
    RQ06224 - Business Intelligence Specialist - Senior.About the job RQ06224 - Business Intelligence Specialist - Senior.Experience in business intelligence software development and a number of years ...Show more
    Last updated: 2 days ago • Promoted
    Manager, Business Intelligence

    Manager, Business Intelligence

    CAPREIT Apartments • Toronto, Canada
    Full-time +1
    Manager, Business Intelligence Reports to : .Associate Director, BI and Data Management Position Summary.CAPREIT’s Business Intelligence team is seeking a high‑impact, business‑minded analytics leade...Show more
    Last updated: 15 days ago • Promoted
    Business Intelligence Developer

    Business Intelligence Developer

    Manulife Financial • Toronto, Canada
    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: 10 days ago • Promoted
    Business Intelligence Engineer

    Business Intelligence Engineer

    Dexian • Toronto
    Full-time
    This role focuses on migrating legacy SSRS / SSAS solutions to Power BI and MS Fabric, while building robust, scalable, and high-performance data pipelines. You will work closely with business stakeho...Show more
    Last updated: 2 days ago • Promoted
    VP Business Intelligence

    VP Business Intelligence

    Preston Lang • Toronto, Canada
    Full-time
    VP Business Intelligence - JO103667 Our Client Our client is a global marketer of branded apparel.They have 200+ offices worldwide and represent many major well-known name brands.Work closely with ...Show more
    Last updated: 15 days ago • Promoted
    Business Intelligence Architect AMADC5726889

    Business Intelligence Architect AMADC5726889

    Compunnel Inc. • Toronto, Canada
    Temporary
    Toronto / Waterloo (Hybrid – 3 days onsite, 2 days remote).Months Contract (High possibility of conversion).This role sits within a broader data portfolio and plays a key part in delivering scalabl...Show more
    Last updated: 13 hours ago • Promoted • New!
    Business Intelligence Consultant - AWS Quicksuite (Contract)

    Business Intelligence Consultant - AWS Quicksuite (Contract)

    TMX Group • Toronto, Canada
    Full-time
    Venture outside the ordinary - TMX Careers The TMX group of companies includes leading global exchanges such as the Toronto Stock Exchange, Montreal Exchange, and numerous innovative organizations ...Show more
    Last updated: 3 days ago • Promoted
    RQ09989 - Business Intelligence Specialist - Junior

    RQ09989 - Business Intelligence Specialist - Junior

    Maarut • Toronto, ON, ca
    Full-time
    Quick Apply
    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, imple...Show more
    Last updated: 1 day ago
    Business Intelligence Developer

    Business Intelligence Developer

    Insight Global • Toronto
    Full-time
    Get AI-powered advice on this job and more exclusive features.This range is provided by Insight Global.Your actual pay will be based on your skills and experience — talk with your recruiter to lear...Show more
    Last updated: 7 days ago • Promoted