Data Modeler

At Sogeti, we believe the best is inside every one of us. Whether you are early in your career or at the top of your game, we'll encourage you to fulfill your potential to be better. Through our shared passion for technology, our entrepreneurial culture , and our focus on continuous learning, we'll provide everything you need to do your best work and become the best you can be.

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

• 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 http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law

Part of the Capgemini Group, Sogeti makes business value through technology for organizations that need to implement innovation at speed and want a local partner with global scale. With a hands-on culture and close proximity to its clients, Sogeti implements solutions that will help organizations work faster, better, and smarter. By combining its agility and speed of implementation through a DevOps approach, Sogeti delivers innovative solutions in quality engineering, cloud and application development, all driven by AI, data and automation.