Data Architect

KPI Mining Solutions; Montreal (administrative region); Hybrid; CAD 90,000 - 150,000; Full time

Benefits offered by this job

Hybrid work arrangement

Competitive salary and bonus

Group insurance plan

Retirement savings plan with matching

Flex-Fridays in summer

Office gym access

Catering service and snacks

Job summary

KPI Digital seeks a Data Architect with BI and AI expertise to deliver consulting services to clients, building governance, data models, and scalable data platforms across cloud environments.

The role involves turning conceptual data models into dimensional representations, creating metadata layers for visualization, and driving data strategy with enterprise tools and governance structures.

Qualifications

• Defined conceptual data models from scratch and implemented.
• Experience with governance, metadata, and data access controls.
• Snowflake and STAR schema design experience.
• Familiar with multiple data modeling tools and EA tools.
• Excellent written and verbal communication.
• Bilingual in French and English preferred.

Responsibilities

• Identify opportunities to leverage data for insights and process improvement.
• Assess data sources and gathering techniques for accuracy.
• Advise on modern D&A platform to scale AI capabilities.
• Ensure models are complete and coherent from concept to physical.
• Support sales as SME in D&A offerings and deliverables.

Skills

Data architecture

BI architecture

AI projects

Cloud environments

Communication skills

Whiteboarding

SQL proficiency

Bilingual

Tools

PowerDesigner

ErWin

Embarcadero

Sparx

CaseWise

BizzDesign

Aris

Alfabet AEM

Unicom I-Server

Orbus I-Server

Job description

The Data & Analytics group is looking for a Data Architect with, BI and AI expertise who will be providing consulting services to our customers.

The candidate

• Is a senior Data architect that 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. And can define policies and enforce them for the full life cycle of data
• Is a senior BI architect that can transpose the conceptual data model in dimensional models an ideally can go further by taking the dimensional models and physicalizing them on traditional and modern D&A platform.
• The BI architect is also expected to create the dimensional metadata layer to be consumed by visualization software and/or thru API
• Master one or more Cloud environments and has been involved in AI projects

Requirements

• 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. This clearly is not only the ability to identify and define the right concepts but also the ability to have the concepts physically implemented and used in applications and dashboards
• 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. 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) preferred

Responsibilities

• Work with our customers’ stakeholders to identify opportunities for leveraging their data to produce insights allowing them to improve business processes or even innovate by changing the industry. The same assessment could also be used to identify constraints allowing to optimize (DO) business processes
• Assess the effectiveness and accuracy of new data sources and data gathering techniques
• Assess, audit, and provide recommendations to help our customers move toward a modern D&A platform allowing them to scale their AI
• Ensure that all models (conceptual to physical) are complete, coherent, and consistent
• Help the data engineers from getting the data to the transformation toward the DataLake
• Help the BA to have business requirements align with the data architecture and vice-versa. Data architects create generic to specific data concepts and they need to tie back to the business requirements. On the other hand, many times business requirements describe the how versus the what which is a constraint in itself
• Assist sales efforts as SME from the D&A practice by meeting prospects and customers presenting the D&A offerings from KPI Digitals and participating in SOW
• Handle and complete the deliverables started by the VP of D&A practice for internal and external projects
• Guide and direct teams from architectural and governance perspective

What will make you successful here?

• A desire to be accountable for owning problems from design to implementation
• An understanding of the difference between data and useful insights
• A bias for action and pragmatic solutions
• A low ego and humility; an ability to gain trust through effective communication and doing what you say you will do
• A talent for operating effectively at various levels of abstraction
• An aptness to distill complex, technical topics articulately to a non-technical audience
• Adaptability, flexibility and an ability to navigate ambiguity
• Who is KPI Digital?:

KPI Digital has been helping clients meet their revenue goals for over 25 years. We specialize in Digital Transformation, Analytics & AI and Performance Management business solutions/services. More specifically Analytics, Digital Marketing, Big Data, Insights, Customer 360, Artificial Intelligence (AI), Machine Learning and Internet of Things (IOT). In addition, we offer Consulting Services, Managed Services, Packaged Services, Education and Training.

Benefits

• The opportunity to join and grow an ever-expanding professional network of high-profile clients and reputable colleagues.
• Permanent, full-time job (40 hours a week).
• Hybrid (work from home and/or office) and flexible schedule.
• Competitive salary and bonus structure.
• Attractive group insurance plan.
• Retirement savings plan with matching.
• Family company culture.
• Flex-Fridays in the summertime.
• Free use of the gym within building.
• Subsidized catering service & free snacks at the office.
• Vacation days plus 6 personal days per year.
• Casual work environment: jeans-friendly!

Proudly a Great Place to Work!

As you bring your experience and skills to KPI Digital, you’ll get a unique experience, ambitious growth, and limitless learning in return. As we continue to build our diverse and inclusive culture, we become even more innovative and creative, helping us better serve our clients and our communities.