Data Modeler (1114295) Job at The Judge Group, New York, NY

SHBwa29WWWdXMkRWSmtuUFlNTFdBbUJw
  • The Judge Group
  • New York, NY

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

University of Miami

Assistant Professor of Clinical - Psychiatry & Behavioral Sciences Job at University of Miami

 ...please review this tip sheet . Job Summary: This position reports to the Chairman of the Department of Psychiatry and Behavioral Sciences and is the primary liaison between the Department of Psychiatry and Behavioral Sciences and JMH Child and Adolescent... 

Two95 International Inc.

React Native Developer Job at Two95 International Inc.

 ...Research, develop & maintain excellent React Native application with clean code. Convert and implement UI/UX design and business functional requirements into fully-functional mobile application. Help to resolve unique and large scale technical mobile problems.... 

ManpowerGroup

Safety Coordinator Job at ManpowerGroup

Our client, a leader in the industrial gases sector, is seeking a dedicated **Safety Coordinator** to join their team. As a Safety Coordinator, you will be an integral part of the safety and compliance department supporting operational excellence. The ideal candidate will... 

HF Sinclair

Instrument Technician Job at HF Sinclair

 ...Basic Function HF Sinclair in Anacortes, WA is seeking an I&E Technician. This positon's primary duties include: troubleshooting, testing, repairing of existing installations and maintaining Instrument and Electrical systems. Job Duties Perform all job tasks with... 

Daniels & Tredennick PLLC

Family Office Accountant Job at Daniels & Tredennick PLLC

 ...professional to manage and track all aspects of an individual's private investment portfolio. This role includes investment accounting,...  ...services. ~ Strong knowledge of investment types (private equity, real assets, marketable securities). ~ Proficiency in Excel;...