Data Modeler

Jersey, NJ - USA

Monthly Salary: Not Disclosed

Posted on: 7 days ago

Vacancies: 1 Vacancy

Job Summary

Data Modeler

Location: Jersey City NJ (Hybrid 3 days onsite)
Interview: Teams possible in-person final (must agree at submittal)
Visa: No H1 or OPT (GC USC GC-EAD H4-EAD L2-EAD only)
Exp: 10 years
Duration: 12 months

Assessment:

Submittal requires: Resume birth day/month last 4 SSN

Responsibilities:

Design implement optimize data warehouse data models
Work extensively with IBM IDA (InfoSphere Data Architect) for logical/physical models
Ensure models are scalable performant aligned with data strategy
Collaborate with data engineers on Azure and Databricks implementation
Translate business requirements into conceptual/logical/physical models
Participate in data architecture discussions and best practices
Document data models flow diagrams database design specs
Support analytics reporting and data integration needs with stakeholders
Perform impact analysis for model changes on downstream systems
Continuously improve and optimize models for performance and accessibility

Required Skills:

10 years data modeling (enterprise data warehouse)
IBM IDA (InfoSphere Data Architect) non-negotiable
Azure (Azure SQL Data Lake Synapse)
Databricks (Unity Catalog Delta Lake)
Conceptual / logical / physical modeling
Investment Banking / Financial Services domain (strongly preferred)
SQL for validation and optimization
Stakeholder management & documentation
ERwin or ER/Studio (plus not required)

Nice to Have:

Data governance / metadata management tools
Agile methodology
Snowflake or Azure Synapse
Financial services data domains (risk finance regulatory reporting)

Data Modeler Location: Jersey City NJ (Hybrid 3 days onsite) Interview: Teams possible in-person final (must agree at submittal) Visa: No H1 or OPT (GC USC GC-EAD H4-EAD L2-EAD only) Exp: 10 years Duration: 12 months Assessment: Submittal requires: Resume birth day/month last 4 SSN Re...