Job Description
We are seeking an experienced Senior Data Modeler to join our newly created Service Consultant Sub-Practice, working with a long-term client in the financial services industry. This role involves independent work and teamwork, focusing on advancing the client's agenda. The ideal candidate will have an understanding of the financial services sector and a proven track record of collaboration, contributing to an innovative team.
Must Have:
- Apply ER Studio and Data Modeling expertise to a Data Engineering team dedicated to the design, 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.
- 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.
THE ROLE
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.
What you’ll do:
- 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
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
Set alerts for more jobs like Senior Data Modeler
Set alerts for new jobs by Ion
Set alerts for new Data Analysis jobs in United States
Set alerts for new jobs in United States
Set alerts for Data Analysis (Remote) jobs
