Cloud Data Architect

Capgemini; Montreal; On-site; CAD 90,000 - 130,000; Full time

Job summary

At Capgemini, you'll empower your career and collaborate with a global community. This position requires extensive experience in Data Warehousing and cloud solutions, focusing on data architecture design and governance, essential for supporting diverse business objectives. Join us to make a meaningful impact in the tech industry.

Qualifications

• 7–12 years of experience in Data Warehousing, 3+ years with cloud platforms.
• Expert-level SQL skills; strong experience with relational databases.
• Good programming skills (Python preferred) and Unix shell scripting knowledge.

Responsibilities

• Develop and implement data architecture strategies supporting Snowflake.
• Create logical and physical data models reflecting business needs.
• Ensure data quality and manage data definitions and standards.

Skills

Data Warehousing

Data integration techniques

SQL

Data modeling

Analytical skills

Tools

Snowflake

Databricks

Spark

AWS

Azure

Google Cloud

Job description

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired bya collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizationsunlock the value of technology and build a more sustainable, more inclusive world.

Job Description

• 7–12 years of experience in Data Warehousing, including at least 3+ years with cloud data platforms.
• Proven expertise in data warehousing solutions, ELT processes, and data integration techniques.
• Strong experience with Snowflake Cloud database; hands-on with Databricks and Spark.
• Expert-level SQL skills and experience with relational databases (e.g., Snowflake, Teradata, PostgreSQL, Sybase, DB2).
• Proficiency in data modeling and tools like Erwin, Power Designer, or equivalents.
• Solid understanding of Data Warehousing concepts (data modeling, transformations).
• Experience developing and supporting data ingestion frameworks using SQL, Spark, Python, Databricks, Snowpipe, etc.
• Familiarity with big data technologies and cloud services (AWS, Azure, Google Cloud).
• Good programming skills (Python preferred) and Unix shell scripting knowledge.
• Understanding of DevOps practices in the data space.
• Strong analytical, problem-solving, and communication skills.
• Ability to work effectively in collaborative, agile environments.

Key Responsibilities

• Data Architecture Design:
  Develop and implement comprehensive data architecture strategies that support the needs of our Data on Snowflake Cloud Architecture.
  Design scalable data models that facilitate efficient data procurement, storage, processing, and analysis.
• Data Modeling:
  Create logical and physical data models, that reflect business data consumption needs.
  Ensure data models to support data mining, business intelligence, and analytics activities and AI tools.
  Semantic models to facilitate self-service operations
• Data Governance and Quality:
  Help establish and facilitate management of data definitions, standards, policies, and procedures.
  Enhance data quality by setting up frameworks for data consistency, accuracy, and completeness.
  Lead efforts in data cataloging for improved data discovery and understanding.
• Collaboration:
  Work closely with data engineers, analysts, product owners, and other stakeholders to deliver data products that align with business objectives.
  Facilitate cross-functional team efforts to ensure data architecture supports all aspects of the business.
• Tool Utilization and Expertise:
  Utilize advanced data modeling tools to design and optimize data architectures.
  Stay updated with the latest trends in data technology and methodologies applicable to asset management.
  Familiarity with business intelligence tool set ecosystem, and strong experience with some.

Disclaimer

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.
This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.
Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.
Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process.
Applicants for employment in Canada must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in Canada by Capgemini.

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.

When you join Capgemini, you don’t just start a new job. You become part of something bigger.

Learn about how the recruitment process works – how to apply, where to follow your application, and next steps.

To help you bring out the best of yourself during the interview process, we’ve got some great interview tips to share before the big day.