2183 Visio Jobs - Page 47

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Key Responsibilities As an EE you will be working in highly technical, flexible environment with top level exposure to all cutting-edge technologies and legacy system. You will have the opportunity to engage in the PLCs from concept designs to volume manufacturing for the modules/systems enabling to solve the High value problems of our customers. You will be offered unique opportunities and challenges to get interfaced with our customers and suppliers. Applied continues to grow and is the #1 Semiconductor Manufacturing Company in the industry. Key Responsibilities Design or modify electrical/electronic engineering assemblies, layouts/schematics and/or detailed drawings/specifications of moderate scope under general supervision. Problem identification and troubleshooting a variety of complex electrical problems with limited supervision. Define, Coordinate, Generate electrical product specifications and engineering test reports. Conduct obsolescence risk assessment for prompt risk mitigation strategy and implementation to ensure product manufacturability and sustenance. Technically lead and/or execute engineering projects, including development of key suppliers. Coordinate the procurement and assembly of electrical/electronic components/equipment and identify sources of critical parts and subsystems to resolve technical issues Collaborate with stakeholders for recommendations and approvals on alternate solutions including testing, qualifications and re-designs requirements and secure sufficient inventory on basis of supply-demand projections and product roadmaps. Participate in resolving customer complaints & escalations through root-cause analysis and corrective-preventive actions. Implement concepts for product issues and electrical solutions of moderate difficulty Review and Execute engineering document changes ensuring compliance to standard procedures. Determines effect of ECOs on products and processes; adequately ascertains who needs to be included in the evaluation, disposition, assignment, definition, approval and implementation of the ECO; routes ECOs. Maintain records of the obsolescence projects incl. priority, mitigation actions, status, etc. Complete assigned projects / tasks ensuring compliance to productivity and quality goals. Participate in resolving customer complaints & escalations through root-cause analysis and corrective-preventive actions. Participate in continuous improvement initiatives and contribute to increase team’s overall effectiveness. Strong Communication skills and Cross functional team coordination. Excellent aptitude for multi-tasking and willing to learn. Functional Knowledge Knowledge of electrical systems and components like Control system, Power electronics etc. in designs. Knowledge in Industrial drives, Servo Motor drives and other electrical devices. Understanding of end-to-end parameters of electrical/electromechanical components such as Switch gear items like MCB, MCCB, contactors, fuses, relays, switches, SSR, RF Generators, Sensors, Filters etc. Motor Driver and controller design, election and integration Critical Power and control components for the Application, Motor drives and control system. Prepare /Review Instrument Index, I/O list, Control Architecture, panel design and knowledge in selection of instrument parts like pressure transmitter, pressure gauge, vacuum gauges, thermo couples, RTD sensor, flow transmitters, PID controllers. Thorough technical knowledge of electrical engineering design concepts and applications - components, schematics, electrical system, OEM selection. Electrical CAD tools: E3s, AutoCAD Electrical, Zuken, LabVIEW etc. will be a plus. Test fixture build experience will be a plus. Hands on experience with component & system level troubleshooting and handling various laboratory equipment. Knowledge in product certification process (Handle testing at EMC/ Safety) labs is preferred. Knowledge in Documentation, release process, Reliability testing. Engineering change management methodology. Working Knowledge on any Engineering change management software packages like, Oracle, SAP etc., Knowledge on PLM software like, TCE (Team Center Engineering) will be plus. Demonstrated computer skills to include MS Office, Visio and/or other software / systems necessary for the performance of the job. Qualifications Bachelor's Degree in Electrical Engineering / Electronics & Communication Business Expertise Understands key business drivers; uses this understanding to accomplish own work Leadership No supervisory responsibilities but provides informal guidance to new team members Problem Solving Solves problems in straightforward situations; analyzes possible solutions using technical experience and judgment and precedents Impact Impacts quality of own work and the work of others on the team; works within guidelines and policies Interpersonal Skills Explains complex information to others in straightforward situations Qualifications Education: Bachelor's Degree Skills Certifications: Languages: Years of Experience: 2 - 4 Years Work Experience: Additional Information Shift: Swing (India) Travel: No Relocation Eligible: Yes Applied Materials is an Equal Opportunity Employer committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, national origin, citizenship, ancestry, religion, creed, sex, sexual orientation, gender identity, age, disability, veteran or military status, or any other basis prohibited by law. Show more Show less

