Apply on Employer Site

LTIMindtree · 1 month ago

Associate Principal - Data Engineering

Jersey City - New Jersey - USA

Full-time

Onsite

Lead/Staff

15+ years exp

LTIMindtree is seeking a highly experienced Principal Data Modeler / Data Architecture Lead to work in the capital markets domain. The role involves reverse engineering an existing logical data model and collaborating with stakeholders to enhance and document data requirements.

ConsultingEnterpriseInformation TechnologySoftware

H1B Sponsor Likely

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

Qualification

Data ModelingData ArchitectureCapital MarketsSQLData Analysis ToolsERwinER StudioSnowflakeDatabricksStakeholder EngagementMentoringDocumentation

Required

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

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

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

Company

LTIMindtree

Glassdoor3.6

LTIMindtree is a worldwide technology consulting and digital solutions company that empowers businesses in a variety of sectors.

Founded in 1996

Mumbai, Maharashtra, IND

10001+ employees

https://www.ltimindtree.com

H1B Sponsorship

LTIMindtree has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (2651)

2024 (2855)

2023 (2267)