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

Skills: T-SQL, SQL, SSIS, SSRS, High Availability (HA), Disaster Recovery, ETL, Greetings from Colan Infotech!! Designation - SQL DBA Experience - 7+ Years Job Location - Chennai Notice Period - Immediate to 15 Days Key Responsibilities Manage and maintain high-performance SQL Server databases supporting critical capital markets applications Perform backup, recovery, high availability (HA), and disaster recovery (DR) planning and implementation Optimize SQL queries, indexes, and database performance for large datasets typical of trading and market data systems Ensure data integrity and security in line with regulatory and compliance requirements Work closely with application development and infrastructure teams to support database integration and deployment Monitor database health, generate reports, and provide proactive solutions to potential issues Lead database upgrade and migration projects Support real-time data flows and batch processes used in trading, settlements, and market data analysis Implement and maintain replication, clustering, log shipping, and Always On availability groups. Required Skills & Qualifications 7+ years of experience as a MS SQL DBA Strong knowledge of SQL Server 2016/2019/2022, including internals, query tuning, and HA/DR features Experience working in Capital Markets, with understanding of trading systems, order management, or market data Solid understanding of T-SQL, performance tuning, and execution plans Familiarity with financial data handling, compliance (e.g., MiFID, FINRA), and low-latency data operations Experience with automation and scripting using PowerShell Strong troubleshooting and problem-solving skills Knowledge of data warehousing, ETL processes, and reporting tools (SSIS, SSRS) Ability to work in fast-paced, high-pressure financial environments Preferred Qualifications Experience with cloud-based SQL solutions (Azure SQL, AWS RDS, etc.) Exposure to DevOps practices and CI/CD for databases Certification in Microsoft SQL Server (e.g., MCSA, MCSE) Interested candidates send your updated resume to kumudha.r@colanonine.com Show more Show less

Line of Service Advisory Industry/Sector Not Applicable Specialism Microsoft Management Level Senior Associate Job Description & Summary At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency. These individuals analyse client needs, implement software solutions, and provide training and support for seamless integration and utilisation of business applications, enabling clients to achieve their strategic objectives. Those in Microsoft Dynamics ERP at PwC will specialise in analysing client needs, implementing ERP software solutions, and offering training and support for seamless integration and utilisation of Microsoft ERP applications. This will enable clients to optimise operational efficiency and achieve their strategic objectives. Why PWC At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more about us . *Responsibilities: Job Description: Minimal functional knowledge on SCM, finance, production operations, customer service etc • Conduct requirement gathering • Preparation of technical design document • Good understanding of solution architecture • Excel add-ins would be a plus • Knowledge of data entities • Knowledge of system administration and management • Project deployment with LCS and Azure DevOps Good understanding of Azure blobs and parallel process development in Logic and function apps • Support development of proposals and statement of work to include drafting estimation of effort/cost Application -D365 Finance & Operations AX2009 AX2012 Core Area / Modules- Strong knowledge in X++ • Functional extensions, forms, workflows, SSRS Report, Dynamic AX Report, Crystal Reports, Data Reports, Alert, Notification • Integration using various connectors • Azure components Rest Web Api and OData Entity • Event handlers • Data entity (DMF, OData) extension and development. • Database design • SQL Queries, Stored Procedures, Indexes, Views • TDD creation, Unit testing etc Competency / Capability / Experiences 3 to 5 years of relevant work experience • Strong communication and interpersonal skills • Ability to work with senior stakeholders • Ability to run high intensity workshops • Delivered 3-4 large implementations or equivalent • Uses creative ways to find solutions • Able to identify performance bottlenecks and fix it • Certified on latest product at desired levels • Team player • Proficient in delivery methodology (Sure Step Preferable) • Can plan and organize delivery of solution *Mandatory skill sets : D365 Technical Consultant *Preferred skill sets : D365 Retail, FRD creation , MS Dynamics finance & operation module *Years of experience required 4 to 6 Years *Education Qualification BE/ B.Tech Education (if blank, degree and/or field of study not specified) Degrees/Field of Study required: Bachelor of Engineering, Bachelor of Technology Degrees/Field of Study preferred: Certifications (if blank, certifications not specified) Required Skills Technical Consulting Optional Skills Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Business Continuity Management (BCM), Business Performance Management, Communication, Continuous Process Improvement, Creativity, Customization and Development, Data Flows, Data Integration, Delivery Excellence, Downtime Reduction, Embracing Change, Emotional Regulation, Empathy, Enterprise Resource Planning (ERP) Software, ERP Strategy, Implementation Research, Inclusion, Informatics, Intellectual Curiosity, Internal Control Consulting, IT Consulting {+ 17 more} Desired Languages (If blank, desired languages not specified) Travel Requirements Available for Work Visa Sponsorship? Government Clearance Required? Job Posting End Date Show more Show less

