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.