Senior Data Modeler, New York

ION Group • New York, NY

83d

About The Position

We are seeking an experienced Senior Data Modeler to join our newly created Service Consultant Sub-Practice and exclusively work with a mature and impactful long-term client in the financial services industry. This role requires a balance of independent work and teamwork, focusing on advancing the client's agenda. The ideal candidate will possess some understanding of the financial services sector, coupled with a proven track record of independent work and team collaboration. Join us to make a meaningful impact and contribute within our innovative team.

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

What This Job Offers

• Career Level: Senior
• Industry: Securities, Commodity Contracts, and Other Financial Investments and Related Activities
• Number of Employees: 1,001-5,000 employees