RQ09406 - Senior Data Architect

Cloud SynApps Inc.; Mississauga; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading consulting and systems integration firm in cloud applications is seeking a data architect/modeler. The candidate will develop complex data architectures and models, working in a hybrid environment directly impacting public sector clients while utilizing advanced information management skills.

Qualifications

• Knowledge in information resource management tools and techniques.
• Experience with multiple platforms and database technologies.
• Excellent analytical and communication skills.

Responsibilities

• Develop and implement data architecture in a complex environment.
• Design and document data models and architectures.
• Support data migration strategies and prototypes.

Skills

Information resource management

Systems analysis

Database design

Data modeling

Analytical skills

Problem-solving

Communication

Education

Experience in database technologies

Tools

ERWIN

VISIO

PowerDesigner

Job description

Cloud SynApps is a fast-growing consulting and systems integration firm that focuses on cloud applications, primarily on Salesforce-based platforms. Cloud SynApps has its major operations in Canada, the USA, and India. We’ve actively built our Salesforce practice and have quickly grown into one of the strongest Systems Integrators within the Salesforce Public Sector space. While Public Sector is our passion, we are also expanding into other verticals, including Insurance and the Telcom space.

We are one of the largest Systems integrators for Vlocity (recently acquired by Salesforce) and Clariti Solutions (erstwhile BasicGov Applications) and have implemented these solutions for several municipal, provincial/state, federal, and public sector clients. Our consultants and associates have deep industry expertise and live by our core values. We also invest heavily in developing unique Salesforce-based solutions and accelerators, which, in our experience, are required by our clients.

We believe in full transparency in whatever we do for our clients and internally, working with our associates. We are quickly growing, and that brings additional responsibility to treat everyone with respect and dignity. Integrity is one of our most important and foundational values. We follow ethical principles and always acknowledge the value each associate, partner, and client brings to the table.

Key Responsibilities:

Develops and implements the data architecture for application development in a complex and distributed environment, including the determination of the flow and distribution of data, the location of databases, and data access methods.

Provides a standard common business vocabulary, expresses strategic data requirements, outlines high-level integrated designs to meet these requirements, and aligns with the enterprise strategy and related business architecture.

Skills

Experience and Skill Set Requirements

Mandatory Skills (50%):

· Knowledge and experience in information resource management tools and techniques

· 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

· Experience in the use of Computer Aided Software Engineering (CASE) tools for the development and documentation of data architectures and detailed data models

· Experience in the use of data modelling methods and tools (e.g. ERWIN, VISIO, PowerDesigner) including a working knowledge of metadata structures, repository functions, and data dictionaries

· Knowledge and experience in the use of information retrieval packages Awareness of emerging I&IT trends and directions

· Experience in monitoring and enforcing data modelling/normalization standards

· Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills

· A team player with a track record for meeting deadlines

Data architecture/data modeler skills will build upon a Conceptual Data Model which is technology-and application-independent and will assist with the following tasks/deliverables:

· Continue ‘data prototyping’ to proof CDM recommendation

· Develop a fully Attributed Conceptual Data Model (CDM) or Logical Data Model depending on IT solution strategy that is approved.

· Support MECP in developing their Data Migration strategy/plan

· Assist with Alpha prototyping and/or proofs-of-concept

· Support development of enterprise architecture artefacts for submission to Architecture Review Board for Architecture Gate Point 0 (AGP0) during summer 2025 and then AGP1 during fall/winter

· Experience with middleware and gateways

· Experience in designing/developing an automated data distribution mechanism

· Knowledge and understanding of object-oriented analysis and design techniques.

· Knowledge and understanding of Information Management principles, concepts, policies and practices

· Experience creating detailed data standards to enable integration with other systems

· Experience reviewing conceptual, logical and physical data models for quality and adherence to standards Knowledge and understanding of dimensional and relational data models

· Knowledge and experience in information resource management tools and techniques

Communication & Soft Skills (15%)

· Excellent verbal and written communication skills (clear & concise. Presentation skills to present information and findings, options and recommendations to clients, project/technical team members and management audiences

· Strong track record of building and maintaining solid relationships with clients, project team members, and management

· Self-motivated leader with strong interpersonal skills.Collaboration skills to jointly work towards project common goals/deliverables by proactively sharing status, raising risks/issues and effort estimates

· Persistent attention to detail

· Proven ability to handle multiple tasks and deliver within extremely tight deadlines

· Project rescue/project triage experience is an asset

Public Sector Experience (5%):

· Previous experience working in Government or Public Sector organizations

· Experience in developing enterprise architecture deliverables (e.g. models) based on Ontario Government Enterprise Architecture processes and practice

Must haves:

Data architecture/data modeler skills will build upon a Conceptual Data Model which is technology-and application-independent and will assist with the following tasks/deliverables:

· Continue ‘data prototyping’ to proof CDM recommendation

· Develop a fully Attributed Conceptual Data Model (CDM) or Logical Data Model depending on IT solution strategy that is approved.

· Support MECP in developing their Data Migration strategy/plan

· Assist with Alpha prototyping and/or proofs-of-concept

· Support development of enterprise architecture artefacts for submission to Architecture Review Board for Architecture Gate Point 0 (AGP0) during summer 2025 and then AGP1 during fall/winter

Hybrid work: 3 days in the office at 40 St. Claire Ave. West/125 Resources Road. Toronto and 2 days remote from home office within Ontario.