Senior Data Modeler

Our client works on very challenging and exciting projects and is looking for a Senior Data ModelerSkills 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