Data Modeler - Data Lakehouse

Pointwest is looking for a visionary Data Modeler to serve as the technical lead for our modern data initiatives. This is a role for a high-impact practitioner who has successfully navigated the transition from traditional Data Warehousing to modern Data Lakehouse architectures. Driven by our core values of Leadership, Excellence, and Innovation, you will design the blueprints that transform raw data into a strategic corporate asset. You will embody the Pointwest culture of Agility, Accountability, and Customer Centricity by ensuring the structural health of our data ecosystem and optimizing cloud performance to deliver world-class insights.

Responsibilities

Design and implement conceptual, logical, and physical data models that support both structured SQL analytics and advanced Data Science workloads; Lead the implementation of Bronze, Silver, and Gold data layers to provide stakeholders with curated, high-quality data assets; Act as the first line of defense against "Garbage In, Garbage Out" by designing automated validation scripts and performing root cause analysis on discrepancies; Manage the lifecycle of data schemas to ensure the environment remains scalable and flexible as the business integrates new data sources; Serve as the bridge between complex business logic and technical execution, ensuring all data movements are documented and transparent; Collaborate with engineers to optimize partitioning, clustering, and indexing (e.g., Z-Ordering) to reduce cloud compute costs and improve speed; Enforce enterprise data standards and naming conventions to prevent the creation of "Data Swamps" and ensure a unified logical model; Apply and share knowledge of various modeling techniques, including Dimensional/Star Schema, 3NF, and Data Vault, to solve diverse business challenges

Requirements

5-7 years of dedicated Data Modeling experience within Data Warehouse or Lakehouse environments; Successfully delivered at least 5 distinct data projects from initial requirements through to production; Expert-level proficiency in Kimball/Star Schema and 3NF; hands-on experience with Medallion Architecture; Technical proficiency in Snowflake, Databricks, or Google BigQuery; Experience with industry-standard tools such as erwin, SQLDBM, SAP PowerDesigner, or dbt; Bachelor’s degree in Computer Science, Information Systems, or a related quantitative field