Data Modeler

Covetus; New York (NY); On-site; USD 100,000 - 140,000; Full time

Job summary

A leading data services company is seeking a Senior Data Modeler in New York, NY. This role demands 10+ years of experience in data modeling, particularly with ER Studio and Databricks on AWS. Responsibilities include delivering data products, capturing business requirements in data models, and supporting ongoing updates to data modeling standards. Strong communication skills and financial sector experience are essential for this position.

Qualifications

• 10+ years of experience required.
• 4+ years of hands-on data modeling experience with ER Studio.
• Experience in financial sector with reference data and fixed income.

Responsibilities

• Deliver data products leveraging Databricks on AWS.
• Capture business requirements in data models.
• Support enterprise data catalog setup.

Skills

Data management background

Hands-on data modeling experience

Strong verbal, presentation, and written communication skills

Tools

ER Studio

Databricks

AWS

Oracle

Redshift

Job description

Sr. Account Manager @ Covetus | Account Management & Client Relations

Title: Data Modeler

Location: NYC, NY

In-Person client interview (Only local candidates)

Job Description:

Must Have Technical/Functional Skills:

• Looking for 10+ Years of experience.
• 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.
• 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.
• 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

Seniority level: Mid-Senior level

Employment type: Full-time

Job function: Information Technology

Industries: IT Services and IT Consulting