Cavendish Professionals

Senior Data Modeler

Our client works on very challenging and exciting projects and is looking for a Senior Data Modeler


Skills and Experience:



  • 5+ years of hands-on data modeling experience.

  • Expert proficiency with Erwin Data Modeler (modeling best practices, DDL generation, model mart/repository, version control).

  • Deep experience with dimensional modeling and the Kimball methodology; proven delivery of star/snowflake schemas and conformed dimensions.

  • Strong AWS data stack experience: Redshift (performance tuning and optimization), Glue (ETL/ELT with PySpark), and S3 data lake design.

  • Advanced SQL skills and practical performance optimization in Redshift.

  • Solid grasp of data governance, metadata management, lineage, and data cataloging (Glue Data Catalog or equivalent).

  • Demonstrated application of HIPAA compliance and PHI/PII protection in data designs.#

  • Excellent communication, documentation, and stakeholder engagement skills; ability to translate between business and technical domains.


Further Information:



  • Duration: Long term contract (B2B)

  • Workload: Remote





Share Job