Senior Data Modeler

This is a fully remote position, open to applicants in California.

📋 Description

• Create and oversee data models that facilitate analytics, reporting, and business intelligence.

• Contribute to the strategy for the semantic layer by establishing consistent metrics, dimensions, and business logic.

• Develop serving-layer models that act as the definitive source for business definitions.

• Construct and manage semantic views and metrics layers, including Snowflake semantic views and dbt semantic layers.

• Empower analysts and AI tools to access curated data without the need to re-derive business logic.

• Collaborate with analytics and BI users to comprehend the utilization of downstream models.

• Refine semantic definitions based on actual query patterns.

• Review existing reports and dashboards to identify inconsistent metric definitions.

• Merge inconsistent definitions into regulated semantic models.

⛳️ Requirements

• Over 5 years of experience in data modeling or a related field.

• Proven experience functioning at a senior or technical lead level.

• Background in designing or maintaining a semantic layer or metrics layer, such as dbt Semantic Layer, LookML, Snowflake semantic views, or Cube.

• Strong comprehension of the distinction between a data model and a semantic model.

• Proficient SQL skills.

• In-depth knowledge of relational database design.

• Experience in modeling data within contemporary cloud data warehouses, including Snowflake, BigQuery, or Redshift.

• Familiarity with transformation frameworks like dbt.

• Solid understanding of data governance, metadata management, and documentation practices.

• Exceptional communication skills with the capability to translate business requirements into technical designs.

• Foundational knowledge in dimensional modeling, including Kimball and/or Inmon methodologies.

• Experience with data catalog or governance tools, such as Collibra, Alation, or Atlan.

• Knowledge of data mesh or data product concepts.

• Background in a relevant industry sector, such as finance, healthcare, or retail.

• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent practical experience preferred.

🏝️ Benefits

• Health Insurance

• Savings and Retirement Plan

• Employee Assistance Program

• Generous Vuori Discount & Industry Perks

• Paid Time Off

• Wellness & Fitness benefits

• Bonus eligible