Overview
On Site
USD 135,000.00 - 140,000.00 per year
Full Time
Skills
Data Architecture
Collaboration
Apache Spark
PySpark
Testing
Data Modeling
ER/Studio
Physical Data Model
Dimensional Modeling
SQL
Data Analysis
Unity
Oracle
Cloud Computing
Database
Amazon Redshift
Databricks
Data Management
Extract
Transform
Load
Finance
Securities
Reference Data
Fixed Income
Communication
Presentations
Amazon Web Services
Data Engineering
Data Governance
Meta-data Management
Privacy
Marketing
Job Details
Location: New York City, NY
Salary: $135,000.00 USD Annually - $140,000.00 USD Annually
Description:
Job Title: Data Modeler
Location: Hybrid -
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
Required Skills & Experience
Nice to Have
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:
This job and many more are available through The Judge Group. Please apply with us today!
Salary: $135,000.00 USD Annually - $140,000.00 USD Annually
Description:
Job Title: Data Modeler
Location: Hybrid -
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:
This job and many more are available through The Judge Group. Please apply with us today!
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.