Key Responsibilities Develops, implements, and maintains methods, operation sequence and processes in the fabrication of parts, components, sub-assemblies and final assemblies. Interfaces with other engineering functions to coordinate the release of product improvements and/or new products. Launches, releases, approves and implements or issues engineering change requests as required to support design engineering and Operations with new and existing products. Estimates manufacturing costs, determines time standards and makes recommendations for tooling and process requirements. Uses DFx principles to reduce manufacturing and/or product costs, and improve delivered product quality. Develops and uses test procedures, including assisting with the definition of test specifications with design / software engineering. May work with test engineering on the design and development of text fixtures. May assist in the coordination of test fixture sourcing activities. Gathers operational and test data and evaluates results; may takes corrective/continuous improvement actions. Evaluates work methods, procedures and policies. Participates in the development and maintenance of new and existing business processes; updates as necessary to ensure current practices are documented. Determines root cause and corrective action analysis for issues that arise during assembly and/or test of systems; provides failure analysis report as required. Performs Process Failure Mode, Effects and Criticality Analysis when working with New Product Development. Other Requirements: This position may require standing for extended periods of time, walking, working in tight spaces, bending, squatting, twisting, kneeling, reaching, lifting, the ability to distinguish between colors, the ability to work in an environment with noise that may be difficult for some individuals with sensitivity to noise, and the use of hand and power tools. Additionally, because this position also may involve working in a clean room, the use of appropriate Personal Protective Equipment such as coveralls, hoods, booties, safety glasses, gloves, respirators, chemical aprons, and face shields may be required. Functional Knowledge Demonstrates expanded conceptual knowledge in own discipline and broadens capabilities Business Expertise Understands key business drivers; uses this understanding to accomplish own work Leadership No supervisory responsibilities but provides informal guidance to new team members Problem Solving Solves problems in straightforward situations; analyzes possible solutions using technical experience and judgment and precedents Impact Impacts quality of own work and the work of others on the team; works within guidelines and policies Interpersonal Skills Explains complex information to others in straightforward situations Role Overview : The OMS - Manufacturing Engineer is responsible for manufacturing documentation, taking them from initial drafts to volume manufacturing ioms. The daily tasks include review, validation and modification of OMS’s to facilitate manufacturing/assembly at the supplier level and in Applied Materials manufacturing operations. The OMS ME uses modeling and drafting software routinely in the course of their role, principally Unigraphics/NX. They also use Team center to access designs/models. Knowledge of semiconductor manufacturing processes and the ability to engage with manufacturing floor to resolve issues is an added qualification for the OMS ME role. Responsibilities: Create Operation Method Sheet (OMS) for aid Mfg. assemblers build complex Applied systems. Interfaces with Manufacturing Engineers, technicians and Quality to develop/update optimal operation sequences for parts and assemblies. Performs other duties as assigned. Duties will vary according to the project in progress and/or the specific goals of the department in which the incumbent works. Job Specific Knowledge: Product structure, bill of materials, product safety requirements, material handling, and root cause analysis. Requires demonstrated knowledge of manufacturing engineering discipline, theories, practices and principles. Requires knowledge necessary to perform the job function such as an understanding of the engineering change order process, product development process, value engineering etc. Skills: Requires strong skills in Product technology, change management, problem solving, communication skills, customer orientation, personal effectiveness, team skills, and quality. Working knowledge of CAD tools (UG-NX & Team center) Requires additional knowledge of systems and software necessary such as MS Visio, MS Word, Excel, PowerPoint. Qualifications Education: Bachelor's Degree Skills Certifications: Languages: Years of Experience: 2 - 4 Years Work Experience: Additional Information Shift: Swing (India) Travel: Yes, 10% of the Time Relocation Eligible: Yes Applied Materials is an Equal Opportunity Employer committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, national origin, citizenship, ancestry, religion, creed, sex, sexual orientation, gender identity, age, disability, veteran or military status, or any other basis prohibited by law. Show more Show less