Line of Service Advisory Industry/Sector Not Applicable Specialism Microsoft Management Level Senior Associate Job Description & Summary At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency. These individuals analyse client needs, implement software solutions, and provide training and support for seamless integration and utilisation of business applications, enabling clients to achieve their strategic objectives. Those in Microsoft Dynamics ERP at PwC will specialise in analysing client needs, implementing ERP software solutions, and offering training and support for seamless integration and utilisation of Microsoft ERP applications. This will enable clients to optimise operational efficiency and achieve their strategic objectives. Why PWC At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more about us . *Responsibilities: Job Description: Minimal functional knowledge on SCM, finance, production operations, customer service etc • Conduct requirement gathering • Preparation of technical design document • Good understanding of solution architecture • Excel add-ins would be a plus • Knowledge of data entities • Knowledge of system administration and management • Project deployment with LCS and Azure DevOps Good understanding of Azure blobs and parallel process development in Logic and function apps • Support development of proposals and statement of work to include drafting estimation of effort/cost Application -D365 Finance & Operations AX2009 AX2012 Core Area / Modules- Strong knowledge in X++ • Functional extensions, forms, workflows, SSRS Report, Dynamic AX Report, Crystal Reports, Data Reports, Alert, Notification • Integration using various connectors • Azure components Rest Web Api and OData Entity • Event handlers • Data entity (DMF, OData) extension and development. • Database design • SQL Queries, Stored Procedures, Indexes, Views • TDD creation, Unit testing etc Competency / Capability / Experiences 3 to 5 years of relevant work experience • Strong communication and interpersonal skills • Ability to work with senior stakeholders • Ability to run high intensity workshops • Delivered 3-4 large implementations or equivalent • Uses creative ways to find solutions • Able to identify performance bottlenecks and fix it • Certified on latest product at desired levels • Team player • Proficient in delivery methodology (Sure Step Preferable) • Can plan and organize delivery of solution *Mandatory skill sets : D365 Technical Consultant *Preferred skill sets : D365 Retail, FRD creation , MS Dynamics finance & operation module *Years of experience required 4 to 6 Years *Education Qualification BE/ B.Tech Education (if blank, degree and/or field of study not specified) Degrees/Field of Study required: Bachelor of Engineering, Bachelor of Technology Degrees/Field of Study preferred: Certifications (if blank, certifications not specified) Required Skills Technical Consulting Optional Skills Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Business Continuity Management (BCM), Business Performance Management, Communication, Continuous Process Improvement, Creativity, Customization and Development, Data Flows, Data Integration, Delivery Excellence, Downtime Reduction, Embracing Change, Emotional Regulation, Empathy, Enterprise Resource Planning (ERP) Software, ERP Strategy, Implementation Research, Inclusion, Informatics, Intellectual Curiosity, Internal Control Consulting, IT Consulting {+ 17 more} Desired Languages (If blank, desired languages not specified) Travel Requirements Available for Work Visa Sponsorship? Government Clearance Required? Job Posting End Date Show more Show less

