- 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.
- Provides subject matter expertise in their field and highly expert technical assistance.
- 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
- 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
- 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
- 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
- Previous public sector experience in an organization of equivalent size or complexity to Ontario Public Service
-
Intermediate Environmental Consultant
Found in: Jooble CA O C2 - 1 day ago
Pggroup Whitby, ON, CanadaAdvancing people, environment, and business. Does that statement resonate with you? Do you enjoy working with an engaged team toward a common goal? Do you regularly question the norm and come up with creative solutions to problems? If you've answered yes to any of these questions ...
-
Intermediate DQ Consultant
Found in: Talent CA C2 - 4 days ago
Adastra Markham, CanadaOverview · Adastra is currently seeking a Senior Data Quality and Data Management Consultant to join our growing Data Governance and Digital Practice. You will have the opportunity to work on dynamic projects in various industries. · Location: GTA, Ontario · Status: Full Time, P ...
-
Senior Collections Specialist
Found in: Appcast CA C2 A - 2 days ago
The Mason Group - Strategic Search Partners Toronto, CanadaOur client, in the elevator service industry is looking for a Senior Collections Specialist to join their team. This role is hybrid with 4 days a week in office located in Scarborough. · Reporting to the National Credit & Collections Manager, the Senior Collection Specialist is r ...
-
Control Engineer
Found in: Appcast CA C2 A - 2 days ago
Aiolos Engineering Corporation Toronto, CanadaAiolos is an engineering consulting firm, designing and producing advanced testing facilities in the Aerospace and Automotive sectors. We are headquartered in Toronto and deliver to a global market. · CONTROLS ENGINEER · The Intermediate Controls Engineer is a fully trained engi ...
-
Intermediate/ Senior Architectural Designer/ Architect
Found in: Appcast CA C2 A - 10 hours ago
ZO1 Architects Toronto, ON, CanadaIntermediate/ Senior Architectural Designer/ Architect (Façade and Master Plan Design) · ZO1 Ltd is a progressive architectural firm specializing in small to large-scale, high-density and multi-phase developments from concept design to construction completion. We are a group of ...
-
Intermediate/Senior Architectural Detailer
Found in: Appcast CA C2 A - 10 hours ago
ZO1 Architects Toronto, ON, CanadaIntermediate/Senior Architectural Detailer · ZO1 Ltd is a progressive architectural firm specializing in small to large-scale, high-density and multi-phase developments from concept design to construction completion. We are a group of passionate architects who has extensive desi ...
-
Senior Consultant, Business Intelligence
Found in: Appcast CA C2 A - 2 days ago
Carpedia International Ontario, CanadaSenior Consultant, Business Intelligence · Carpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable p ...
-
Wills and Estates Assistant
Found in: Appcast CA C2 A - 2 days ago
Kent Legal Toronto, CanadaJob Title: Wills and Estates Assistant · Job #: 16515 · Job Type: Full time, permanent · Location: Toronto · Salary: Commensurable with experience · Remote Flexibility: Hybrid Remote Flexibility After Training · Client Profile · Our client, a prominent law firm is currently loo ...
-
Senior Electrical Designers
Found in: Jooble CA O C2 - 2 days ago
CEM Engineering Toronto, ON, CanadaCEM Engineering is actively seeking an exceptional Intermediate/Senior Electrical Designer to join our dynamic team. As an Intermediate/Senior Electrical Designer, you will play a pivotal role in driving the renewable energy revolution forward. Our company is at the forefront of ...
-
Intermediate Full Stack Developer
Found in: Appcast CA C2 A - 9 hours ago
Sage Recruiting Toronto, CanadaSage Recruiting is looking for an Intermediate Full Stack Developer to join a leading proptech solution provider in North America. They're a fast-growing startup building enterprise software and were just named by Forbes as one of the top employers in the space. They are well-fun ...
-
Machine Learning Engineer
Found in: Appcast CA C2 A - 2 days ago
Bitstrapped Ontario, CanadaWe are seeking a highly skilled and experienced Machine Learning Engineer to join our team. As a Machine Learning Engineer, you will play a key role in developing and deploying machine learning models on Google Cloud, with a focus on generative AI and large language models, prima ...
-
Civil Engineer In Training/Engineer
Found in: Jooble CA O C2 - 2 days ago
Outpost Recruitment Toronto, ON, CanadaCivil Engineer, Water Infrastructure | Design Consultancy · ~ Civil infrastructure consultancy focused on the GTA region · Our client, a mid-sized engineering consultancy with an office in Toronto and Vancouver is looking for Intermediate/Senior Civil Engineer to join their gro ...
-
remote senior audit accountant
Found in: Jobgoal CA C2 - 1 day ago
Talentdepot Toronto, ON, CanadaOur customer is a tax, accounting and consulting firm that understands clients' needs and the full range of solutions available. We work within the rules to make the rules work for our clients. · About the Position · This is a hybrid position (2 days in office) for one of the t ...
-
Consultant(e) Economiste de la Construction
Found in: Jooble CA O C2 - 2 days ago
Outpost Recruitment Toronto, ON, CanadaMechanical & Electrical (MEP) Cost Consultant | Cost Consultancy · ~ Cost Consultancy · Leading cost consultancy operating within the P3, infrastructure and construction market · Our client is a leading Canadian cost consultancy and risk advisory firm operating within the P3, ...
-
Risk Project Management Coordinator H/F
Found in: Jooble CA O C2 - 2 days ago
S I Systems Toronto, ON, CanadaIntermediate Project Manager with experience working in the banking sector supporting Digital Business Transformation projects in the POS, Mobile, branding and marketing space. · Our client is a Global Leader on the Digital Hospitality and Food Services Space. They are looking f ...
-
Consultant Microsoft #télétravail
Found in: Jooble CA O C2 - 1 day ago
Ciellos Toronto, ON, CanadaAt Ciellos , we are committed to attracting and retaining the best and brightest to support our mission of excellence in Business Systems Consulting. Ciellos operates globally with regional locations in Ukraine, Albania, Portugal, Macedonia, Brazil, Canada, and USA , as well as s ...
-
Senior Consultant
Found in: Jooble CA O C2 - 2 days ago
AtkinsRéalis Toronto, ON, CanadaSenior Consultant - Environmental Assessment · AtkinsRéalis is dedicated in engineering a better future for our planet and its people. · Do you have the ambition, enthusiasm, and technical capability to work with us as a Senior Consultant in Environmental and Impact Assessment? ...
-
Remote Assistant
Found in: Jooble CA O C2 - 2 days ago
Kent Legal Toronto, ON, Canada Full timeWills and Estates Assistant Job #: 16515 · Job Type: Full time, permanent · Remote Flexibility: Hybrid Remote Flexibility After Training · Our client, a prominent law firm is currently looking for a Wills and Estates Assistant. Regional multi-service law firm known for their to ...
-
Judges
Found in: Jooble CA O C2 - 2 days ago
People Corporation Ontario, CanadaClaims Adjudicator to join our BPA team in North York. · The Junior Claims Adjudicator provides timely and accurate adjudication and reimbursement of benefit claims submitted by members covered under the L.Local 183 Member's Benefit Trust Fund. Claims Adjudicator will: · Respon ...
-
Full Stack Software Engineer
Found in: Jooble CA O C2 - 2 days ago
RAVL Inc. Toronto, ON, CanadaRAVL helps technologists accelerate their careers: · RAVL is revolutionizing technology delivery and cultivating a new wave of tech-savvy professionals. Established by visionary leaders with backgrounds at renowned consulting firms and technology organizations, RAVL aims to nurt ...
RQ06212 - Specialized IT Consultant - Intermediate - Toronto, Canada - Maarut Inc
Description
Responsibilities:
General Skills:
Technical Skills:
Requirements
Experience and Skill Set Requirements:
Must haves:
Skill Set Requirements:
Development:
Design/Architecture:
Data Modelling:
Technical skills:
Public Sector Experience: