Assignment: RQ06212 Specialized IT Consultant Intermediate
Start Date:
End Date:
Office Location: 777 Bay St Suite 423
Organization: Community Services Cluster
Ministry: Ministry of Education
# Business Days: 251.00
Title: Specialized IT Consultant
Hybrid Candidate must be able to work 3 days onsite and 2 remote 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 organizations 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. 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 changemanagement 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 problemsolving 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 Wellversed 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 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 Azures 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 Azurebased solutions. Collaborate with crossfunctional 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 datadriven decisionmaking. Data Modelling 20% 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 30% 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 problemsolving 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 5% Previous public sector experience in an organization of equivalent size or complexity to Ontario Public Service
