Apply on Employer Site

ION · 1 week ago

Senior Data Modeler, New York

New York, United States

Full-time

Onsite

Mid, Senior Level

$165K/yr - $185K/yr

4+ years exp

ION is a specialist strategy, design, and technology consulting company dedicated to the financial services industry. They are seeking an experienced Senior Data Modeler to join their Service Consultant Sub-Practice, focusing on data modeling and collaboration with various architects to capture business requirements and enhance data products.

AccountingAsset ManagementFinanceFinancial ServicesSoftware

H1B Sponsor Likely

Responsibilities

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

Qualification

Data modelingER StudioSQLDatabricksFinancial services experienceUnity CatalogOracle DBMSRedshiftCommunication skills

Required

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

Strong SQL skills

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

Benefits

Discretionary bonus

Company

ION

Glassdoor3.3

ION Group provides solutions for electronic trading, position management, pricing, risk management, and downstream processing for clients.

Founded in 1998

New York, New York, USA

10001+ employees

https://iongroup.com

H1B Sponsorship

ION has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (2)

2024 (1)

2022 (2)

2021 (4)