Job Description KPMG in India, a professional services firm, is the Indian member firm affiliated with KPMG International and was established in September 1993. Our professionals leverage the global network of firms, providing detailed knowledge of local laws, regulations, markets, and competition. KPMG has offices across India in Ahmedabad, Bengaluru, Chandigarh, Chennai, Gurugram, Hyderabad, Jaipur, Kochi, Kolkata, Mumbai, Noida, Pune, and Vadodara. KPMG in India offers services to national and international clients in India across sectors. We strive to provide rapid, performance-based, industry-focused, and technology-enabled services, which reflect a shared knowledge of global and local industries and our experience of the Indian business environment KPMG Advisory professionals provide advice and assistance to enable companies, intermediaries, and public sector bodies to mitigate risk, improve performance, and create value. KPMG firms provide a wide range of Risk Advisory and Financial Advisory Services that can help clients respond to immediate needs as well as put in place the strategies for the longer term. Projects in IT Advisory focus on the assessment and/or evaluation of IT systems and the mitigation of IT-related business risks. They are either IS audit, SOX reviews, Internal audit engagements, IT infrastructure review and/or risk advisory including but not limited to IT audit supports in nature. Responsibilities Skills Required: Risk Based IT Internal Audit for Financial Services Entities IT SOX 404 Controls Testing, Quality Assurance Internal Financial Controls related to IT General Controls as part of Financial Statements Audits IT Risk & Control Self-Assessment Business Systems Controls / IT Application Controls Auditing Emerging Technologies such as Cloud Security, Intelligent Automation, RPA, IoT etc. Working knowledge of programming languages(C/C++/Java/SQL) Role Collaborate with other members of the engagement team to plan the engagement and develop relevant workpapers/deliverables. Perform fieldwork and share the daily progress of fieldwork, informing supervisors of engagement status. Perform testing of IT Application Controls, IPE, and Interface Controls through code reviews, IT General Controls review covering areas such as Change Management, Access Management, Backup Management, Incident and Problem Management, SDLC, Data Migration, Batch Job scheduling/monitoring and Business Continuity and Disaster Recovery Perform Risk Assessment, identification, and Evaluation of Controls, prepare process flow diagrams and document the same in Risk & Control Matrix. Perform business process walkthrough and controls testing for IT Audits. Performing planning and executing audits, including: — Information Security reviews — Information Technology Infrastructure reviews — Application reviews Use knowledge of the current IT environment and industry IT trends to identify the engagement and client service issues and communicate this information to the project manager. Maintain relationships with client management and the project Manager to manage expectations of service, including work products, timing, and deliverables. Demonstrate a thorough understanding of complex information systems and apply it to client situations. Use extensive knowledge of the client's business/industry to identify technological developments and evaluate impacts on the work to be performed Risk Based IT Internal Audit for Financial Services Entities IT SOX 404 Controls Testing, Quality Assurance Internal Financial Controls related to IT General Controls as part of Financial Statements Audits IT Risk & Control Self-Assessment Business Systems Controls / IT Application Controls Auditing Emerging Technologies such as Cloud Security, Intelligent Automation, RPA, IoT etc. Working knowledge of programming languages(C/C++/Java/SQL) Coordinate effectively and efficiently with the Engagement manager and the client management keeping both constantly updated regarding project’s progress. Monitoring and Tracking for Budget and Time Estimates on engagements. Conducting IT audits, IT Internal Audit, Robotics Process Automation (RPA) Audits Conducting SOX audits, Third Party Security audits Conducting controls assessment in manual/ automated environment Information Security Assessments Conducting OS/DB/Network reviews Prepare/Review of Policies, Procedures, SOPs Qualifications A Bachelor's degree in engineering and approximately 2 -6 years of related work experience; or a master’s or MBA degree in business, computer science, information systems, engineering Expertise in coding skills (e.g., Java, C++, C, SQL, Oracle) Experience in performing IT audits of banking/financial sector applications Good to have knowledge of other IT regulations, standards and benchmarks used by the IT industry (e.g., NIST, PCI-DSS, ITIL, OWASP, SOX, COBIT, SSAE18/ISAE 3402 etc.) Technical Knowledge of IT Audit Tools Experience in carrying out OS/DB/Network reviews Exposure to Risk Management and Governance Frameworks/ Systems will be an added advantage Exposure to ERP systems will be added advantage Experience in performing technical code reviews (understanding code logic based on business requirement) Strong project management, communication (written and verbal) and presentation skills A team player Strong self-directed work habits, exhibiting initiative, drive, creativity, maturity, self-assurance, and professionalism Preferred Certifications – CISA/CISSP//CISM Exposure to automation Data Analytics tools such as QlikView/Qlik sense, ACL, Power BI will be an advantage Proficiency with Microsoft Word, Excel, Visio, and other MS Office tools Equal employment opportunity information KPMG India has a policy of providing equal opportunity for all applicants and employees regardless of their colour, caste, religion, age, sex/gender, national origin, citizenship, sexual orientation, gender identity or expression, disability, or other legally protected status. KPMG India values diversity and we request you to submit the details below to support us in our endeavour for diversity. Providing the below information is voluntary and refusal to submit such information will not be prejudicial to you. Show more Show less

Skills: MIS preparation, AutoCAD, Asset Management, Budget & Cost Control, coordination, Purchase requisitions & Purchase Orders, Expense Reporting, Mandatory Skills Proficiency in MS Word/, PowerPoint/Excel/Project/Visio Excellent verbal and written communication skills. Soft skills Interpersonal relationship management, Time Management, etc. Responsibilities Asset Management Updation of Asset Master and O&M history for Assets. Contracts Management Co-ordination with vendors for AMCs/ARCs Co-ordination with vendors for HR / IR Compliances Tracking expiry of Contracts/Warranties, etc. Budget & Cost Control (Capex & Opex) Preparation, monitoring & control of Opex & Capex proposals and budgets. Preparation of MIS (Daily/Weekly/Monthly) General Receive Specs from the Project Team to compile and forward to Vendors for quotations. Obtain quotations from various Vendors. Co-ordination with the Procurement and Commercial team for releasing Purchase requisition and Purchase Orders. Co-ordination with Warehouse/Stores for availability & delivery of material to various locations Release of work orders to respective teams for ensuring completion of provisioning activities. Updation/Modification of all associated records (Documents/Drawings/Tracking Sheets) Maintain Annual Maintenance Contract (AMC) Equipment Track Sheet for all IDCs for monitoring Warrantee of Equipment & Renewals of AMC. Maintain records and Release Reports related to Budgetary/Procurement/Material availability (Purchase requisitions & Purchase Orders etc.) Tracking Budget month month-wise/discipline-wise/location-wise Who can apply? Graduate in any stream, preferably in Commerce. Experience of 3 to 4 Years in MIS preparation & Autocad Show more Show less