Senior Data Modeling Architect
3 weeks ago
- Contract Duration: 6+ Months
- Pay range: C$700 - 800/Day
- Hybrid - Candidate must be able to work 3 days onsite and 2 days remote
Job 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.
- Document technical specifications for all data architecture components and processes.
Must Haves:
- 7+ years experience in 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).
- Experience in developing and implementing common data models and master data management strategies.
- Ability to 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.
- Experience in defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns.
- Experience in implementing schemas and metadata structures that support efficient data management.
- 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse.
- 3+ years experience in implementing Medallion architecture or similar frameworks.
- Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks.
- 10+ years experience with Solutions development.
Experience and Skill Set Requirements
Public Sector Experience
- 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 complies with industry-standard practices.
- In-depth knowledge of industry standards 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
- 7+ years experience in 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).
- Experience in developing and implementing common data models and master data management strategies.
- Ability to 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.
- Experience in defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns.
- Experience in 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 in implementing Medallion architecture or similar frameworks.
- Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks.
Core Skill and Experience
- 10+ years experience with Solutions development.
- Experience in addressing complex data integration challenges and designing efficient, scalable data models.
- Experience in monitoring and enforcing data modeling/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
- 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.
-
Senior Data Architect
2 weeks ago
Old Toronto, Canada Talentworld Full timeTransform data into powerful insights as our next Senior Data Architect! Embrace a hybrid work setup with 3 days in our Toronto office and 2 days working remotely within Toronto. You’ll lead the creation of innovative data architectures, fine-tune database performance, and ensure your designs align with our strategic goals. If you have a flair for data...
-
Senior Data Architect
3 weeks ago
Old Toronto, Canada Talentworld Full timeTransform data into powerful insights as our next Senior Data Architect! Embrace a hybrid work setup with 3 days in our Toronto office and 2 days working remotely within Toronto. You’ll lead the creation of innovative data architectures, fine-tune database performance, and ensure your designs align with our strategic goals. If you have a flair for data...
-
Senior Data Modeling Architect
2 weeks ago
Old Toronto, Canada Global Technical Talent Full timeSenior Data Modeling ArchitectContract Duration: 6+ MonthsPay range: C$700 - 800/DayHybrid - Candidate must be able to work 3 days onsite and 2 days remoteJob 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...
-
Senior Data Architect
4 days ago
Toronto, Ontario, Canada Bitstrapped Full timeAbout the Role**Senior Data Architect**Bitstrapped is seeking an experienced and hands-on Senior Data Architect to join our Enterprise delivery team. The Senior Data Architect will play a key role in modeling, designing, and implementing solutions to meet client requirements and business needs.Key ResponsibilitiesTranslate business logic or technical...
-
Senior Data Architect
4 days ago
Toronto, Ontario, Canada Bitstrapped Full timeAbout the Role**Senior Data Architect**Bitstrapped is seeking an experienced and hands-on Senior Data Architect to join our Enterprise delivery team. The Senior Data Architect will play a key role in modeling, designing, and implementing solutions to meet client requirements and business needs.Key ResponsibilitiesTranslate business logic or technical...
-
Senior Data Modeler
2 days ago
Old Toronto, Canada Benevity Full timeMeet Benevity The world’s coolest companies (and their employees) use Benevity’s technology to take social action on the issues they care about. Through giving, volunteering, grantmaking, employee resource groups, and micro-actions, we help most of the Fortune 100 brands build better cultures and use their power for good. We’re also one of the first B...
-
Senior Data Modeler
2 days ago
Old Toronto, Canada Benevity Full timeMeet Benevity The world’s coolest companies (and their employees) use Benevity’s technology to take social action on the issues they care about. Through giving, volunteering, grantmaking, employee resource groups, and micro-actions, we help most of the Fortune 100 brands build better cultures and use their power for good. We’re also one of the first B...
-
Data Architect Data Analytics Specialist
3 days ago
Toronto, Ontario, Canada Pacific Data Integrators Full timeAbout the RolePacific Data Integrators is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will play a key role in supporting our client's OCM Self-serve platform.Key ResponsibilitiesTechnical Operationalization: Design, develop, and maintain data pipelines deployed to our client's investment entities, ensuring high levels of...
-
Data Architect Data Analytics Specialist
2 days ago
Toronto, Ontario, Canada Pacific Data Integrators Full timeAbout the RolePacific Data Integrators is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will play a key role in supporting our client's OCM Self-serve platform.Key ResponsibilitiesTechnical Operationalization: Design, develop, and maintain data pipelines deployed to our client's investment entities, ensuring high levels of...
-
Senior Data Architect
1 day ago
Old Toronto, Ontario, Canada Benevity Full timeAbout the RoleBenevity is a leading provider of corporate social responsibility and employee engagement solutions. We're seeking a highly skilled Senior Data Modeler to join our team and contribute to the design and development of our data architecture.Key ResponsibilitiesDesign and develop logical and physical data models to meet the needs of various...
-
Senior Data Architect
1 day ago
Old Toronto, Ontario, Canada Benevity Full timeAbout the RoleBenevity is a leading provider of corporate social responsibility and employee engagement solutions. We're seeking a highly skilled Senior Data Modeler to join our team and contribute to the design and development of our data architecture.Key ResponsibilitiesDesign and develop logical and physical data models to meet the needs of various...
-
Senior Data Architect
3 weeks ago
Toronto, Ontario, Canada Intact Financial Corporation Full timeAbout Intact Financial Corporation Intact Financial Corporation is a leading provider of property and casualty insurance in Canada and the United States. We are committed to helping people, businesses, and society thrive by providing innovative insurance solutions and exceptional customer service. About the Role: Senior Solution Data Architect We are...
-
Data Architect Data Analytics
3 days ago
Toronto, ON, Canada Pacific Data Integrators Full timeThe Data Engineer will support the client's OCM Self-serve platform. They will be a part of a team with Tech Lead, Business Analyst and a Data Engineer. Technical Operationalizing and maintaining data pipelines deployed to the Client's investment entities and cultivate a business relationship that assists in meeting business demands Deploying ETL/ELT...
-
Senior Data Architect
3 weeks ago
Toronto, Canada Bevertec Full timeRQ07839 - Data Architect/Modeler – Senior Hybrid Location: Toronto7+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).·...
-
Senior Data Architect
3 weeks ago
Toronto, Canada Bevertec Full timeRQ07839 - Data Architect/Modeler – Senior Hybrid Location: Toronto7+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).·...
-
Senior Data Architect
3 weeks ago
Toronto, Canada Bevertec Full timeRQ07839 - Data Architect/Modeler – Senior Hybrid Location: Toronto 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...
-
Cloud Data Architect Senior
1 week ago
Toronto, Ontario, Canada Bell Canada Full timeAbout the RoleWe are seeking a highly skilled Senior Enterprise Architect to join our team at Bell Canada. As a key member of our Enterprise Data Platforms and AI team, you will play a critical role in leading data transformation across the organization.Key ResponsibilitiesData Warehouse/Data Lake/Data Lakehouse Modernization: Own the strategy and roadmap...
-
Cloud Data Architect Senior
6 days ago
Toronto, Ontario, Canada Bell Canada Full timeAbout the RoleWe are seeking a highly skilled Senior Enterprise Architect to join our team at Bell Canada. As a key member of our Enterprise Data Platforms and AI team, you will play a critical role in leading data transformation across the organization.Key ResponsibilitiesData Warehouse/Data Lake/Data Lakehouse Modernization: Own the strategy and roadmap...
-
Senior Landscape Architect
3 weeks ago
Toronto, Canada PLANT Architect Inc. Full timeWe are looking for an experienced licensed Senior Landscape Architect to be responsible for overseeing technical and design aspects of landscape projects in the studio. The Senior Landscape Architect reports to a Partner and works closely with both Architecture and Landscape Architecture teams to en
-
Senior Data Architect
4 weeks ago
Old Toronto, Canada Project Limited Full timeRole SummaryAs a Data Architect at Project X Ltd., you will be providing clients with your knowledge and experience in making sense of messy, unstructured data. The Data Architect will be responsible for designing, implementing, and overseeing end-to-end solutions that address designing scalable and efficient data solutions, and complex business challenges...
