KPI Digital Solutions Logo

KPI Digital Solutions

Data Architect

Posted An Hour Ago
Be an Early Applicant
Hybrid
Montréal, QC, CAN
Senior level
Hybrid
Montréal, QC, CAN
Senior level
Designs and implements conceptual, dimensional, and physical data models; establishes data governance, policies, metadata, access controls, and regulatory compliance. Advises customers on modern analytics platforms, data lakes, BI, and AI scalability. Collaborates with business stakeholders, data engineers, and analysts to align requirements with architecture, assess data sources, guide transformation initiatives, support sales efforts, and lead architectural deliverables. Requires strong SQL, cloud, data modeling, governance, communication, and customer-facing consulting skills.
The summary above was generated by AI

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.

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!

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.

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.

Similar Jobs

Yesterday
In-Office or Remote
Canada
Expert/Leader
Expert/Leader
Other • Analytics • Design
Lead architectural design and technical development for data center and mission critical projects. Produce and coordinate technical drawings from concept through construction documentation, ensure code and regulatory compliance, guide junior staff, collaborate with clients and project partners, and monitor project timelines, budgets, and deliverables.
Top Skills: AutocadBimRevit
One Month Ago
In-Office
Longueuil, QC, CAN
Senior level
Senior level
Aerospace • Defense
Designs and implements enterprise data architectures, database solutions, data models, governance standards, integrated data platforms, ETL pipelines, and security controls. The role evaluates emerging technologies, documents architecture, and collaborates with data engineers, scientists, and machine learning engineers. Requires 8+ years of technical experience, expertise in Snowflake, Databricks, Apache Spark, AWS, and Azure, and is fully onsite in Longueuil with 5–10% business travel.
Top Skills: SparkAWSAzureData LakesData WarehousingDatabricksDeep LearningETLMachine LearningNosql DatabasesRelational DatabasesSnowflake
29 Days Ago
Hybrid
Montréal, QC, CAN
Senior level
Senior level
Insurance • Financial Services
Lead enterprise Data, AI, and Generative AI architecture from concept through production. Design scalable, secure cloud-native platforms, AI/ML deployment and governance capabilities, and reusable architecture patterns. Partner with engineering, data, security, product, and business teams to guide complex initiatives, assess technologies, manage risks, and establish standards. Mentor architects and technical leaders while influencing strategic technology decisions across teams.
Top Skills: AgileApache IcebergAPIsAutomationAWSAws BedrockAws Bedrock AgentcoreAws SagemakerCloud-Native ArchitectureDatabricksDevsecopsDistributed SystemsEvent-Driven ArchitectureInfrastructure As CodeLangchainLanggraphMicroservicesMlopsObservabilitySnowflake

What you need to know about the Montreal Tech Scene

With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.

Key Facts About Montreal Tech

  • Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
  • Major Tech Employers: SAP, Google, Microsoft, Cisco
  • Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
  • Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
  • Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
  • Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account