Data Architecture Advisor (Q2D)

Role Summary

This is a remote position.

TEHORA is currently looking for a data architecture advisor with excellent technical skills, excellent knowledge and who wishes to leverage their skills within a versatile team.

Without being exhaustive, here are the services and deliverables that the successful candidate must provide.

Description of work or deliverables

• Define the architecture and carry out modeling of the conceptual, logical and physical data necessary to establish the vision;
• Collaborate with the functional analyst and the integrator architect to evaluate the sources and quality of data as well as the needs in this regard in order to meet the Company's requirements;
• Data Vault 2.0 modeling;
• Model the data as a star in order to make data exploitation possible;
• Constitute, document and maintain the corporate data dictionary and the underlying business and transformation rules;
• Participate in functional analyzes of systems in order to validate conceptual models and/or data business objects;
• Participate in the import of data from legacy systems and other sources to new systems;
• Ensure the sound management of business metadata, establish the requirements and ensure their management;
• Contributes to the corporate architecture team to establish the roadmap of the AI program/project in line with the order book prioritized by the governance process;
• Support management in the governance and management of the AI program and projects;
• Participates in the stage of identifying business needs for projects to ensure that the target architecture will adequately address them;
• Agree on the components of a solution, in line with the expressed needs, with the Data/ETL/Customer Interface architects;
• Guides the architecture of solutions;
• Ensures the alignment between governance, enterprise architecture, AI business architecture and the architectures of data solutions, customer interface and ETL;
• Support the team with AI orientations and best practices;
• Animates and powers the AI architecture table;
• Regularly monitors best practices and innovation in AI and data management;
• Ensures that the architectural documentation is produced and kept up to date (with compliant tools);
• Participates in the IT architecture table.

Deliverables

• Data dictionary;
• Data models (conceptual; logical, physical, star, etc.);
• Analysis of data sources;
• Governance;
• Data mapping.

Requirements

• 1)Have fifteen (15) years of professional experience in information technology, including ten (10) in business intelligence;
• 2)Have seven (7) years of experience as a business intelligence data architecture advisor;
• 3)Have three (3) years of experience in conceptual business data modeling;
• 4)Have five (5) years of experience in conceptual star data modeling;
• 5)Have five (5) years of experience in conceptual data vault modeling including one (1) in Data Vault modeling (1.0 or 2.0);
• 6)Have five (5) years of experience in developing data dictionaries;
• 7)Have seven (7) years of experience with SQL language and the SQL server platform;
• 8)Have completed one (1) mandate in Agile mode lasting one hundred person days (100 days) as a business intelligence data architecture advisor
• WORKPLACE

The place of work will be determined according to the mandate, it can be teleworking or at the client's site.

About the Company

WHY JOIN TEHORA?

TEHORA is a multidisciplinary Quebec firm recognized for the excellence of its professional, technical and project management services on a national and international scale. Our mission is to support our clients in bringing their projects to fruition through the excellence of our know-how and creativity.

Since its creation in 2017, our team of professionals has experienced exponential growth by meeting important needs in multidisciplinary project management, in the fields of transportation, civil engineering, IT and more.

Our employees work on mandates both internally and with major clients.

TEHORA stands out for its corporate culture, focused on the happiness of its employees and diversity.

At TEHORA, each employee is an important member of the team who contributes to our collective success.

Our members have the flexibility required to have a work-life balance while leading a rewarding career.

We offer a motivating work environment. The diversity of projects, the great autonomy and the direct interaction with clients are appreciated. Such proximity is possible due to our flat organizational structure, which results in trusting relationships and effective communication between our team and clients.

• ADVANTAGES
• Teleworking and flexibility to adapt to your family obligations;
• An entrepreneurial culture promoting creativity and innovation;
• Flexible hours (depending on the type of employment contract);
• Leave in case of illness and for family events;
• Adapted IT tools;
• Fulfilling and motivating workspace;
• Social and environmental initiatives;
• Workplace learning program;

Career path.