Data Architect
- Montréal-Ouest, QC, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Working hours
- 40 hours a week
- Posting language
- English
- Posted
Original 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
Are you seeking a new opportunity where you can make an impact and be recognized and compensated for your achievements? If this sounds intriguing, consider KPI Digital for your career, apply now!
Benefits
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.
You’ll join a community of smart, supportive collaborators to mentor and guide you, but to also lean on your expertise. You get a company purpose-built for business-critical, leading-edge technology solutions, committed to improving the way humans work, interact, and live.
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
- 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
- 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
- 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?:
Are you seeking a new opportunity where you can make an impact and be recognized and compensated for your achievements? If this sounds intriguing, consider KPI Digital for your career, apply now!
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!
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.
You’ll join a community of smart, supportive collaborators to mentor and guide you, but to also lean on your expertise. You get a company purpose-built for business-critical, leading-edge technology solutions, committed to improving the way humans work, interact, and live.
More about this job
Responsibilities
Partner with customer stakeholders to identify data-driven opportunities, assess data sources and platforms, and recommend modern analytics and AI solutions. Ensure data models are coherent from conceptual through physical implementation, support engineering and business analysis teams, contribute to sales and project deliverables, and guide teams on architecture and governance.
Requirements
The role requires senior-level experience creating and implementing conceptual and dimensional data models, establishing data governance, and working with BI platforms, cloud environments, AI projects, SQL, and data modeling or enterprise architecture tools. Candidates should also be able to communicate effectively with business and technical stakeholders, navigate ambiguity, and apply relevant regulatory and access-control practices.
Skills
- Data Architecture
- Conceptual Data Modeling
- Dimensional Modeling
- Data Governance
- Business Intelligence
- Cloud Platforms
- Artificial Intelligence
- Data Warehousing
- SQL
- Data Access Management
- Regulatory Compliance
- Enterprise Architecture
- Data Modeling Tools
- Event-Driven Architecture
- Stakeholder Communication
- Business Process Modeling
Benefits
- Professional Networking Opportunities
- Full-Time Permanent Employment
- Hybrid Work Arrangement
- Flexible Schedule
- Competitive Salary and Bonus Structure
- Group Insurance Plan
- Retirement Savings Plan With Matching
- Flexible Fridays During Summer
- Gym Access
- Subsidized Catering
- Free Office Snacks
- Vacation Days
- Six Personal Days Per Year
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Consulting
- Management & Leadership
Keywords
- Data Architecture
- Data Governance
- Conceptual Data Models
- Dimensional Data Models
- Star Schema
- Snowflake Schema
- Business Intelligence
- Analytics
- Artificial Intelligence
- Machine Learning
- Cloud Platforms
- Data Lakes
- Data Marts
- Metadata Layers
- SQL
- DDL
- DML
- Collibra
- Cloudera EDH
- Watson Knowledge Catalog
- PowerDesigner
- Erwin
- Embarcadero
- Sparx
- BizzDesign
- Aris
- Alfabet AEM
- Orbus I-Server
- COBIT
- GDPR