About The Role Grade Level (for internal use): 07 The Team This team partners with global Datafeed Application Specialists, Product Development, Product Management and Sales Teams to provide quality technical assistance to our external Enterprise Data Delivery Solution customers. This includes client-site environment sizing, product deployment, configuration, and performance tuning. The Impact You will be able to contribute to customers, the team and company in meaningful ways. You will be integrated into a group with high expectations, focus on quality user experiences and can expect to make a significant impact by demonstrating your technical knowledge and skills. Your position is essential as it is the link between the end-user and our Channels Data Delivery Products/Solutions. Combining expertise in our product and content offerings with a deep understanding of our customer profiles and target markets, you will act as a consultant providing the best and most efficient ways for our customers to use our tools to achieve quality results integrating our data into their internal mission-critical operational workflows and data environments. What’s in it for you? Build a career with a global company Partner with other product specialists and customers as a technical consultant Interact directly with clients and resolve challenging technical issues Learn the global financial markets and related content workflow needs Grow and improve your skills by working on enterprise level products and new technologies Experience different challenges on a daily basis Responsibilities Be a technical product specialist for our Channels Data Delivery solutions and provide in-depth technical assistance to clients Deploy/Support our Xpressfeed Loader application on our client’s enterprise level environments Assist in solution sizing, deployments, configurations and troubleshooting on-the-go Gain in-depth knowledge of products from a content and delivery standpoint, and assist with pre and post Sales’ opportunities Bring new ideas for innovation and automation excellence into the technical support process and build tools that will help replicate, troubleshoot, and resolve client issues Research and gain knowledge on the rapidly evolving product offerings Assess the technical dynamics within client environments that might impact product performance and recommend changes for improvement Involved in product strategy, roadmaps, and user-acceptance testing Client-side solution deployments, implementations, upgrades, and migrations Be the voice of the customers for product enhancements Core Qualifications What We’re Looking For: Degree in Computer Science, Information Systems, or equivalent experience Excellent communication skills (verbal, written and presentation) Demonstrated technical troubleshooting and problem-solving skills, resourcefulness, attention to detail, quality, and follow-through Technical product support or technical sales experience Must be confident and energized leading client-facing technical discussions Experience with software deployments & configuration Windows and Linux operating system knowledge SQL query skills Experience with cloud environments (AWS, MS Azure and/or Google Cloud) Solid knowledge of AWS (EC2, RDS/Aurora) environments Sizing, standing-up and deploying software and databases in AWS a PLUS Self-starter with ability to keep pace with rapid changes in evolving technologies Highly Desired Knowledge, Skills & Experience Finance related experience or degree Capital markets (financial, credit, trading, benchmarks/indexes, industries, etc.) SQL Server, Oracle, PostgreSQL and/or MySQL a PLUS Windows services and/or Linux daemon processes Windows system administration/security Linux administration/security Database administration FTP Protocols (FTP, SFTP, FTPS, etc.) & features/commands Proxies (HTTP/FTP) Network & Security Protocols Open source / evolving databases Product strategy and product development lifecycles (agile/scrum) Data integration concepts & techniques Data modeling, big data & alternative/unstructured data About S&P Global Market Intelligence At S&P Global Market Intelligence, a division of S&P Global we understand the importance of accurate, deep and insightful information. Our team of experts delivers unrivaled insights and leading data and technology solutions, partnering with customers to expand their perspective, operate with confidence, and make decisions with conviction. For more information, visit www.spglobal.com/marketintelligence. What’s In It For You? Our Purpose Progress is not a self-starter. It requires a catalyst to be set in motion. Information, imagination, people, technology–the right combination can unlock possibility and change the world. Our world is in transition and getting more complex by the day. We push past expected observations and seek out new levels of understanding so that we can help companies, governments and individuals make an impact on tomorrow. At S&P Global we transform data into Essential Intelligence®, pinpointing risks and opening possibilities. We Accelerate Progress. Our People We're more than 35,000 strong worldwide—so we're able to understand nuances while having a broad perspective. Our team is driven by curiosity and a shared belief that Essential Intelligence can help build a more prosperous future for us all. From finding new ways to measure sustainability to analyzing energy transition across the supply chain to building workflow solutions that make it easy to tap into insight and apply it. We are changing the way people see things and empowering them to make an impact on the world we live in. We’re committed to a more equitable future and to helping our customers find new, sustainable ways of doing business. We’re constantly seeking new solutions that have progress in mind. Join us and help create the critical insights that truly make a difference. Our Values Integrity, Discovery, Partnership At S&P Global, we focus on Powering Global Markets. Throughout our history, the world's leading organizations have relied on us for the Essential Intelligence they need to make confident decisions about the road ahead. We start with a foundation of integrity in all we do, bring a spirit of discovery to our work, and collaborate in close partnership with each other and our customers to achieve shared goals. Benefits We take care of you, so you can take care of business. We care about our people. That’s why we provide everything you—and your career—need to thrive at S&P Global. Our Benefits Include Health & Wellness: Health care coverage designed for the mind and body. Flexible Downtime: Generous time off helps keep you energized for your time on. Continuous Learning: Access a wealth of resources to grow your career and learn valuable new skills. Invest in Your Future: Secure your financial future through competitive pay, retirement planning, a continuing education program with a company-matched student loan contribution, and financial wellness programs. Family Friendly Perks: It’s not just about you. S&P Global has perks for your partners and little ones, too, with some best-in class benefits for families. Beyond the Basics: From retail discounts to referral incentive awards—small perks can make a big difference. For more information on benefits by country visit: https://spgbenefits.com/benefit-summaries Global Hiring And Opportunity At S&P Global At S&P Global, we are committed to fostering a connected and engaged workplace where all individuals have access to opportunities based on their skills, experience, and contributions. Our hiring practices emphasize fairness, transparency, and merit, ensuring that we attract and retain top talent. By valuing different perspectives and promoting a culture of respect and collaboration, we drive innovation and power global markets. Equal Opportunity Employer S&P Global is an equal opportunity employer and all qualified candidates will receive consideration for employment without regard to race/ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, marital status, military veteran status, unemployment status, or any other status protected by law. Only electronic job submissions will be considered for employment. If you need an accommodation during the application process due to a disability, please send an email to: EEO.Compliance@spglobal.com and your request will be forwarded to the appropriate person. US Candidates Only: The EEO is the Law Poster http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf describes discrimination protections under federal law. Pay Transparency Nondiscrimination Provision - https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf 20 - Professional (EEO-2 Job Categories-United States of America), OPRTON203 - Entry Professional (EEO Job Group) Job ID: 315004 Posted On: 2025-05-29 Location: Gurgaon, Haryana, India Show more Show less

