Data Modeler

Optomi in partnership with a leading consulting firm, is seeking a Data Modeler to design and implement scalable, efficient data models in a Snowflake cloud environment. This role requires deep expertise in data modeling best practices, Snowflake architecture, and collaboration across technical and business teams to align models with enterprise data strategy. Qualifications: • Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent experience). • 5-7+ years of experience in data modeling, data architecture, or database design, preferably in a cloud data warehouse environment. • Strong hands-on experience designing data models in Snowflake. • Proficiency in SQL and familiarity with ETL/ELT design principles. • Experience with dimensional modeling, data vault, or third normal form (3NF) structures. • Strong understanding of data governance, data lineage, and metadata management. • Excellent analytical, problem-solving, and communication skills. Responsibilities: • Collaborate with business stakeholders, analysts, and technical teams to understand data needs. • Analyze source systems, business processes, and reporting requirements. • Conceptual Models: High-level diagrams showing major data entities and relationships, focusing on “what” rather than “how.” • Logical Models: More detailed maps specifying entity attributes, relationships, keys, and business rules—agnostic of any specific technology or database. • Physical Models: Platform-specific blueprints (e.g., for Snowflake, SQL Server, Oracle) showing how data is physically stored, indexed, partitioned, and optimized for performance. • Adopt and implement naming conventions, data dictionaries, and standards. • Ensure consistent master data across the organization and standardize reference data. • Work with database developers and architects to create tables, views, normalization, denormalization, and indexing strategies. • Optimize the models to support query performance and scalability. • Create and maintain up-to-date ERDs (Entity Relationship Diagrams), data flow diagrams, and documentation. • Communicate models and best practices to developers, BI analysts, data scientists, and business users. • Design models that support data security (e.g., access controls, masking sensitive data). • Collaborate on policies for metadata management, lineage, and regulatory compliance (GDPR, HIPAA, etc.). • Review and refactor models as requirements evolve or as new technology is adopted. • Champion best practices for model change management and version control.