Job Description

Location:

New York City, NY

Salary: $135,000.00 USD Annually - $140,000.00 USD Annually

Description

Job Title: Data Modeler

Location: Hybrid – New York, NY 10045

Employment-Fulltime

Role Overview

We are seeking a highly skilled Data Modeler with ER Studio expertise to join a Data Engineering team focused on designing, developing, and delivering data products leveraging Databricks on AWS . This role involves creating robust data models at both enterprise and data product levels, ensuring alignment with business requirements and industry standards.

Key Responsibilities

• Apply ER Studio and advanced data modeling techniques (Conceptual, Logical, Physical, 3NF, Dimensional) to support enterprise and product-level data architecture.
• Collaborate with Business Architects, Solution Architects, and Data Stewards to capture business requirements and translate them into conceptual and logical data models.
• Maintain and enhance data modeling standards and guidelines.
• Validate physical data models to ensure consistency with logical designs.
• Develop Databricks notebooks using Spark SQL and PySpark for data engineering tasks.
• Support enterprise data catalog setup and enrichment (Unity Catalog).
• Contribute to building and testing data pipelines for data products.

Required Skills & Experience

• 4+ years of hands-on data modeling experience with ER Studio.
• Strong expertise in Conceptual, Logical, Physical modeling, 3NF, and Dimensional modeling.
• Solid SQL skills for data analysis and transformation.
• Experience with Databricks and understanding of Medallion Architecture.
• Working knowledge of Unity Catalog.
• Familiarity with traditional DBMS (Oracle) and cloud DBMS (Redshift, Databricks).
• Background in data management and supporting data pipeline development.
• Experience in financial sector, especially market securities reference data and fixed income instruments (e.g., Treasuries).
• Strong communication skills (verbal, written, and presentation).

Nice to Have

• Knowledge of AWS services related to data engineering.
• Exposure to data governance and metadata management.

By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.

Contact: ssharma17@judge.com

This job and many more are available through The Judge Group. Find us on the web at

Job Tags

Full time,

Similar Jobs