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