Get alerts for new jobs matching your selected skills, preferred locations, and experience range.
0.0 - 1.0 years
0 Lacs
Kochi, Kerala
On-site
Role Overview We are seeking a skilled and detail-oriented Digital Marketing Executive with a strong emphasis on Search Engine Optimization (SEO) to boost our online visibility and engagement for our Business Management Company situated in Adoor and Kochi. The ideal candidate will not only manage digital marketing campaigns but also excel in SEO strategies, ensuring that our brand ranks prominently across search engines. This role demands creativity, analytical thinking, and technical expertise to drive measurable results while maintaining the organization’s professional image. Key Responsibilities Core SEO Responsibilities : Develop and implement comprehensive SEO strategies to improve website rankings on major search engines like Google and Bing. Perform in-depth keyword research , competitor analysis, and market trend assessments to identify opportunities for content and ranking improvements. Optimize website content, meta tags, headers, URLs, and images for on-page SEO . Execute off-page SEO activities, including backlink acquisition, guest blogging, and outreach to improve domain authority. Conduct regular technical SEO audits , identifying and resolving issues such as crawl errors, broken links, and site speed optimization. Monitor and analyze performance metrics using tools like Google Analytics , SEMrush , Ahrefs , and Google Search Console to refine strategies. Coordinate with teams across departments to ensure consistent messaging and branding across all digital platforms. Ability to travel as required for events, presentations, and business meetings. Digital Marketing Campaigns : Plan, execute, and manage Google Ads , Meta Ads , and other PPC campaigns to generate leads and conversions. Track and optimize campaigns, focusing on ROI and performance metrics. Content Marketing and Coordination : Collaborate with content developers to create SEO-optimized blogs , articles, landing pages, and website content. Ensure all written content aligns with keyword strategies and enhances user experience. Social Media and Brand Management : Develop engaging content for social media platforms, aligning with SEO goals to boost brand awareness. Monitor trends and audience insights to adapt strategies dynamically. Website Management : Maintain, update, and enhance the company website, ensuring SEO best practices are adhered to. Work with developers to implement structural improvements for better crawling and indexing. Analytics and Reporting : Provide detailed performance reports on SEO and campaign results, offering actionable insights. Use data visualization tools like Google Data Studio or Power BI for effective reporting. Preferred Candidate Education Requirements : Minimum: A degree or Certification in Marketing, IT, Business Administration, or related fields. Skills and Specialized Knowledge : SEO Expertise : Proficiency in tools such as SEMrush , Ahrefs , Moz , and Google Search Console . Advanced understanding of search engine algorithms and ranking factors. Digital Marketing Skills : Hands-on experience with Google Ads , Meta Ads , and email marketing platforms. Familiarity with social media management tools like Hootsuite or Buffer . Technical Skills : Strong knowledge of HTML , CSS , and JavaScript basics for technical SEO optimizations. Experience with CMS platforms like WordPress , Shopify , or similar systems. Additional Skills : Excellent written and verbal communication skills for creating SEO-friendly content and client communication. Strong analytical skills to interpret data and drive data-driven decisions. Multitasking abilities to handle multiple campaigns and projects efficiently. Appearance & Personality : A Professional candidate with an appealing personality and confident body language. Should embody professionalism and brand values. Job Type: Full-time Pay: ₹13,000.00 - ₹20,000.00 per month Supplemental Pay: Performance bonus Shift allowance Application Question(s): What is your salary expectations? Experience: Digital marketing: 1 year (Required) Language: English, Hindi (Required) Location: Kochi, Kerala (Preferred) Willingness to travel: 50% (Required) Work Location: In person
Posted 2 weeks ago
5.0 - 8.0 years
0 Lacs
Delhi, India
On-site
Job Description - SQL Developer Location: New Delhi Position brief: The SQL Developer will be responsible for developing, optimizing, and maintaining complex SQL queries, stored procedures, triggers, and functions. The role will drive the design and implementation of high-performance database solutions using Microsoft SQL Server, Oracle, and MySQL. The role is responsible for ensuring database security, performance tuning, and managing ETL processes. Primary Role & Responsibilities: The Primary role of the candidate will be: Develop, optimize, and maintain complex SQL queries, stored procedures, triggers, and functions. Design and implement high-performance database solutions using Microsoft SQL Server/Oracle, and MySQL. Perform database administration, including installation, configuration, and maintenance of database systems. Ensure database security, including Transparent Data Encryption (TDE) implementation and user access control. Conduct database performance tuning, indexing strategies, and query optimization for efficient execution. Develop and manage ETL processes to support data migration and integration. Create and maintain Oracle/MySQL automation tasks for database maintenance. Provide support for backup, recovery, and disaster recovery planning. Review and analyse business report requirements and develop reporting solutions. Collaborate with cross-functional teams to support application development and system enhancements. Monitor database performance and troubleshoot issues to ensure high availability and reliability. Work Experience and Qualification: Education: Bachelor's degree in computer science, Information Technology, or a related field. Experience: 5 to 8 years of hands-on experience in SQL development, database administration, and query optimization. Technical Skills: Strong expertise in Microsoft SQL Server, Oracle, MySQL, and T-SQL/PL-SQL programming. Experience in performance tuning, execution plans, and database profiling. Knowledge of backup and recovery strategies, disaster recovery solutions, and database replication. Experience in creating and managing ETL pipelines and data migration processes. Experience with Transparent Data Encryption (TDE) and database security best practices. Proficiency in writing optimized Common Table Expressions (CTEs) and indexing strategies. Understanding of cloud database services (Azure SQL, AWS RDS, Oracle Cloud, etc. ) is a plus Required Soft Skills: Strong analytical and problem-solving skills. Ability to work independently and collaboratively with teams and stakeholders. Show more Show less
Posted 2 weeks ago
0.0 years
0 Lacs
Hyderabad, Telangana
On-site
Location Hyderabad, Telangana, India Category News & Editorial Careers Job Id JREQ190761 Job Type Full time Hybrid Job Description Summary: Analyse, create, and deliver content that enhances the research value to customers of Thomson Reuters legal information, within parameters established by management and/or editors. Act as a resource for junior staff in handling both substantive content and production issues related to responsibilities Commentary Law: As a member of the Global Commentary editorial team, you will work closely with other teams and individuals to collaborate on your work. Relationship management, meeting deadlines, and strong editorial skills are necessary to maintain our indexes as part of our world-class commentary collection. About the Role: In this role, you will provide legal interpretation to create or update existing indexes for Thomson Reuters Legal in all media. Members of this team are also tasked with ensuring that published indexes contain and deliver appropriate legal concepts and terms to create a quality finding aid for our customers. There are several key responsibilities of the Attorney Editor role: Create back-of-the-book indexes: Our Attorney Editors generate back-of-the-book indexes by creating original content or by updating an existing index. When applicable they incorporate their index into an existing general index. They follow the required style guidelines and deliver within extremely strict and tight time deadlines. Editorial Responsibility: Members of this team adhere to editorial publishing schedules and quality standards. They also verify their own work for accuracy and completeness and ensure that the information is properly presented and organized. In this role, attention to detail, knowledge of legal concepts and “terms of art” of how legal concepts fit together, and the ability to synthesize complex material are required. Individual and Leadership Development: As a part of a larger team, you will attend and participate in meetings and take part in the employee evaluation process (both wider feedback and self-evaluation). To be most effective at your job, you will develop knowledge of Thomson Reuters Legal publications and products related to your responsibilities, and those of competitors. Members of our team prioritize their own work and understand the roles and responsibilities of each collaborator/team member and how each role impacts production. You will also be required to demonstrate competence on company-specific systems necessary to perform your job functions. About you: Education: Legal degree from an accredited law school. Self-starter with an aptitude for legal concepts and “terms of art” of how legal concepts fit together Analytical thinker who uses logic and collaborates to solve difficult problems Decisive with a focus on making quality decisions quickly Driven by deadlines and can deliver results Ability to interpret, analyze, organize, and communicate complex legal material. Comfortable with personal computers and familiar with word processing and online applications Can prioritize tasks and projects and pursue them with energy and drive Great teammate who will work successfully in a shared environment. Strong communicator who can speak and write clearly and effectively with all contacts, both in and outside Thomson Reuters. #LI-AM1 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.
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
5.0 years
0 Lacs
Greater Kolkata Area
On-site
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
Posted 2 weeks ago
Upload Resume
Drag or click to upload
Your data is secure with us, protected by advanced encryption.
The indexing job market in India has been growing steadily over the past few years, with an increasing demand for professionals skilled in data organization and management. Indexing roles are crucial in various industries such as publishing, research, and information technology. In this article, we will explore the job opportunities, salary ranges, career paths, related skills, and interview questions for indexing roles in India.
These cities are known for their vibrant job markets and have a high demand for indexing professionals.
The average salary range for indexing professionals in India varies based on experience levels. Entry-level professionals can expect to earn around INR 3-5 lakhs per annum, while experienced professionals can earn upwards of INR 10 lakhs per annum.
A typical career progression in indexing roles may include: - Indexing Associate - Indexing Specialist - Senior Indexing Analyst - Indexing Manager
With experience and additional certifications, professionals can move up the ladder to managerial roles within the indexing field.
In addition to indexing skills, professionals in this field are often expected to have knowledge of: - Data management - Information retrieval systems - Database management - Advanced Excel skills - Attention to detail
As you prepare for indexing roles in India, remember to showcase your expertise in data organization and management. Stay updated on industry trends and technologies to stand out in the competitive job market. With the right skills and preparation, you can confidently apply for indexing roles and advance your career in this field. Good luck!
Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.
We have sent an OTP to your contact. Please enter it below to verify.
Accenture
36723 Jobs | Dublin
Wipro
11788 Jobs | Bengaluru
EY
8277 Jobs | London
IBM
6362 Jobs | Armonk
Amazon
6322 Jobs | Seattle,WA
Oracle
5543 Jobs | Redwood City
Capgemini
5131 Jobs | Paris,France
Uplers
4724 Jobs | Ahmedabad
Infosys
4329 Jobs | Bangalore,Karnataka
Accenture in India
4290 Jobs | Dublin 2