You are successfully logged out of your my randstad account

You have successfully deleted your account

ETL Developer

job details

summary

    job details
    Our Client in the Ontairo Public Sector is looking for a Business Intelligence Developer on a 8 month contract


    5 +years of experience in data analysis developing business intelligence and reporting in a medium to large size corporate environment demonstrating detailed knowledge of BI functions such as analytics, data modeling & data mining, reporting, report conversion and data cleansing.

    Power bi environment set-up experience

    Azure experience


    Advantages
    Long Term Contract
    Hybrid Work
    New Technology
    Payment Every week
    Contract will extend for an additional year

    Responsibilities
    Supports Client’s wide-ranging business information requirements, implementing and supporting business intelligence software solutions

    Develops and supports customized query applications which analyze key business data

    Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of “opportunity” and “key-trend” alerts.

    Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.


    Qualifications
    Experience with data architecture designs and technologies for BI solutions, using the Microsoft BI suite, for both on-premise and cloud solutions
    10+ years of experience for the following:
    ETL development experience using SSIS / ADF in a data warehousing environment or large data migration; Working experience in debugging mappings, transformations and source qualifier files and Unit testing the newly developed ETL components
    Cube development experience using SSAS
    Experience working with Oracle and MSSQL databases (TSQL, Stored Procedures, Views).
    Extensive experience with source control and environment management
    Experience with creating documentations such as data dictionary and data source to target mapping; provide feedback/direction to team on how existing documentations can be improved
    Experience using PowerDesigner to review data models, as well as make changes and generate DDL's
    Experience in developing the Application Code package using tools such as TFS. Build automation experience is an asset
    Azure DevOps (Git and Boards)


    Summary
    The BIS will work under the direction of the Project Manager and the Senior Manager and will engage directly with business clients.


    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.
    Our Client in the Ontairo Public Sector is looking for a Business Intelligence Developer on a 8 month contract


    5 +years of experience in data analysis developing business intelligence and reporting in a medium to large size corporate environment demonstrating detailed knowledge of BI functions such as analytics, data modeling & data mining, reporting, report conversion and data cleansing.

    Power bi environment set-up experience

    Azure experience


    Advantages
    Long Term Contract
    Hybrid Work
    New Technology
    Payment Every week
    Contract will extend for an additional year

    Responsibilities
    Supports Client’s wide-ranging business information requirements, implementing and supporting business intelligence software solutions

    Develops and supports customized query applications which analyze key business data

    Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of “opportunity” and “key-trend” alerts.

    Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.


    Qualifications
    Experience with data architecture designs and technologies for BI solutions, using the Microsoft BI suite, for both on-premise and cloud solutions
    10+ years of experience for the following:
    ETL development experience using SSIS / ADF in a data warehousing environment or large data migration; Working experience in debugging mappings, transformations and source qualifier files and Unit testing the newly developed ETL components
    Cube development experience using SSAS
    Experience working with Oracle and MSSQL databases (TSQL, Stored Procedures, Views).
    Extensive experience with source control and environment management
    Experience with creating documentations such as data dictionary and data source to target mapping; provide feedback/direction to team on how existing documentations can be improved
    Experience using PowerDesigner to review data models, as well as make changes and generate DDL's
    Experience in developing the Application Code package using tools such as TFS. Build automation experience is an asset
    Azure DevOps (Git and Boards)


    Summary
    The BIS will work under the direction of the Project Manager and the Senior Manager and will engage directly with business clients.


    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.