Data Modeler

Data Modeler

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 by?a 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 organizations?unlock the value of technology and build a more sustainable, more inclusive world.

Job Location - Fort Mills SC (Day One Onsite - Hybrid)

Key Responsibilities

• The Data Modeler is responsible for the development of high performance, scalable enterprise data models on cloud platform.

• Should possess strong SQL skills with excellent data modelling skills.

• Needs to be well versed in the Inmon and Kimball methodologies.

• Should participate in various activities throughout the systems development lifecycle.

• Support new and existing development projects with data and process modeling activities. Provide Conceptual, Logical and Physical data models.

• Create and maintain custom and vendor provided data technical dictionaries for all business systems.

• Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS) and data marts on target platforms.

• Communicates project status, issues, and resolutions with appropriate Lead and/or Managers.

• Estimates level of effort for work assignments and requests received, then communicate accordingly to the Project Manager to determine delivery time.

• Participate in data governance processes related to data quality and information management.

• Evaluating existing data systems, the data structures, relationships, and their data models

• Work with business teams to understand the requirement and develop conceptual/logical/physical data models in the data warehouse.

• Develop data pipelines on AWS using AWS services, HVR, and DBT Required

• 8-10 years of experience in data modeling principles, including conceptual, logical and physical data models.

• 6-8 years of database development experience, using stored procedures, functions and other Database objects.

• Expert in writing complex SQL and optimizing it.

• Experience developing data pipelines on AWS

Required Skills

• Intensive Experience at designing relational and dimensional data models on all Modeling Levels of Conceptual, Logical and Physical Data Models.

• Strong Experience at CA Erwin Data Modeler, Erwin Mart and Erwin Web Portal is Mandatory.

• Working experience in data governance defining a business data dictionary and business metadata.

• Proven, hands-on data modeling and enterprise software design experience in financial industries for OLTP, ODS, Data Warehouse systems.

• Have experience at Domain Driven Data Models.

• Strong verbal and written communication skills.

• Experience communicating with engineers, software professionals, product management and executives to succinctly explain technical and functional concepts.

• Experience with Agile development methodologies

• Ability to serve as a trusted advisor to customers, with a deep curiosity to understand them, their motivations and needs, and how to approach ensuring their success

• Expert knowledge of metadata management and related tools.

• Strong hands-on experience at SQL including Performance tuning, DDL, DML and Complex Queries.

• Good To Prior Experience with Postgres Database.

• Excellent communication and documentation skills.

• Ability to work both independently and as part of a team

Life At Capgemini

Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:

• Flexible work

• Healthcare including dental, vision, mental health, and well-being programs

• Financial well-being programs such as 401(k) and Employee Share Ownership Plan

• Paid time off and paid holidays

• Paid parental leave

• Family building benefits like adoption assistance, surrogacy, and cryopreservation

• Social well-being benefits like subsidized back-up child/elder care and tutoring

• Mentoring, coaching and learning programs

• Employee Resource Groups

• Disaster Relief

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.

Click the following link for more information on your rights as an Applicant

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.

Ref. code:

Posted on: Sep 10, 2025

Experience Level: Experienced Professionals

Contract Type: Permanent

Location:

Columbia, SC, US

Brand: Capgemini

Professional Community: Data & AI

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.