Data Modeler

New York City, NY - USA

Monthly Salary: Not Disclosed

Posted on: 12 hours ago

Vacancies: 1 Vacancy

Job Summary

Must Have Technical/Functional Skills

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

Roles & 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

Skills Needed:

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

TCS Employee Benefits Summary:

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.

Salary Range: $120000 - $140000 a year

Must Have Technical/Functional Skills 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 Roles & Responsibilities Apply ER Studio and Data Mod...