Jobs
>
Toronto

    Database/Data Analyst - Toronto, ON, Canada - Knewin

    Knewin
    Knewin Toronto, ON, Canada

    2 weeks ago

    Knewin background
    Description
    Data Specialist

    Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, and works to improve the structure and efficiency of an organization's I&IT systems.

    The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT technology, IT infrastructures, and the enablement of major business processes through enhancements to IT.

    Provides subject matter expertise in their field and highly expert technical assistance.

    Demonstrated deep Microsoft stack experience (10 Years) with at least the past 4 years of Microsoft Azure Data Factory experience.

    Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools.
    Experience with migration from Cognos/Informatica to Power BI solutions
    Experience with designing and implementing interactive and visually appealing reports and dashboards using SQL Server Reporting Services (SSRS) and Power BI
    Experience with Microsoft DevOps, pipelines, datasets, triggers, and other Azure Data Factory components

    Design, develop, and maintain data pipelines using Azure Data Factory Services for data ingestion, transformation, and integration.

    Develop ETL processes using SQL Server Integration Services (SSIS) to move and transform data from various sources into Azure data repositories.

    Azure Data Factory, knowing how to create and manage pipelines, datasets, triggers, and other ADF components effectively.
    Design and implement interactive and visually appealing reports and dashboards using SQL Server Reporting Services (SSRS) and Power BI

    Well-versed in ETL tools and technologies, especially those within Azure Data Factory, such as Data Flow, Mapping Data Flows, and other data transformation components.

    Ensure data quality and data governance practices are implemented throughout the data integration process.
    Demonstrated experience with data ingestion from multiple sources, staging, and data cleansing.

    Guide the architecture leveraging Azure cloud services, ensuring effective and standard use of the Microsoft Stack tools and services critical for the integrity, quality, and pace of delivery.

    Understanding Azure's security and compliance features is crucial to ensure data privacy and meet regulatory requirements.

    Design, plan, and implement data integration and analytics solutions on the Microsoft Azure platform, leveraging Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant services.

    Create architecture diagrams and technical documentation for Azure-based solutions.
    Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions.

    Design and implement data models and cubes using SQL Server Analysis Services (SSAS) for efficient data analysis and reporting.

    Design and develop interactive and informative dashboards and reports using Power BI to facilitate data-driven decision-making.
    Data Modelling - 20%

    Design experience with star and snowflake schemas, dimensional modeling, and data model architecture and design aligned with data standards and analytics needs of various stakeholders, includes creation DW, Views, Cubes, and other data services products, using SQL Server Analysis Services (SSAS)

    Utilize tools like Erwin Data Modeler and Power Designer to create and maintain data models for efficient data storage and retrieval.

    Microsoft Azure Data Factory Services, SSIS, SSAS, SSRS, Power BI, DataStage, Quality Stage, Visual Studio, Team Foundation Services, SQL Server Management Studio, Erwin Data Modeler, Power Designer.

    Technical skills - 30%

    Demonstrated experience in guiding the architecture leveraging Azure cloud services, including effective standard use of Microsoft Stack tools and services critical for the integrity, quality, and pace of delivery.

    Demonstrated deep Microsoft stack experience (10 Years) with at least the past 4 years of Microsoft Azure Data Factory experience.

    Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools.
    Strong knowledge of data integration techniques, data warehousing, and ETL processes.
    Familiarity with database management and SQL Server environments.
    Microsoft Azure Data Factory Services, SSIS, SSAS, SSRS, Power BI, Datastage, Quality Stage, Visual Studio, Team Foundation Services, SQL Server Management Studio, Erwin Data Modeler, Power Designer
    Hybrid role- 3-days per week on-site required

    #
  • R.E. ROYAL TRADING INC.

    database analyst

    4 days ago

    R.E. ROYAL TRADING INC. Vaughan, Canada

    Education: · Expérience: · Education · College/CEGEP · Tasks · Design and develop database · Operate database management systems to analyze data · Collect and document user's requirements · Work conditions and physical capabilities · Fast-paced environment · Work under pressure ...

  • SULYMON GLOBAL INC.

    data analyst

    4 days ago

    SULYMON GLOBAL INC. Toronto, Canada

    Education: · Expérience: · Education · Bachelor's degree · Work setting · Private sector · Tasks · Design and develop database · Operate database management systems to analyze data · Collect and document user's requirements · Computer and technology knowledge · Oracle · Python ...

  • Rapri Transport Ltd.

    database analyst

    3 days ago

    Rapri Transport Ltd. Brampton, Canada

    Work Term: Permanent · Work Language: English · Hours: 35 hours per week · Education: Bachelor's degree · Experience: 1 year to less than 2 years · Tasks · Design and develop database · Operate database management systems to analyze data · Develop and implement data administratio ...

  • Rapri Transport Ltd.

    database analyst

    4 days ago

    Rapri Transport Ltd. Brampton, Canada

    Durée de l'emploi: Permanent · Langue de travail: Anglais · Heures de travail: 35 hours per week · Education: · Expérience: · Education · Bachelor's degree · Tasks · Design and develop database · Operate database management systems to analyze data · Develop and implement data a ...

  • Secure Digital Markets

    Database Analyst

    3 days ago

    Secure Digital Markets Toronto, Canada

    Salary: · **What We Offer** · At Secure Digital Markets (SDM), you can build a career out of making things happen Secure Digital Markets provides institutions, miners and individuals with a custom pathway to digital asset liquidity and off-exchange transactions. As one of Canada' ...

  • Unisystech Consulting inc.

    Database Analyst

    1 week ago

    Unisystech Consulting inc. Toronto, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 years · **Tasks**: · - Collect and document user's requirements · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - Operate database ma ...

  • Secure Digital Markets

    Database Analyst

    21 hours ago

    Secure Digital Markets Toronto, Canada

    **What We Offer** · At Secure Digital Markets (SDM), you can build a career out of making things happen Secure Digital Markets provides institutions, miners and individuals with a custom pathway to digital asset liquidity and off-exchange transactions. As one of Canada's largest ...

  • Aston Carter

    Data Analyste Assurances H/F

    1 week ago

    Aston Carter Toronto, ON, Canada

    Prepares Equipment packages (Schedule A) using equipment layouts for new openings and renovation projects · • Works directly with the Project Managers and external vendors to ensure equipment packages are prepared accurately and on time · • Works with Development and external A ...

  • Flyinger Solutions Ltd.

    Database Analyst

    6 days ago

    Flyinger Solutions Ltd. Toronto, Canada

    Education: Bachelor's degree · - Experience: 2 years to less than 3 years · **Tasks**: · - Collect and document user's requirements · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - Operate database m ...

  • Property Realty Inc.

    Database Analyst

    2 days ago

    Property Realty Inc. Toronto, Canada

    Education: College/CEGEP · - Experience: 2 years to less than 3 years · **Tasks**: · - Collect and document user's requirements · - Data Science · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - Opera ...

  • VRIZE CANADA INC.

    Database Analyst

    5 days ago

    VRIZE CANADA INC. Toronto, Canada

    Work Term: Permanent · - Work Language: English · - Hours: 35 hours per week · - Education: Bachelor's degree · - Experience: 3 years to less than 5 years · **Work setting**: · - Consulting firm · **Tasks**: · - Collect and document user's requirements · - Design and develop data ...

  • Dawn InfoTek Inc.

    Database Analyst

    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 ...

  • CanPacific College of Business & English

    Database Analyst

    5 days ago

    CanPacific College of Business & English Toronto, Canada

    Education: Bachelor's degree · - Experience: 7 months to less than 1 year · - or equivalent experience · **Work setting**: · - School or educational institution/establishment · **Tasks**: · - Design, construct, modify, implement and test data models and database management system ...

  • Ronald McDonald House Charities Toronto

    Donor Database Analyst

    21 hours ago

    Ronald McDonald House Charities Toronto Toronto, Canada

    **Donor Database Analyst** · **Full Time, Permanent** · Toronto, Ontario (240 McCaul Street) · **The Organization** · Since 1981, Ronald McDonald House Charities (RMHC) Toronto has served as a place to call home for families with seriously ill children undergoing treatment. RMHC ...

  • Nuclear Waste Management Organization (NWMO)

    Geoscience Database Analyst

    5 days ago

    Nuclear Waste Management Organization (NWMO) Toronto, Canada

    **Location** · Toronto · **Employment Category** · Fixed Term · **Department** · Geoscience · **Job Reference** · 10208 · The Nuclear Waste Management Organization (NWMO) is a not-for-profit organization tasked with the safe, long-term management of Canada's used nuclear fuel ins ...

  • Ontario Energy Board

    Analyst, Reporting and Database

    1 week ago

    Ontario Energy Board Toronto, Canada

    Overview: · This Division is responsible for all aspects of corporate financial management and reporting, information technology strategies and plans as well as other organizational service functions including procurement, risk management, internal audit, emergency/contingency pl ...

  • College of Massage Therapists of Ontario (CMTO)

    Data Analyst

    1 day ago

    College of Massage Therapists of Ontario (CMTO) Toronto, Canada

    CAREER OPPORTUNITY · DATA ANALYST · WHO WE ARE · The College of Massage Therapists of Ontario (CMTO) regulates Registered Massage Therapists (RMTs) in Ontario. We are dedicated to excellence in protecting the public interest, guiding RMTs and promoting the highest possible qualit ...

  • Capgemini

    Data Analyst

    1 day ago

    Capgemini Toronto, Canada

    Job Description · Job Title: Data Analyst · - Job Location: Toronto, Canada · - Job Type: Full time · - 7 years of experience as Data Analyst · - Excellent analytical communication and presentation skills · - Proven experience in various project delivery methodologies such as Ite ...

  • Lumenus Community Services

    Data Analyst

    1 day ago

    Lumenus Community Services Toronto, Canada

    Lumenus Community Services is seeking a Data Analyst who will support departmental activities including organizational ensuring data quality, data analysis and reporting, databases maintenance, and various program support activities. They will work closely with the Department's M ...

  • Lumenus Community Services

    Data Analyst

    3 days ago

    Lumenus Community Services Toronto, Canada

    **Data Analyst** · **LOCATION: Toronto, ON (Hybrid)** · **POSITION TYPE: Full-time Fixed Term (37.5 hours/week) 1 Year Contract** · **CLOSING DATE: March 27, 2024** · Lumenus Community Services is seeking a Data Analyst who will work closely with the Organizational Excellence Dep ...