Data Architect
HybridMontréal, Quebec, Canada
Job Summary
Work with customer stakeholders to identify opportunities for leveraging data to improve business processes or innovate. Assess the effectiveness of new data sources and audit models to ensure they remain complete, coherent, and consistent. Guide teams from an architectural and governance perspective while helping data engineers transform data toward the DataLake. Assist sales efforts as a subject matter expert by presenting D&A offerings and participating in scope-of-work meetings. Define governance programs, enforce policies across the data lifecycle, and translate business requirements into specific data concepts. Create dimensional metadata layers for visualization tools and APIs, and support the adoption of modern D&A platforms for scaling AI initiatives.
Required Qualifications
- Is a senior Data architect
- Is a senior BI architect
- Can develop detailed and comprehensive conceptual data model
- Is at ease defining business processes map, SIPOC, and business capabilities models
- Can put a governance program in place with appropriate structure, committees and supporting processes and tools
- Can define policies and enforce them for the full life cycle of data
- Can transpose the conceptual data model in dimensional models
- Can physically implement dimensional models on traditional and modern D&A platform
- Can create the dimensional metadata layer to be consumed by visualization software and/or thru API
- Master one or more Cloud environments
- Has been involved in AI projects
- Has defined either 'home grown' DG solution or use tools such as Collibra, Cloudera EDH, Watson Knowledge Catalog or others
- Must have a great experience in creating conceptual data models from scratch and have them physically implemented
- Can translate and animate sessions with businesspeople and other SMEs to either complete a started model or do one from scratch
- Has done multiple snowflake and STAR model from a conceptual data model and/or directly
- Has used and created multiple data layers including the use of metadata for exposing datamarts to visualisation tools
- Can define the access rights management solution
- Has implemented various regulations such as PIPED Act, GDPR, IFRS, SOX or others
- Has used multiple Data Modeling tools and Enterprise Architecture tools (PowerDesigner, ErWin, Embarcadero, Sparx, CaseWise, BizzDesign, Aris, Alfabet AEM, Unicom System Architect, Orbus I-Server, etc.)
- Possesses excellent written and verbal communication skills for coordinating across teams
- Is driven to learn and master new technologies and techniques
- Can understand rapidly the patterns and directions taken by the Practice Lead (former chief architect)
- Can zero-in on ambiguous concepts and made them crystal clear rapidly
- Is pragmatic (consider constraints) but not to the expense of faulty designs/concepts
- Can discern fundamental and key aspects worth 'fighting for' versus the less 'important' ones
- Is great at whiteboarding with customers and prospects
- Has excellent understanding of SQL (DDL and DML)
- Understands asynchronous architecture using 'queue mechanisms' such as Event Hub/Kakfa
- Has implemented the Data aspect related to COBIT
- Is bilingual (French and English)
Desired Qualifications
- Ideally can go further by taking the dimensional models and physicalizing them on traditional and modern D&A platform
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.