Requirements Description and Requirements Position Summary The SQL Database Administrator is responsible for the design, implementation, and support of database systems for applications across the Enterprise . Database Administrator is a part of the Database end to end delivery team working and collaborating with Application Development, Infrastructure Engineering and Operation Support teams to deliver and support secured, high performing and optimized database solutions. Database Administrator specializes in the SQL database platform. Job Responsibilities Manages design, distribution, performance, replication, security, availability, and access requirements for large and complex SQL & Sybase databases. Designs and develops physical layers of databases to support various application needs; Implements back-up, recovery, archiving, conversion strategies, and performance tuning; Manages job scheduling, application release, database change and compliance. Identifies and resolves problem utilizing structured tools and techniques. Provides technical assistance and mentoring to staff in all aspects of database management; Consults and advises application development teams on database security, query optimization and performance. Writes scripts for automating DBA routine tasks and documents database maintenance processing flows per standards. Implement industry best practices while performing database administration task Work in Agile model with the understanding of Agile concepts Collaborate with development teams to provide and implement new features. Able to debug production issues by analyzing the logs directly and using tools like Splunk. Begin tackling organizational impediments Learn new technologies based on demand and help team members by coaching and assisting. Education, Technical Skills & Other Critical Requirement Education Bachelor’s degree in computer science, Information Systems, or another related field with 7+ years of IT and Infrastructure engineering work experience. Experience (In Years) 7+ Years Total IT experience & 4+ Years relevant experience in SQL Server + Sybase Database Technical Skills Database Management: Proficient in managing and administering SQL Server, Azure SQL Server, and Sybase databases, ensuring high availability and optimal performance. Data Infrastructure & Security: Expertise in designing and implementing robust data infrastructure solutions, with a strong focus on data security and compliance. Backup & Recovery: Skilled in developing and executing comprehensive backup and recovery strategies to safeguard critical data and ensure business continuity. Performance Tuning & Optimization: Adept at performance tuning and optimization of databases, leveraging advanced techniques to enhance system efficiency and reduce latency. Cloud Computing & Scripting: Experienced in cloud computing environments and proficient in operating system scripting, enabling seamless integration and automation of database operations. Management of database elements, including creation, alteration, deletion and copying of schemas. databases, tables, views, indexes, stored procedures, triggers, and declarative integrity constraints Strong database analytical skills to improve application performance. Strong knowledge in ITSM process and tools (ServiceNow). Ability to work 24*7 rotational shift to support the Database and Splunk platforms. Other Critical Requirements Automation tools and programming such as Ansible and Python Excellent Analytical and Problem-Solving skills Experience managing geographically distributed and culturally diverse workgroups with strong team management, leadership and coaching skills Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders. Prior experience in handling state side and offshore stakeholders Experience in creating and delivering Business presentations. Demonstrate ability to work independently and in a team environment About MetLife Recognized on Fortune magazine's list of the 2024 "World's Most Admired Companies" and Fortune World’s 25 Best Workplaces™ for 2024, MetLife , through its subsidiaries and affiliates, is one of the world’s leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East. Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by empathy, we’re inspired to transform the next century in financial services. At MetLife, it’s #AllTogetherPossible . Join us! Show more Show less

