Sr Data Modeler with Capital Markets/ Custody

About LTIMindtree

LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 750 clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by nearly 90,000 talented and entrepreneurial professionals across more than 30 countries, LTIMindtree — a Larsen & Toubro Group company — combines the industry-acclaimed strengths of erstwhile Larsen and Toubro Infotech and Mindtree in solving the most complex business challenges and delivering transformation at scale. For more information, please visit

Job Title: Principal Data Modeler / Data Architecture Lead – Capital Markets

Work Location

Jersey City, NJ (Onsite, 5 days / week)

Job Description:

• We are seeking a highly experienced Principal Data Modeler / Data Architecture Lead to reverse engineer an existing logical data model supporting all major lines of business in the capital markets domain.
• The ideal candidate will have deep capital markets domain expertise and will work closely with business and technology stakeholders to elicit and document requirements, map those requirements to the data model, and drive enhancements or rationalization of the logical model prior to its conversion to a physical data model.
• A software development background is not required.

Key Responsibilities

• Reverse engineers the current logical data model, analyzing entities, relationships, and subject areas across capital markets (including customer, account, portfolio, instruments, trades, settlement, funds, reporting, and analytics).
• Engage with stakeholders (business, operations, risk, finance, compliance, technology) to capture and document business and functional requirements, and map these to the data model.
• Enhance or streamline the logical data model, ensuring it is fit-for-purpose, scalable, and aligned with business needs before conversion to a physical model.
• Lead the logical-to-physical data model transformation, including schema design, indexing, and optimization for performance and data quality.
• Perform advanced data analysis using SQL or other data analysis tools to validate model assumptions, support business decisions, and ensure data integrity.
• Document all aspects of the data model, including entity and attribute definitions, ERDs, source-to-target mappings, and data lineage.
• Mentor and guide junior data modelers, providing coaching, peer reviews, and best practices for modeling and documentation.
• Champion a detail-oriented and documentation-first culture within the data modeling team.

Qualifications

• Minimum 15 years of experience in data modeling, data architecture, or related roles within capital markets or financial services.
• Strong domain expertise in capital markets (e.g., trading, settlement, reference data, funds, private investments, reporting, analytics).
• Proven expertise in reverse engineering complex logical data models and translating business requirements into robust data architectures.
• Strong skills in data analysis using SQL and/or other data analysis tools.
• Demonstrated ability to engage with stakeholders, elicit requirements, and produce high-quality documentation.
• Experience in enhancing, rationalizing, and optimizing logical data models prior to physical implementation.
• Ability to mentor and lead junior team members in data modeling best practices.
• Passion for detail, documentation, and continuous improvement.
• Software development background is not required.

Preferred Skills

• Experience with data modeling tools (e.g., ER/Studio, ERwin, Power Designer).
• Familiarity with capital markets, business processes and data flows.
• Knowledge of regulatory and compliance requirements in financial data management.
• Exposure to modern data platforms (e.g., Snowflake, Databricks, cloud databases).

Benefits and Perks:

• Comprehensive Medical Plan Covering Medical, Dental, Vision
• Short Term and Long-Term Disability Coverage
• 401(k) Plan with Company match
• Life Insurance
• Vacation Time, Sick Leave, Paid Holidays
• Paid Paternity and Maternity Leave

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, colour, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.