Data Modeler

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 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. #J-18808-Ljbffr Capgemini