The IL Excellence Manager LSP Onboarding takes ownership of the onboarding of LSPs for new customers in Kuehne + Nagel Integrated Logistics. Your Role The Integrated Logistics Excellence Manager LSP Onboarding will be a member of the business field Integrated Logistics in Delhi, India. The IL Excellence Manager LSP Onboarding takes ownership of the onboarding of LSPs for new customers in Kuehne + Nagel Integrated Logistics. In his/her scope, the IL Excellence Manager LSP Onboarding will be responsible to ensure that all LSPs are properly onboarded into the agreed operations processes between KN IL and the customer, including connectivity between the LSP and KN IL for transport instruction provision and/or for shipment status provision. The IL Excellence Manager LSP Onboarding secures the adherence of LSPs to agreed SOPs and LSP operational performance in line with the agreed KPI targets during implementation. He/she develops a digital agenda with LSPs in terms of automation of operational process and real-time availability of shipment status information during onboarding. The position combines customer-/LSP-facing activities as well as internal stakeholder management. Your Responsibilities LSP Integration Manage the LSP integration process into the work stream of KN Integrated Logistics. Collect and prepare required LSP data for use in KN IL and customer systems. Run change management process with LSPs in roll-out of KN IL service portfolio. Lead LSP training and (EDI-) integration process. Promote digital agenda with LSPs in regards to accurate data provision, support of work process automation and technology enabled shipment status visibility. Business contingency plans (BCP) availability and emergency management during Hypercare Ensure business contingency plan is in place for customer’s business in alignment with customer and KNIL operations (e.g., back-up LSPs, routes, second LSP choice for critical lanes). Support of KN IL operations and customer in emergency situation resolution related to lack of LSP capacity, blocked shipments in transshipment ports, critical in-transit delays, customs clearance issues. Freight procurement management / support Strong customer focus, close collaboration with KNIL corporate procurement team. Consult customer on the best suitable rate card format for customer’s business / mode of transport during deployment. Leveraging on best KNIL practices, consult customer re. preparation, conducting and evaluation of transportation tenders. Utilize KN IL corporate procurement knowledge / resources / systems to drive value creation in freight procurement for customers. Setting up approach to spot procurement and supporting KNIL operational team in designing efficient and reliable spot procurement process. Market Intelligence Strong customer focus, close collaboration with KN IL corporate procurement team. Staying up-to-date in regards to current global / regional transportation market situation, capacity demand vs supply situation, transport rates / indexes trends. Providing market intelligence updates to customer leveraging on KN IL corporate information. GDP / GxP Compliance Compliance and realization of the pharma & healthcare standards of all activities in their full entity by considering the relevant GDP requirements and guidelines, customer demands and all internal regulations of the KN Wro organization. Adhere to, if applicable, KN Product standards such as KN Pharma Chain, KN Engine Chain etc. Compliance with required customer quality standards. Adhere to, if applicable, the WHO GDP guidelines (Technical report series) and EU guidelines latest versions. Your Skills And Experiences Minimum of 5 years with a strong track record in logistics operations. Solid understanding of the forwarding business with expertise in all modes of transport. Skilled in managing projects and stakeholders, including in virtual environments. Proven experience in cross-regional and global teamwork within a multinational setting. Ability to work autonomously, make sound decisions, and respond swiftly to solution implementation and customer needs. Willing to travel up to 30%. Good Reasons to Join As an employer, Kuehne+Nagel stands for equal opportunity and we are committed to diversity in our teams with regards to people with disabilities. We believe that you can make a valuable contribution to Kuehne+Nagel and look forward to receiving your application. Show more Show less

