Jobs
>
Toronto

    Specialized IT Consultant - Toronto, Canada - AMISEQ

    AMISEQ
    Default job background
    Description

    Specialized IT Consultant

    Toronto, ON

    12 Months

    MUST HAVES:

    Demonstrated deep Microsoft stack experience (10 Years) with at least 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

    Technical Skills:

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

    Strong problem-solving skills and ability to work collaboratively in a team.

    Data modelling experience with both star and snowflake schemas in MS SQL as well as Oracle databases

    Experience with Cognos/Informatica reporting solutions

    Experience with migration from Cognos/Informatica to Power BI solutions

    Strong development experience with ETL using SQL Server SSIS

    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.

    Experience and Skill Set Requirements

    Development -

    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.

    Design/Architecture -

    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 of Azure's security and compliance features is crucial to ensure data privacy and meet regulatory requirement.

    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 -

    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 -

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

    Strong problem-solving skills and ability to work collaboratively in a team.

    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

    Public Sector Experience

    Previous public sector experience in an organization of equivalent size or complexity to Ontario Public Service



  • Arthur Grand Technologies Inc Toronto, Canada

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Specialized IT Consultant - Senior**for one of our clients. · **Position: Specialized IT Consultant - Senior** · **Location: Toronto, Ontario (Hybrid)** · **Duration: Long Term Contract** · **Must hav ...


  • Arthur Grand Technologies Inc Toronto, Canada

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Specialized IT Consultant - Senior**for one of our clients. · **Position: Specialized IT Consultant - Senior** · **Location: Toronto, ON, Canada (Hybrid)** · **Duration: Long Term Contract** · Must ha ...


  • Arthur Grand Technologies Inc Toronto, Canada

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Specialized IT Consultant - Senior** for one of our clients. · **Position: Specialized IT Consultant - Senior** · **Location: Toronto, Ontario (Hybrid)** · **Hybrid - 3 days on site and 2 days remote* ...


  • Arthur Grand Technologies Inc Toronto, Canada

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Specialized IT Consultant - Intermediate** for one of our clients. · **Job Title: Specialized IT Consultant - Intermediate** · **Location: Toronto, Ontario (Hybrid)** · **Duration: Long Term Contract* ...


  • Arthur Grand Technologies Inc Toronto, Canada

    **Company Description** · We are a minority owned staff augmentation and technology consulting company · To keep our valued employees, we need to keep them engaged in challenging, interesting work, offer market-relevant benefits and provide continued opportunities for professiona ...


  • YDC PRO Consulting Toronto, Canada

    **Travel Requirements** - The resource(s) must be available to travel the same day or overnight in Ontario, as required. For this role, travel to school board locations across the province will be required. The resource(s) will work with the school boards and local public health ...


  • BuzzClan LLC Toronto, Canada

    Support TLS/SSL Certificate signing · - Support DCO Technical Services for other CRQ work loads · - Hybrid Work Environment - 3 days in the office, 2 days remote work · **Responsibilities**: · - Create, Submit, and Manage Change Requests related to TLS/SSL Certificate Renewals. · ...


  • iPartner Staffing Toronto, Canada

    Must have skills: · - Lean Six Sigma certified, Blackbelt is preferred · - Experience with Capital Asset Management and Planning · - Demonstrated knowledge and experience with IBM TRIRIGA · - Demonstrated experience developing training products and providing virtual training on I ...


  • EssilorLuxottica Halton Hills, Canada

    Requisition ID: · Store # : 00B178 Prem ON · Position: Part-Time · Total Rewards: · Joignez-vous à l'équipe Oakley et faites partie d'une équipe qui repousse les limites de la performance dans le sport et alimente la motivation des athlètes. Oakley offre des produits et des ...


  • vTech Solution North York, Canada

    Hi, · This is Anjali from vTech Solution, Inc. Hope you are doing well. · Wish to check if you would like to consider below job: If yes, kindly send me a copy of your resume in word format and work authorization status details. · **Position title: · - Specialized IT Consultant** ...


  • Oakley Halton Hills, Canada

    GENERAL FUNCTION · The Specialized Consultant is responsible for supporting the management team by demonstrating superior selling behaviors and Sales Floor leadership, promoting a positive work environment and executing operational processes and objectives in compliance with comp ...


  • Global Pharma Tek Toronto, Canada Contract

    Position: Specialized IT Consultant - Senior · Location: Toronto, ON · Duration: Months Contract · Experience and Skill Set Requirements: · Technical Knowledge: Knowledge of systems analysis and design methods to develop system solutions and manage servers and application ...


  • Global Pharma Tek Toronto, Canada Contract

    Position: Specialized IT Consultant · Location: Toronto, ON (Hybrid) · Duration: Months Contract + Possible Extension · Job Description: · Technical Knowledge and experience: Hands-on in EBS Upgrade especially from to · Hand-on experience in Cross-platform database and EBS ...


  • Computer Consultants International, Inc. Toronto, Canada

    HYBRID position at Toronto, Ontario · Must haves: · Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience. · Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, ...


  • Computer Consultants International, Inc. Toronto, Canada

    HYBRID position at Toronto, Ontario · Must haves: · Demonstrated Technical Skills with 5+ Years of Experience Designing and Implementing Oracle Planning Budgeting Cloud Solutions (PBCS) · Experience implementing PBCS modules such as planning, FCCS, Strategic modeling, Cost Manage ...


  • AMISEQ Toronto, Canada

    Specialized IT ConsultantToronto, ON12 Months · MUST HAVES:Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience.Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power ...


  • Pearle Hospitality Burlington, Canada

    **Job Purpose**: · As a part of the Sales Team, the person in the Special Event Consultant is able to maintain client relationships and provide the superior service Pearle Hospitality is known for. The Consultant is someone who can foster trust with clients while delivering that ...


  • Pearle Hospitality Burlington, Canada

    **Job Purpose**: · As a part of the Sales Team, the person in the Special Event Consultant is able to maintain client relationships and provide the superior service Pearle Hospitality is known for. The Consultant is someone who can foster trust with clients while delivering that ...


  • Randstad Canada Toronto, Canada Temporary

    This is a contract position for a Specialized IT Consultant for our public sector client. · Work location: North York · 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 ...


  • Randstad Canada Toronto, Canada Temporary

    This is a contract position for a Specialized IT Consultant for our public sector client. · Work location: North York · Duration: Five 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 t ...