Rq06212 - Specialized IT Consultant - Intermediate

3 weeks ago


Toronto, Canada Deop Inc. Full time

Hello,

Hope you are doing well. I would like to present to you a new job opportunity and I think you may find it interesting.

**Job Title: Specialized IT Consultant - Intermediate**

**Client: Community Services Cluster / Ministry of Education**

**Work Location: Hybrid / 777 Bay St, Suite 423, Toronto**

**Estimated Start Date**:2024-04-02

**Estimated End Date**:2025-03-31

**#Business** **Days: 251.00**
**Extension: 1 times**

**Hours per day or Week: 7.25 hours per day**
**Security Level: No Clearance Required**

**Updated Resume in word format (mandatory)**

**Expected hourly rate (mandatory)**

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

Description

**Responsibilities**:

- Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, works to improve 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.

**General Skills**:

- Acts as the technical advisor/expert on all aspects of a specific deliverable
- Provides the quality assurance/quality control of specific deliverables
- Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations
- Develops processes and procedures for implementing deliverables
- Prepares reports and presentations including options, recommendations, implementation plans, etc.
- Works with clients to define the scope of a project and to determine requirements
- Defines software, hardware and network requirements
- Analyzes I&IT requirements giving independent and objective advice on the use of I&IT
- Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems
- Familiar with change-management principles and methodology
- Knowledge and understanding of Information Management principles, concepts, policies and practices

**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 - 25%**
- 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 - 20%**
- 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



  • Toronto, Canada Arthur Grand Technologies Inc Full time

    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** **Employment: Contract** **Must-haves**: - Lean Six Sigma certified, Blackbelt...


  • Toronto, Canada LRI Engineering Inc. Full time

    **POSITION OVERVIEW** **ESSENTIAL JOB FUNCTIONS** The Intermediate Code Consultant will be asked to provide, at least, the following services to Clients and other staff members: - Manage project staffing, profitability, and timeliness - Project administration - Attending client meetings and meetings with Authorities Having Jurisdiction - Site review -...


  • Toronto, Canada Global Pharma Tek Full time

    Title Specialized IT Consultant - Intermediate Location: Toronto, ON (Hybrid) Duration: Business Days + Possible extension Job Description: 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...


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


  • Toronto, Canada Computer Consultants International, Inc. Full time

    HYBRID position at Toronto, OntarioMust 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...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    **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 professional growth. **Job Description** Position: Specialized IT Consultant -...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    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 haves: - **Solid hands-on Curam development **experience in ver. 6 and up (version...


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

  • SAS Consultant

    2 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

    2 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

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


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


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


  • Toronto, Canada AMISEQ Full time

    Specialized IT Consultant Toronto, ON 12 MonthsMUST 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...


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


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


  • Toronto, Canada AMISEQ Full time

    Specialized IT Consultant Toronto, ON12 MonthsMUST 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...


  • Toronto, Canada Global Pharma Tek Full time

    Position: Specialized IT Consultant – Senior Location: Toronto, ON(Hybrid) Duration: Months Contract + possible extension Responsibilities: Works in partnership with clients, advising them on information technology and cyber-security practices in order to meet their business objectives or overcome problems, work to improve structure and...


  • Toronto, ON, 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...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    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** **Duration: Long Term Contract** **MUST HAVES**: - Minimum 5 years’ hands-on...