Job Description: Provides highly skilled technical support/delivery capability as technical lead for the current and future delivery, support, and maintenance of future production services in the technical operations environment. Leads technical and procedural consistency within a team focused on the implementation, service delivery, and support of products, systems, & networks. Leads initiatives for driving down incident rates and working with 1st line operations to improve service recovery times. Leads the implementation process to ensure that all aspects of operability are delivered whilst ensuring that existing service levels are maintained or improved. Complies with operational standards, procedures, and best practice. Operations Engineers within specialist functional teams may have compliance assurance responsibility. About the Role In this opportunity as Senior Software Engineer, you will Provides a high level of technical and subject matter expertise in one or more technologies and serves as a point of escalation for technical issues related to specialty. Produces, delivers, and maintains appropriate documentation for systems in accordance document control standards and procedures. Provide input to records, quality systems and management reports as required Contributes to the definition and implementation of improved operability on new and current systems. Uses innovative methods including the redesign of process and providing technical solutions to reduce the volume and mean time to recover incidents in assigned business unit. Identifies risks & issues and takes ownership to deliver appropriate resolutions. Provides technical expertise for root cause analysis and problem management. Provides detailed implementation/project plans across multiple, complex work streams according to agreed standards and ensures project processes and timelines are understood and followed. Works and cooperates with internal and external groups when required in order to fully support environments and maintain service. Adheres to change management procedures in defining, planning and implementing change in such a way that ensures appropriate coordination with other teams, minimizes service disruption, and ensures adherence to Service Level Agreements. Improves change management processes and procedures to ensure the most efficient processing of change within appropriate service risk constraints. Provides specialist support during complex and/or major incidents. May be asked to lead recovery efforts during major incidents within business unit. Deputize for the team manager as required. Contributes to or author technical documentation such complex changes instructions. Reviews, and updates as appropriate, operations procedures, standards, and technical policies. May be asked to assist with production of white papers on technical R&D projects Collaborates with business, third party vendors, developers, application support and technical operations groups to determine appropriate hardware/software needed and to resolve any issues impacting the application processes. Stays abreast of recent developments in related technical community, including new technology and business news that may impact vendors’ ability to provide service. Responsible to seek out all information and to fully understand all aspects of each device’s technology configuration and uses all approved engineering tools available to implement conforming change. Leads the analysis and design of complex solutions and requirements definition, including translating technical and business requirements into physical installations, costing design elements, and obtaining agreement to proposed solutions. Reviews and coordinates the implementation of proposed modifications, and changes to the production environment. Provides direction into standards and procedures for monitoring, capacity planning, tuning, maintenance, performance optimization, backups and recovery; ensures infrastructure will meet capacity requirements to deliver projects on time. Database Engineer: Provides direction for: proactive health and performance monitoring of databases, indexes and logs, and troubleshooting of reported issues. Reviews implemented scripts, stored procedures, and reports generated by automated database maintenance scripts. Participates in the technical design process as it relates to database implementations, reviews technical documents, and communicates any risks or issues using the appropriate escalation procedures. Provides directions to Technical Recovery plans (Database Standby and Replication, Backup and Recovery) About You Yo: u’re a fit for the role if your background includes: .Platform Engineer: Packages company-approved hardened versions of targeted operating systems. Ensures stack of agents for management systems are properly installed and connected. Maintains patch levels in accordance with change management and security standards. Storage Engineer: Provides leadership for storage-related projects, including switch installations, disk consolidations, disk assignments, replication, and more. Works closely with architecture teams to set, communicate, and maintain storage standards. Network Engineer: Reviews the network infrastructure documentation/ run book for standards adherence. Complies with all routing and rules sets, sequences, defaults, and standards. Documents and maintains all applicable configuration standards. Assures all NIC and port speeds are appropriately locked down. Application Engineer: Fully familiarizes self with all aspects of the developed code. Recognizes design problems and errors and takes corrective action from a design perspective on the object code environment.Interfaces with development teams on system design enhancements and the elimination of intermittent hardware/software problems.. #LI-SM1 What’s in it For You? Hybrid Work Model: We’ve adopted a flexible hybrid working environment (2-3 days a week in the office depending on the role) for our office-based roles while delivering a seamless experience that is digitally and physically connected. Flexibility & Work-Life Balance: Flex My Way is a set of supportive workplace policies designed to help manage personal and professional responsibilities, whether caring for family, giving back to the community, or finding time to refresh and reset. This builds upon our flexible work arrangements, including work from anywhere for up to 8 weeks per year, empowering employees to achieve a better work-life balance. Career Development and Growth: By fostering a culture of continuous learning and skill development, we prepare our talent to tackle tomorrow’s challenges and deliver real-world solutions. Our Grow My Way programming and skills-first approach ensures you have the tools and knowledge to grow, lead, and thrive in an AI-enabled future. Industry Competitive Benefits: We offer comprehensive benefit plans to include flexible vacation, two company-wide Mental Health Days off, access to the Headspace app, retirement savings, tuition reimbursement, employee incentive programs, and resources for mental, physical, and financial wellbeing. Culture: Globally recognized, award-winning reputation for inclusion and belonging, flexibility, work-life balance, and more. We live by our values: Obsess over our Customers, Compete to Win, Challenge (Y)our Thinking, Act Fast / Learn Fast, and Stronger Together. Social Impact: Make an impact in your community with our Social Impact Institute. We offer employees two paid volunteer days off annually and opportunities to get involved with pro-bono consulting projects and Environmental, Social, and Governance (ESG) initiatives. Making a Real-World Impact: We are one of the few companies globally that helps its customers pursue justice, truth, and transparency. Together, with the professionals and institutions we serve, we help uphold the rule of law, turn the wheels of commerce, catch bad actors, report the facts, and provide trusted, unbiased information to people all over the world. About Us Thomson Reuters informs the way forward by bringing together the trusted content and technology that people and organizations need to make the right decisions. We serve professionals across legal, tax, accounting, compliance, government, and media. Our products combine highly specialized software and insights to empower professionals with the data, intelligence, and solutions needed to make informed decisions, and to help institutions in their pursuit of justice, truth, and transparency. Reuters, part of Thomson Reuters, is a world leading provider of trusted journalism and news. We are powered by the talents of 26,000 employees across more than 70 countries, where everyone has a chance to contribute and grow professionally in flexible work environments. At a time when objectivity, accuracy, fairness, and transparency are under attack, we consider it our duty to pursue them. Sound exciting? Join us and help shape the industries that move society forward. As a global business, we rely on the unique backgrounds, perspectives, and experiences of all employees to deliver on our business goals. To ensure we can do that, we seek talented, qualified employees in all our operations around the world regardless of race, color, sex/gender, including pregnancy, gender identity and expression, national origin, religion, sexual orientation, disability, age, marital status, citizen status, veteran status, or any other protected classification under applicable law. Thomson Reuters is proud to be an Equal Employment Opportunity Employer providing a drug-free workplace. We also make reasonable accommodations for qualified individuals with disabilities and for sincerely held religious beliefs in accordance with applicable law. More information on requesting an accommodation here. Learn more on how to protect yourself from fraudulent job postings here. More information about Thomson Reuters can be found on thomsonreuters.com.

