Specialized IT Consultant

3 weeks ago

Toronto, Canada AMISEQ Full time

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

  • Specialized IT Consultant

    4 weeks ago

    Toronto, Canada Global Pharma Tek Full time

    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 migration. Hands-on experience in configuring EBS with SSO with knowledge of...

  • .NET Specialized IT Consultant

    4 weeks ago

    Toronto, Canada Cleo Consulting Full time

    **Assignment: RQ05977 - Specialized IT Consultant - Intermediate** **Start Date: 2023-12-04** **End Date: 2024-03-29** **Office Location: 777 Bay St, Suite 423** **Organization: Community Services Cluster** **Ministry: Ministry of Education** **# Business Days: 140.00** **Title: Specialized IT Consultant** **Hybrid: 3 days on site 2...

  • Sr. Specialized IT Consultant

    1 month ago

    Toronto, Canada Global Pharma Tek Full time

    Position: Specialized IT Consultant Location: Toronto, ON(Hybrid) Duration: Business Days + Extension Job Description: Demonstrated Technical Skills with + Years of Experience Designing and Implementing Oracle Planning Budgeting Cloud Solutions (PBCS): Specific skills: Provide functional and technical consultation in projects that leverage...

  • RQ06673 Specialized IT Consultant

    4 days ago

    Toronto, Canada Randstad Canada Full time

    This is a contract position for a Specialized IT Consultant for our public sector client.Work location: Downtown TorontoDuration: Twelve Months7.25 hours/dayThis 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.)AdvantagesGood...

  • RQ07187 Specialized IT Consultant

    4 days ago

    Toronto, Canada Randstad Canada Full time

    This is a contract position for a Specialized IT Consultant for our public sector client.Work location: Downtown TorontoDuration: Twelve Months7.25 hours/dayThis 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.)AdvantagesGood...

  • SAS Consultant

    3 weeks ago

    Toronto, Canada Smart IT Frame LLC Full time

    Hi, Greetings from Smart IT Frame, Hope you are doing well!!! Smart IT Frame specializes in enabling you with your most critical line of resources. Whether it’s for permanent staffing, contract staffing, contract-to-hire or executive search, we understand the importance of delivering the most suitable talent; on time and within budget. With our Core focus...

  • SAS Consultant

    3 weeks ago

    Toronto, Canada Smart IT Frame LLC Full time

    Hi,Greetings from Smart IT Frame, Hope you are doing well!!!Smart IT Frame specializes in enabling you with your most critical line of resources. Whether it’s for permanent staffing, contract staffing, contract-to-hire or executive search, we understand the importance of delivering the most suitable talent; on time and within budget. With our Core focus in...

  • SAS Consultant

    3 weeks ago

    Toronto, Canada Smart IT Frame LLC Full time

    Hi,Greetings from Smart IT Frame, Hope you are doing well!!!Smart IT Frame specializes in enabling you with your most critical line of resources. Whether it’s for permanent staffing, contract staffing, contract-to-hire or executive search, we understand the importance of delivering the most suitable talent; on time and within budget. With our Core focus in...

  • RQ07158 Specialized IT Consultant

    4 days ago

    Toronto, Canada Randstad Canada Full time

    This is a contract position for a Specialized IT Consultant for our public sector client.Work location: North YorkDuration: Twelve Months7.25 hours/dayThis 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.)AdvantagesGood...

  • RQ07159 Specialized IT Consultant

    4 days ago

    Toronto, Canada Randstad Canada Full time

    This is a contract position for a Specialized IT Consultant for our public sector client.Work location: North YorkDuration: Twelve Months7.25 hours/dayThis 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.)AdvantagesGood...

  • RQ06356 Specialized IT Consultant

    4 days ago

    Toronto, Canada Randstad Canada Full time

    This is a contract position for a Specialized IT Consultant for our public sector client.Work location: North YorkDuration: Six Months7.25 hours/dayThis 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.)AdvantagesGood...

  • Specialized IT Consultant

    4 weeks ago

    Toronto, Canada Global Pharma Tek Full time

    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 applications. Demonstrated knowledge of testing and implementation methods for...

  • RQ07160 Specialized IT Consultant

    4 days ago

    Toronto, Canada Randstad Canada Full time

    This is a contract position for a Specialized IT Consultant for our public sector client.Work location: OrilliaDuration: Six Months7.25 hours/dayThis 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.)AdvantagesGood compensation...

  • RQ06494 Specialized IT Consultant

    4 days ago

    Toronto, Canada Randstad Canada Full time

    This is a contract position for a Specialized IT Consultant for our public sector client.Work location: Downtown TorontoDuration: Twelve Months7.25 hours/dayThis 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.)AdvantagesGood...

  • RQ06589 Specialized IT Consultant

    4 days ago

    Toronto, Canada Randstad Canada Full time

    This is a contract position for a Specialized IT Consultant for our public sector client.Work location: North YorkDuration: Five Months7.25 hours/dayThis 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.)AdvantagesGood...

  • Specialized IT Consultant

    4 weeks ago

    Toronto, Canada Thought storm Full time

    **Start Date**:2024-04-02** **End Date**:2025-04-04** **Client**:Ministry of Health** **Position**:RQ06105 - Specialized IT Consultant Junior** **Location**:56 Wellesley St. West Toronto** Supplier Comments Closing Date/Time 2023-11-07, 1:15 p.m. Maximum # of submissions: 1 **Must Haves**: - Experience with Microsoft Dynamics GP, BSSI HFM and...

  • RQ06260 Specialized IT Consultant

    4 days ago

    Toronto, Canada Randstad Canada Full time

    This is a contract position for a Specialized IT Consultant for our public sector client.Work location: North YorkDuration: Six Months7.25 hours/dayThis 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.)AdvantagesGood...

  • Junior Specialized IT Consultant

    4 weeks ago

    Toronto, Canada AMANST Inc Full time

    AMANST Inc. is looking for **Junior Specialized IT Consultant **for a contract opportunity with Ontario Government. **Estimated Business Days**: 355 days **Must Haves** Demonstrated ability in: - Experience developing Excel macros. - Advanced level of proficiency with MS Excel. - Basic to intermediate knowledge of SQL, ideally in an Oracle RDBMS...

  • RQ07203 Specialized IT Consultant

    4 days ago

    Toronto, Canada Randstad Canada Full time

    This is a contract position for a Specialized IT Consultant for our public sector client.Work location: Downtown TorontoDuration: Four Months7.25 hours/dayThis 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.)AdvantagesGood...

  • Specialized IT Consultant

    4 weeks ago

    Toronto, Canada ydc pro Inc Full time

    Hi All, We are looking for IT Consultant, Please find the Job details below. Client: Ministry of Public and Business Service Delivery (former MGCS) Location: 222 Jarvis Street, Toronto ON work Mode - Hybrid 3 days a week **Must have Skills** - 7+ years experience managing multiple complex concurrent projects as an integrated program/portfolio. - 7+ years...