Data Modeler

Capgemini; Newark (NJ); On-site; USD 103,330 - 128,656; Full time

Benefits offered by this job

Healthcare including dental and vision

401(k) and Employee Share Ownership Plan

Paid time off

Paid parental leave

Mentoring and coaching programs

Job summary

A leading technology consulting firm seeks a Senior Data Modeler in Newark, NJ. The role involves designing complex data models and implementing DataVault 2.0. Ideal candidates will have strong investment management knowledge and expertise in data architecture. Competitive salary and benefits offered.

Qualifications

• 5+ years of experience in data modeling, architecture, or related fields.
• Strong understanding of investment management processes.
• Hands-on experience with DataVault 2.0 implementation.

Responsibilities

• Lead the design of conceptual, logical, and physical data models.
• Collaborate with architects to build scalable, high-performance data models.
• Design data models using DataVault 2.0 methodology.

Skills

Data modeling

Data architecture

Investment management knowledge

SQL proficiency

Agile methodologies

Education

Relevant degree or certification

Tools

Erwin

IBM InfoSphere Data Architect

Microsoft Visio

Job description

We are seeking a highly experienced Senior Data Modeler with expertise in data modeling, architecture, and analytics. This role is critical in designing and optimizing data models for complex systems across diverse platforms. The ideal candidate will bring domain knowledge in investment management and hands-on experience with DataVault 2.0 implementation.

Job Responsibilities:

• Data Modeling: Lead the design and development of conceptual, logical, and physical data models for enterprise-scale systems.
• Data Architecture: Collaborate with architects to build scalable, high-performance data models for analytics, reporting, and BI.
• Domain Expertise: Apply investment management domain knowledge to align data models with business strategies.
• DataVault 2.0 Implementation: Design and implement data models using DataVault 2.0 methodology.
• Stakeholder Collaboration: Work with business analysts, data engineers, and stakeholders to gather and translate data requirements.Data Governance & Quality: Ensure compliance with data governance, security, and quality standards. Implement validation and quality checks.Performance Tuning: Optimize data models and queries for performance and scalability.Mentorship: Guide and mentor junior data modelers and analysts.
• Best Practices: Define and enforce data modeling standards and best practices.
• Documentation: Maintain comprehensive documentation including ERDs, data dictionaries, and schema definitions.
• Innovation: Stay updated with industry trends and emerging technologies in data modeling and analytics.

Required Skills:

• Experience: data modeling, data architecture, or related fields.
• Domain Knowledge: Strong understanding of investment management processes and data.
• Tools: Proficiency in Erwin, IBM InfoSphere Data Architect, Microsoft Visio, or similar tools.
• Databases: Expertise in SQL, NoSQL, Oracle, SQL Server, MySQL, PostgreSQL, Hadoop, etc.
• Cloud Platforms: Experience with AWS, Azure, or GCP; familiarity with Snowflake, Redshift, BigQuery.
• Design Principles: Deep understanding of normalization, denormalization, star/snowflake schemas, and ETL processes.
• Methodologies: Experience working in Agile and DevOps environments.
• Governance: Knowledge of data privacy, security protocols, and governance frameworks.
• Business Acumen: Ability to align data architecture with business goals and strategies.

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:

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

Salary Transparency Disclaimer:

Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to the highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is $103330 to $128656 / yearly.

This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.

Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Capgemini by 2x

Sign in to set job alerts for “Data Modeler” roles.

New York, NY $116,640.00-$168,750.00 2 weeks ago

New York, NY $129,000.00-$135,000.00 1 week ago

New York City Metropolitan Area $300,000.00-$300,000.00 2 weeks ago

New York, NY $100,000.00-$150,000.00 3 days ago

Quantitative Researcher - Mid-Frequency Equities

New York City Metropolitan Area 3 weeks ago

New York, NY $65,000.00-$100,000.00 2 months ago

Sr Data Modeler- Security Services, custody

Jersey City, NJ $92,432.00-$136,600.00 2 weeks ago

HFT Quantitative Researcher - Equity/Crypto

New York City Metropolitan Area 4 days ago

Quantitative Developer (Python, C++) | Elite Quant Hedge Fund | NYC/ Chicago

New York City Metropolitan Area $50.00-$60.00 3 weeks ago

New York, NY $120,000.00-$150,000.00 1 week ago

Data Engineer for a Research Team at an Elite Asset Management Firm

Jersey City, NJ $110,000.00-$120,000.00 1 month ago

New York, NY $95,300.00-$133,900.00 3 days ago

New York, NY $150,000.00-$200,000.00 2 weeks ago

Manhattan, NY $90,000.00-$130,000.00 1 month ago

New York City Metropolitan Area $150,000.00-$200,000.00 1 week ago

Data Analyst- $150,000-$200,000 + bonus!

New York City Metropolitan Area $150,000.00-$200,000.00 8 hours ago

Junior Quantitative Developer - Volatility

New York, NY $110,000.00-$120,000.00 2 weeks ago

Quantitative Researcher - Trading & Execution

New York, NY $150,000.00-$225,000.00 12 hours ago

Quantitative Researcher - Systematic Equities

New York, NY $200,000.00-$225,000.00 3 weeks ago

New York City Metropolitan Area $200,000.00-$250,000.00 4 days ago

Want to work with us, but don't see the right job listed?

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.