We're searching for Oracle PL/SQL developer Role: Oracle PL/SQL developer Experience: 2 to 4 years Location: Chennai (Egmore) Work Model: Work from Office Job Type: Full Time Job Description: The PL/SQL Developer will design, develop, and maintain Oracle database solutions tailored to meet business requirements. The role involves creating efficient PL/SQL scripts, optimizing database performance, and collaborating with cross-functional teams to ensure seamless integration of database solutions. The ideal candidate must demonstrate strong problem-solving skills and a deep understanding of relational database concepts. Key Responsibilities Develop, test, and maintain complex PL/SQL packages, procedures, functions, and triggers for data processing and ETL tasks. Design and implement database schemas and objects such as tables, indexes, and views. Analyze business requirements and translate them into technical solutions using PL/SQL. Optimize SQL queries and database performance for high efficiency. Perform data analysis to support report generation and modify existing reports as needed. Develop migration scripts for data transfer between systems. Ensure compliance with security standards to protect sensitive data. Provide technical support for production systems, including troubleshooting and resolving issues. Document technical specifications and create reusable code for scalability. Required Skills Technical Skills: Proficiency in Oracle PL/SQL programming with experience in developing stored procedures, functions, and triggers. Strong understanding of relational database concepts (RDBMS) and performance tuning techniques. Experience with ETL processes and data warehouse integration. Knowledge of advanced PL/SQL features like collections, ref cursors, dynamic SQL, and materialized views. Familiarity with tools like SQL Developer, Toad, or similar IDEs. Exposure to Unix/Linux scripting is a plus. Soft Skills: Strong analytical and problem-solving abilities. Excellent communication skills to interact with stakeholders and team members effectively. Attention to detail with a focus on accuracy in coding and testing. Ability to work both independently and in a team environment. Qualifications Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent experience) Proven experience (2-4years) in Oracle PL/SQL development. Certifications in Oracle Database technologies are a plus. Show more Show less