Specialized I&IT Consultant

2 weeks ago


Toronto, Ontario, Canada Capleo Global Full time
Title Specialized IT Consultant - Intermediate
Location: Toronto, ON (Hybrid)
Duration: 251 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 (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 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.
  • 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.
  • 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

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


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


  • Toronto, Ontario, 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 - IntermediateLocation: Toronto, Ontario (Hybrid)Duration: Long Term ContractEmployment: ContractMust-haves: Lean Six Sigma certified, Blackbelt is preferred Experience with Capital...


  • Toronto, Ontario, Canada Capleo Global Full time

    Position: Specialized IT Consultant – SeniorLocation: Toronto, ON(Hybrid)Duration: 6 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 efficiency of an...


  • Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled Specialized IT Consultant - Seniorfor one of our clients.Position: Specialized IT Consultant - SeniorLocation: Toronto, Ontario (Hybrid)Duration: Long Term ContractMust haves- Skills in implementing planning and reporting solutions in oracle planning budgeting cloud service...


  • Toronto, Ontario, 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 - IntermediateClient: Community Services Cluster / Ministry of EducationWork Location: Hybrid / 777 Bay St, Suite 423, TorontoEstimated Start Date:Estimated End Date:#Business Days: 251.00Extension:...


  • Toronto, Ontario, Canada Ministry of Natural Resources and Forestry Full time

    Are you a strategic-minded individual with experience in I&IT delivery and would like to support ministries in the adoption of modern IT solutions and platforms? Do you have strong relationship building skills and experience working with a variety of stakeholders? Are you interested in working in a fast-paced, strategic, delivery-oriented, and inclusive...


  • Toronto, Ontario, Canada Foilcon Full time

    HM Note: This hybrid role is three (3) days in officeResponsibilities: and nbsp;Provides a comprehensive range of I and amp;IT business analysis services for clients with diverse business and technological needs. and nbsp;Interacts with the business stakeholders and subject matter experts in order to understand their requirements through gathering,...


  • Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time

    Company DescriptionWe are a minority owned staff augmentation and technology consulting companyTo 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 - Senior((Hyperion...


  • Toronto, Ontario, Canada Capleo Global Full time

    Position: Specialized IT ConsultantLocation: Toronto, ON (Hybrid)Duration: 6 Months Contract + Possible Extension Job Description:Technical Knowledge and experience:Hands-on in EBS Upgrade especially from to R12.2.10 Hand-on experience in Cross-platform database and EBS migration. Hands-on experience in configuring EBS with SSO with knowledge of Webgate and...


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


  • Old Toronto, Ontario, Canada AMISEQ Full time

    Specialized IT ConsultantToronto, ON - Hybrid role 10 Months ContractResponsibilities:Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, work to improve structure and efficiency of an organization's I&IT systems. The Vendor Resource will provide strategic guidance to...


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


  • Toronto, Ontario, Canada Capleo Global Full time

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


  • Toronto, Ontario, Canada LifeLabs Full time

    LifeLabs is the largest community diagnostics laboratory in Canada, serving the healthcare needs of Canadians for over 50 years. Our team members are truly centred around our customers, and we know that behind every lab requisition, sample being tested, or investment in technology is an individual and their family counting on us.Consistently named one of...


  • Toronto, Ontario, Canada vTech Solution Full time

    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.Role: Specialized IT Consultant - JuniorLocation: Toronto Ontario3 days a week and 2 days from homeTerm:12+Responsibilities: Lead,...


  • Toronto, Ontario, Canada BuzzClan LLC Full time

    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 workResponsibilities: Create, Submit, and Manage Change Requests related to TLS/SSL Certificate Renewals. Sign certificates with active certificate authority VOR. Update and Maintain OPS Configuration...


  • Toronto, Ontario, Canada LifeLabs Full time

    LifeLabs is the largest community diagnostics laboratory in Canada, serving the healthcare needs of Canadians for over 50 years. Our team members are truly centred around our customers, and we know that behind every lab requisition, sample being tested, or investment in technology is an individual and their family counting on us. Consistently named one of...


  • Toronto, Ontario, Canada LifeLabs Full time

    LifeLabs is the largest community diagnostics laboratory in Canada, serving the healthcare needs of Canadians for over 50 years. Our team members are truly centred around our customers, and we know that behind every lab requisition, sample being tested, or investment in technology is an individual and their family counting on us. Consistently named one of...


  • Toronto, Ontario, Canada AMISEQ Full time

    Specialized IT ConsultantToronto, ON - Hybrid role10 Months ContractResponsibilities:Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, work to improve structure and efficiency of an organization's I&IT systems. The Vendor Resource will provide strategic guidance to...


  • Toronto, Ontario, Canada OCAD University Full time

    OCAD University acknowledges the ancestral territories of the Mississaugas of the Credit, the Haudenosaunee, the Anishinaabeg and the Huron-Wendat, who are the original owners and custodians of the land on which we work, stand and create.__ Please note that internal job postings are open only to current permanent OPSEU Local 576 Unit 1 employees and...