Data Architect

Position Description:

Lead the successful delivery of strategic initiatives at the heart of a dynamic, innovation-driven organization!

CGI Montréal is looking for a Data Architect who is passionate about designing high-performing, secure, and scalable data solutions. In this role, you will define the architectures, models, and data flows that support the operational and analytical needs of an information-sharing platform focused on sustainable mobility. Working closely with business teams and technology experts, you will be responsible for designing data integration and governance solutions aligned with best practices, while ensuring data quality, integrity, and value realization. If you are looking to contribute to digital transformation initiatives by placing data at the center of decision-making, CGI offers you an exciting opportunity to make a tangible impact on the success of our clients.

Location: Montréal Work Model: Hybrid (1 day/week onsite)

Your future duties and responsibilities:

• Translate business and internal requirements into technical data solutions

• Understand internal management processes, system architecture, and the design and development of data and analytics solutions across a wide variety of business domains

• Collaborate with technical stakeholders and internal business specialists to implement strategic data-driven initiatives while adhering to data and analytics best practices

• Contribute to defining the structure and architecture of conceptual and physical data models

• Determine the best approaches for data modeling and provide guidance to teams on optimal data models that support a variety of data processing use cases, including transactional, analytical, batch, and real-time processing

• Define data flow and process architectures that segment and manage data by considering storage, transit, processing, transformation, and access requirements, while ensuring compliance with applicable legislation, privacy regulations, personal information protection standards, legal entities’ requirements, and consent management policies

• Understand and meet data referential integrity requirements based on business needs

• Develop or assist in generating source-to-target data mappings for extract, transform, and load (ETL) processes

• Develop dimensional models and views required for data analysis, reporting, and dashboard creation

• Recommend diverse and innovative solutions to integration challenges

• Ensure the continuous improvement of the BI platform architecture, from raw data acquisition through to the presentation layer

Required qualifications to be successful in this role:

• University degree in Computer Science, Software Engineering, or relevant experience

• Minimum 5 years of experience in data architecture, including relational modeling (Third Normal Form, ERD, data dictionaries) and dimensional modeling (star schema, cubes, data warehouse/data mart)

• Experience with traditional business intelligence technologies: ETL, data marts, dashboarding, and reporting tools

• Experience in data analysis and data profiling

• Experience in data reverse engineering to derive data-driven insights

• Relevant experience in data quality management (with or without dedicated tools)

• Minimum 5 years of SQL development experience with a variety of DBMS platforms, including SQL Server (Azure version considered an asset)

• Experience with the Microsoft BI suite (Power BI, T-SQL, SSIS, Data Factory, Snowflake, SSRS, SSAS, Power Pivot, Excel, etc.), as well as JSON, XML, and shape files (GIS)

• Knowledge of data governance principles and frameworks (DAMA, etc.)

• General knowledge of geomatics/GIS concepts

• Knowledge of various Azure cloud offerings and tools (Data Lake Store, SQL Data Warehouse, SQL Managed Instance, DevOps, Cosmos DB, etc.) will be considered an asset

• Experience with Waterfall and/or Agile project management methodologies will be considered an asset

• Experience in operational and business intelligence data governance (measurement, metrics, key performance indicators) will be considered an asset

• Excellent French communication skills (spoken and written)

Location: Montreal Work mode: Hybrid

CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is 70 000$ et 135 000$. This role is an existing vacancy.

#LI-AL10

Use of the term ‘architect’ in this job posting refers to the technical sense related to Information Technology (IT) and does not imply that the individual practices architecture or possesses the requisite license as prescribed by the applicable provincial or territorial architect regulator. We are seeking individuals with expertise in IT architect-related functions, but licensure from an architect regulator is not a prerequisite for this position. Architecture is a regulated profession in Canada which is restricted in terms of use of titles and designation.

Skills:

• French

• Microsoft Azure Data Factory

• Microsoft PowerBI

• MS SSIS

• Snowflake

• Transact-SQL

What you can expect from us:

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

At CGI, we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter.

That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.

To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our team—one of the largest IT and business consulting services firms in the world.