Data Modeler
Share
Job Location:
New York City, NY - USA
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Job Title: Modeller
Location: New York NY (onsite)
job Type: full time
Job Description
Skill: Data Modeler
Must Have Technical/Functional Skills:
- ER Studio and Data Modeling expertise Delivery of Data products leveraging Databricks on AWS Strong Data modeling (Conceptual Logical Physical 3nF Dimensional) at both enterprise and data product level.
Roles & 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 Needed:
- 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
Key Skills
- Atl
- CMMS
- ABAP
- Community Support
- CRM
- Fleet
