Jobs
>
Toronto

    RQ07228 Business Intelligence Specialist - Toronto, Canada - Randstad Canada

    Randstad Canada
    Randstad Canada Toronto, Canada

    1 week ago

    Randstad Canada background
    Temporary
    Description
    This is a contract position for a Business Intelligence Specialist - ETL Developer for our public sector client.

    Work location:
    Downtown Toronto


    Duration:
    Twelve Months

    7.25 hours/day
    This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)

    Advantages
    Good compensation working on projects that will make a difference to the people of Ontario.

    Responsibilities


    • Design, develop and implement ingestion framework from Oracle data source to Azure Data Lake - initial load and incremental ETL

    Tools used are:

    • Azure Data Factory (good knowledge required) to maintain pipeline from Oracle to Azure Data Lake
    • Azure Databricks/PySpark (good Python/PySpark knowledge required) to build transformations of raw data into curated zone in the data lake
    • Azure Databricks/PySpark/SQL (good SQL knowledge required) to develop and/or troubleshoot transformations of curated data into datamart model
    • Review the requirements, database tables, and database relationships - Identify gaps and inefficiencies in current production reporting environment and provide recommendations to address them in the new platform
    • Design ingestion framework and CDC - tools used are Oracle Golden Gate and Azure Data Factory
    • Prepare design artifacts
    • Work with IT partner on configuration of Golden Gate - responsible to provide direction and "how to"
    • Maintain dynamic pipeline for ETL ingestion to add new tables and data elements
    • Data design - physical model mapping from data source to reporting destination
    • Understand the requirements. Recommend changes to the physical model to support ETL design
    • Reverse engineer and document existing SQL logic to improve design effort
    • Assist with data modelling and updates of source-to-target mapping documentation
    • Develop scripts for the physical model, and update database and/or data lake structure
    • Access Oracle DB, SQL Server, and Azure environments, using SSIS, SQLDeveloper, Azure Data Studio, Azure Data Factory, Databricks and other tools to develop solution
    • Proactively communicate with business and IT experts on any changes required to conceptual, logical and physical models, communicate and review timelines, dependencies, and risks
    • Development of ETL strategy and solution for different sets of data modules
    • Understand the Tables and Relationships in the data model
    • Create low level design documents and test cases for ETL development
    • Create the workflows and pipeline design
    • Development and testing of data pipelines with Incremental and Full Load
    • Develop high quality ETL mappings/scripts/notebooks
    • Develop and maintain pipeline from Oracle data source to Azure Data Lake and Databricks Sql Warehouse
    • Develop ETL to update datamarts built in Databricks Sql Warehouse
    • Perform unit testing
    • Ensure performance monitoring and improvement
    • Performance review, data consistency checks
    • Troubleshoot performance issues, ETL issues, log activity for each pipeline and transformation
    • Review and optimize overall ETL performance
    • End-to-end integrated testing for Full Load and Incremental Load
    • Plan for Go Live, Production Deployment
    • Create production deployment steps
    • Configure parameters, scripts for go live. Test and review the instructions
    • Create release documents and help build and deploy code across servers
    • Go Live Support and Review after Go Live
    • Review existing ETL process, tools and provide recommendation on improving performance and reduce ETL timelines
    • Review infrastructure and remediate issues for overall process improvement
    • Knowledge Transfer to Ministry staff, development of documentation on the work completed
    • Document work and share the ETL end-to-end design, troubleshooting steps, configuration and scripts review
    • Transfer documents, scripts and review of documents to Ministry
    Qualifications

    • 7+ years using ETL tools such as Microsoft SSIS, stored procedures, T-SQL
    • 2+ Azure Data Lake and Databricks, and building Azure Data Factory and Azure Databricks pipelines
    • 2+ years Python and PySpark
    • Oracle Golden Gate
    • SQL Server
    • Oracle
    • Ability to present technical requirements to the business
    Summary
    If interested and qualified for this role, please apply today for immediate consideration

    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 to ensure their ability to fully participate in the interview process.

  • Cleo Consulting

    Business Intelligence Specialist

    1 week ago

    Cleo Consulting Toronto, Canada

    **Assignment: RQ Business Intelligence Specialist - Senior** · **Start Date: ** · **End Date: ** · **Office Location: Hybrid - 3 days in office, 2 days remote. Office location: 222 Jarvis St 5th floor** · **Organization: Central Agencies Cluster** · **Ministry: Ministry of Treasu ...

  • Arthur Grand Technologies Inc

    Business Intelligence Specialist

    1 week ago

    Arthur Grand Technologies Inc Toronto, Canada

    **Position: Business Intelligence Specialist (Cognos 10,Microsoft Power BI)** · **Location:Toronto, Ontario (Hybrid)** · **Duration: Long Term Contract** · **MUST HAVES**: · - Supports Client's wide-ranging business information requirements, implementing and supporting business i ...

  • Arthur Grand Technologies Inc

    Business Intelligence Specialist

    2 weeks ago

    Arthur Grand Technologies Inc Toronto, Canada

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Business Intelligence Specialist **for one of our clients. · **Position: Business Intelligence Specialist - Intermediate** · **Location: 222 Jarvis St., Toronto, Ontario (Hybrid)** · **Duration: Long ...

  • First Canadian Insurance Corporation

    Business Intelligence Specialist

    1 week ago

    First Canadian Insurance Corporation Toronto, Canada

    First Canadian is a national organization and we are experiencing unprecedented growth · We aim to hire bright, hard-working people who share our values. We seek employees who are committed to learning, career growth, and opportunity. We take pride in being an organization that o ...

  • Cleo Consulting

    Business Intelligence Specialist

    1 hour ago

    Cleo Consulting Toronto, Canada

    **Assignment: RQ Business Intelligence Specialist - Senior** · **Start Date: ** · **End Date: ** · **Office Location: 315 Front St. West** · **Organization: Children, Youth & Social Services Cluster** · **Ministry: Ministry of Children, Community and Social Services** · **# Busin ...

  • TD Bank

    Business Intelligence Specialist

    2 weeks ago

    TD Bank Toronto, Canada

    398971BR · Enterprise Data & Analytics · Toronto, ON · March 10, 2023 · Company Overview · Department Overview · What 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 se ...

  • SE Health

    Business Intelligence Specialist

    2 weeks ago

    SE Health Toronto, Canada

    **About Saint Elizabeth**: · Saint Elizabeth is a national health care provider that has been opening the door to new possibilities and experiences for more than a century. Recognized as Canada's largest social enterprise, we employ 8,000 people and visit 18,000 clients every day ...

  • iPartner Staffing

    Business Intelligence Specialist

    1 week ago

    iPartner Staffing Toronto, Canada

    7+ years in ETL tools such as Microsoft SSIS, stored procedures **(Must Have)**: · - 2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines **(Must Have)**: · - 2+ years Python **(Must Have)** · Description · **General Responsibilities** · Design, develo ...

  • TD Bank

    Business Intelligence Specialist

    1 week ago

    TD Bank Toronto, Canada

    **Business Intelligence Specialist - Cybersecurity Technology & Risk**: · BR · **Job Category - Primary** · - Enterprise Data & Analytics · **Work Location** · Front Street West Corporate · **Employment Type** · - Regular · **City** · - Toronto · **Time Type** · - Full Time · **P ...

  • EBF

    Business Intelligence Specialist

    1 week ago

    EBF Toronto, Canada

    on behalf of our client on Public Sector. we are looking for contract Business Intelligence Specialist for 1 year remote contract · Description · **SCOPE**: · - Provide planning, assessment, and development effort to complete the migration of approximately 136 IBM Cognos reports ...

  • EBF

    Business Intelligence Specialist

    2 weeks ago

    EBF Toronto, Canada

    on behalf of our client on Public Sector. we are looking for contract **Business Intelligence Specialist - ETL Developer** · Description · **General Responsibilities** · - Design, develop and implement ingestion framework from Oracle source to Azure Data Lake - initial load and i ...

  • AlphaForce Technology Solutions

    Business Intelligence Specialist

    5 days ago

    AlphaForce Technology Solutions Toronto, Canada

    **Position: Business Intelligence Specialist - Senior** · **Location: 315 Front Street, Toronto, ON** · **Security Level: CRJMC** · **Must haves**: · - 7+ years in ETL tools such as Microsoft SSIS, stored procedures (Must Have) · - 2+ Azure Data Lake and Data Warehouse, and build ...

  • YDC PRO Consulting

    Business Intelligence Specialist

    6 days ago

    YDC PRO Consulting Toronto, Canada

    **Must haves**: · - 10+ years of experience · - Demonstrates advanced knowledge and expertise in various BI tools and technologies, such as data modeling, ETL processes, data visualization, and reporting. · - Experience with the Microsoft suite of technology including: Azure Data ...

  • iPartner Staffing

    Business Intelligence Specialist

    22 hours ago

    iPartner Staffing Toronto, Canada

    **Must Have**: · - 3+ years using Power BI software development, including using DAX queries and functions · - Microsoft Azure services such as Power Apps, Power Automate, Azure Database, Azure Analysis Services, Azure Synapse, etc. · - SQL Server 2017~2019 · - Working knowledge ...

  • Ministry of Health

    Business Intelligence Specialist

    5 days ago

    Ministry of Health Toronto, Canada

    We are in search of a seasoned professional to provide technical expertise in the design and implementation of complex projects as well as re-engineering of legacy (on-premise) technical solutions as to facilitate cloud migration. · If this sounds like your next career move, then ...

  • Dawn InfoTek Inc.

    Junior Business Intelligence Specialist

    1 week ago

    Dawn InfoTek Inc. Toronto, Canada

    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. · We a ...

  • WIZECH INC.

    W0115 Business Intelligence Specialist

    1 week ago

    WIZECH INC. Toronto, Canada

    We are hiring a IT talents for our decent clients. · Contract term: 12 months · Hybrid: 3 days onsite per week is required · **Responsibilities** · - Key deliverables to be performed by the Business Intelligence Specialist role include, but are not limited to, the following: · - ...

  • KPMG-Canada

    Tax Specialist, Intelligent Delivery and Innovation

    1 week ago

    KPMG-Canada Toronto, Canada

    **Overview** · At KPMG, you'll join a team of diverse and dedicated problem solvers, connected by a common cause: turning insight into opportunity for clients and communities around the world. · **The Opportunity** · Intelligent Delivery and Innovation (iDi), is KPMG's innovative ...

  • Apotex Inc.

    Marketing Intelligence Specialist

    6 days ago

    Apotex Inc. North York, Canada

    **About Apotex Inc.** · **Job Summary**: · The Specialist, Marketing Intelligence reports directly to the Director, Pricing & Marketing Intelligence in a role designed to help drive the Marketing plan of action for Apotex's broad line of generic pharmaceutical products. · The Spe ...

  • Apotex

    Marketing Intelligence Specialist

    5 days ago

    Apotex North York, Canada

    About Apotex Inc. · Job Summary · The Specialist, Marketing Intelligence reports directly to the Director, Pricing & Marketing Intelligence in a role designed to help drive the Marketing plan of action for Apotex's broad line of generic pharmaceutical products. · The Specialist, ...