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

Key technologies and capabilities for this role

ER StudioData ModelingDatabricksAWSSpark SQLPySparkSQLUnity CatalogOracleRedshiftMedallion Architecture

Questions & Answers

Common questions about this position

What are the key skills required for the Senior Data Modeler role?

The role requires 4+ years of hands-on data modeling experience with ER Studio, strong SQL skills, good Databricks skills with understanding of Medallion Architecture, and working knowledge of Unity Catalog. Additional needs include strong data modeling across Conceptual, Logical, Physical levels, experience with financial sector data like market securities and fixed income, and knowledge of DBMS like Oracle, Redshift, and Databricks. Strong verbal, presentation, and written communication skills are also essential.

Is this Senior Data Modeler position remote or office-based?

This information is not specified in the job description.

What is the salary or compensation for this role?

This information is not specified in the job description.

What is the company culture like at Lab49/ION?

Lab49/ION is committed to maintaining a supportive and inclusive environment for people with diverse backgrounds and experiences, respecting varied identities, abilities, cultures, and traditions. They adhere to an equal employment opportunity policy that prohibits discriminatory practices or harassment.

What makes a strong candidate for this Senior Data Modeler position?

A strong candidate has a data management background with hands-on experience supporting data pipeline teams, 4+ years in data modeling using ER Studio, financial sector experience especially with market securities and fixed income, and proficiency in Databricks, SQL, and communication skills.

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