Senior Data Modeler, New York at ION Group

New York, New York, United States

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

Financial ServicesIndustries

Requirements

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

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

Skills

ER Studio

Data Modeling

Databricks

AWS

Spark SQL

PySpark

SQL

Unity Catalog

Oracle

Redshift

Medallion Architecture

ION Group

Automation technology for financial sector clients

About ION Group

ION Group specializes in automation technology tailored for the financial sector, primarily serving institutional clients like investment banks, asset managers, and brokers. The company provides advanced software solutions that enhance trading, processing, and risk management activities in global financial markets. ION's products include sophisticated software platforms and APIs that enable clients to connect seamlessly to various trading venues and exchanges, ensuring efficient and accurate transactions. Unlike many competitors, ION stands out by acquiring entrepreneurial firms, which allows it to remain agile and responsive to market changes. The company's goal is to enhance efficiency and reduce operational risks for its clients through automation and innovative technology.

London, United KingdomHeadquarters

1998Year Founded

$426.5MTotal Funding

GROWTH_EQUITY_VCCompany Stage

Enterprise Software, FintechIndustries

5,001-10,000Employees

Benefits

Health, dental, and vision insurance

AD&D and disability insurance

Flexible spending account

Health savings account

Life insurance

Mental health care

401K plan

Performance bonus

Supplemental workers' compensation

Family medical leave & parental leave

PTO, paid holidays, sick days, bereavement leave, and volunteer time off

Commuter checks

Company social events

Employee assistance program

Free lunch

mobile phone discount

Risks

Complexity in consolidating trading platforms may lead to operational inefficiencies.

US Treasury market's clearing mandate could impose significant compliance costs.

Potential global tariffs by Trump administration may disrupt ION's global operations.

Differentiation

ION Group specializes in automation technology for the financial sector.

The company offers sophisticated software platforms and APIs for seamless trading.

ION Group constantly innovates to enhance efficiency and reduce operational risks.

Upsides

Increased demand for automation drives innovation in AI-driven trading platforms.

The rise of DeFi creates opportunities for blockchain integration in financial services.

Growing importance of ESG criteria pushes adoption of efficient reporting tools.

Land your dream remote job 3x faster with AI

Try Jobo Free