Job Title: Apptad - Data Architect/Modeller - Senior
Job Location: Toronto (Hybrid)
Job Duration: Long-Term Contract
One of our Government clients is looking for a Senior Data Architect/Modeller
Job Description
Responsibilities:
MUST HAVES:
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
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.
Selection Criteria
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 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. | 5 points |
| Technical Skills and Experience | 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. | 50 points |
| Core Skill and Experience | 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. | 30 points |
| 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. | 15 |
...Registered Nurse Restore Hyper Wellness Do you have a passion for nursing but are tired of the hectic, high-stress environment of a clinic or ER? This is your chance to take your career in an exciting, new direction. Restore is seeking an outgoing, experienced...
...As a Brand Ambassador for NOVA Tastings LLC, you will be the face of our alcohol brands, including wine, beer, and ready-to-drink cocktails. You will be responsible for conducting tastings, engaging with consumers, and educating them about our products. Your enthusiasm...
...Were looking for a Senior iOS engineer to help shape our all-in-one privacy solution... ...over time. Collaborate with peers remotely during product brainstorms, technical design... ...and algorithms, which enables you to develop and apply new solutions and confidently navigate...
...to Midpoint Pay Rate: $51.54 - $67.01 / hour Summary The pharmacist is responsible for the preparation, dispensing, and monitoring... ...inpatient hospital experience as staff pharmacist or pharmacy intern in a general medical/surgical hospital preferred for PharmD candidates...
...transform your day, your tripor even your life. This is not your typical career opportunity. At Thompson Denver, a member of the Hyatt collection, we believe our team members can thrive in an empowered, supportive, creative and energetic environment. Were looking...