Snowflake Data Modeler

Job Title: Data Modeller Location: Remote Job Type: Full time Years of Experience- 6-10 years About Straive: Straive is a market leading Content and Data Technology company providing data services, subject matter expertise, & technology solutions to multiple domains. Data Analytics & Al Solutions, Data Al Powered Operations and Education & Learning form the core pillars of the companys long-term vision. The company is a specialized solutions provider to business information providers in finance, insurance, legal, real estate, life sciences and logistics. Straive continues to be the leading content services provider to research and education publishers. Data Analytics & Al Services: Our Data Solutions business has become critical to our client's success. We use technology and Al with human experts-in loop to create data assets that our clients use to power their data products and their end customers' workflows. As our clients expect us to become their future-fit Analytics and Al partner, they look to us for help in building data analytics and Al enterprise capabilities for them. With a client-base scoping 30 countries worldwide, Straive's multi-geographical resource pool is strategically located in eight countries - India, Philippines, USA, Nicaragua, Vietnam, United Kingdom, and the company headquarters in Singapore. Website: Overview /Objective: We are seeking a Senior Data Modeler to help us build our Enterprise Data Platform. This role requires both deep technical knowledge and the ability to communicate effectively with business stakeholders. You will be hands-on in architecting and developing the core data models that support our most critical and impactful business metrics. Key Responsibilities Data Modeling: Design, implement, and maintain robust data models (star and snowflake schemas) for core business domains using Snowflake and dbt, ensuring our data platform supports diverse analytics needs across the organization. SCD2 Implementation: Engineer Slowly Changing Dimensions Type 2 (SCD2) data structures in dbt, ensuring high accuracy, lineage tracking, and consistency for evolving business attributes. ERD Creation: Develop and maintain comprehensive Entity Relationship Diagrams (ERDs) for all data domains, using tools such as Query Performance: Write and optimize complex SQL queries to support analytical workflows, ensuring high performance and efficiency. Data Transformations: Own and orchestrate data transformation activities, leveraging dbt to structure, document, and test data pipelines. Job Description Data Quality: Implement rigorous data quality checks and automated testing, upholding best practices for naming conventions, data types, data structures, and clear documentation. Standards & Governance: Ensure all logic adheres to established data architecture standards; actively participate in evolving and improving these frameworks with the team. Collaboration: Work closely with Analytics Engineers, BI Engineers, and business stakeholders to gather requirements, troubleshoot issues, and translate business needs into scalable technical solutions. Version Control & Automation: Use Git for version control, contributing to collaborative and well-structured codebases; utilize command line tools to automate, monitor, and maintain the data modeling environment. Maintenance: Respond to issues as they arise and participate in resolution and troubleshooting based on priority. Required Experience & Skills 5+ years of experience in data modeling, with a strong focus on Kimball-style dimensional modeling Deep understanding and hands-on experience with SCD2 (Slowly Changing Dimension Type 2) modeling Experience with BI tools and a solid understanding of how data models drive business analytics Proficiency in dbt, including implementation of macros, hooks, and custom tests Advanced skills in Snowflake, including query optimization and use of advanced functions Proficient with Git and comfortable working on the command line (preferably on Mac workstations) Experience working in customer, order, manufacturing and shipping domains Technical Stack Experience - Required: Snowflake, dbt, familiarity with BI tools, ERP Preferred: Fivetran, Looker, Microsoft D36