Associate Principal - Data Engineering

LTIMindtree • Jersey City, NJ

53d • Onsite

About The Position

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.

Requirements

• 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.

Nice To Haves

• 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).

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Principal
• Industry: Professional, Scientific, and Technical Services
• Education Level: No Education Listed