This job has closed.

Tata Consultancy Services · 1 day ago

Data Modeler

New York, NY

Full-time

Onsite

Mid Level

$120K/yr - $140K/yr

4+ years exp

Tata Consultancy Services is seeking a Data Modeler to join their Data Engineering team. The role involves applying data modeling expertise to design and deliver data products using Databricks on AWS, collaborating with various architects to capture business requirements and ensure alignment between logical and physical data models.

Business Information SystemsConsultingInformation TechnologyIT Management

H1B Sponsor Likely

Responsibilities

Apply ER Studio and Data Modeling expertise to a Data Engineering team dedicated to the design and development, and delivery of Data products leveraging Databricks on AWS

Work with Business Architects, Solution Architects, and Data Stewards to capture business requirements in a Conceptual and Logical Data Model

Contribute to ongoing updates to data modeling standards and guidelines

Evaluate physical data models to ensure they align with the corresponding logical data models

Create notebooks in Databricks in support of development activities (using Spark SQL, PySpark)

Support enterprise data catalog setup and enrichment

Qualification

ER StudioData ModelingDatabricksSQLMedallion ArchitectureUnity CatalogOracleRedshiftCommunication Skills

Required

ER Studio and Data Modeling expertise

Delivery of Data products leveraging Databricks on AWS

Strong Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both enterprise and data product level

Data management background with hands-on work experience in supporting teams that are building and testing data pipelines

4+ years of hands-on data modeling experience with ER Studio

Hands-on strong Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both enterprise and data product level

Strong SQL Skills

Good Databricks skills and understanding of Medallion Architecture

Working knowledge of Unity Catalog

Experience in the financial sector with Market securities reference data and fixed income such as Treasuries

Working knowledge of traditional DBMS platforms like Oracle and Cloud DBMS like Redshift and Databricks

Strong verbal, presentation, and written communication skills

BACHELOR OF COMPUTER SCIENCE

Benefits

Discretionary Annual Incentive.

Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support: Maternal & Parental Leaves.

Insurance Options: Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.

Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Company

Tata Consultancy Services

Glassdoor3.8

Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.

Founded in 1968

Mumbai, Maharashtra, IND

10001+ employees

http://www.tcs.com

H1B Sponsorship

Tata Consultancy Services 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 (7880)

2024 (9690)

2023 (8537)

2022 (11159)

2021 (9813)

2020 (11984)