Google Cloud Platform Data Modeler

Position: Data Modeler
Location: Issaquah, WA - 3D Onsite Duration: 6-12 Months+

Note: We are looking for a Google Cloud Platform Data Modeler.
Must Have Skills Data Modeler 20285-1
Skill 1 8 + Years of exp in Data Modeling
Skill 2 3 + Years of Exp in Google Cloud Platform
Skill 3- 6+ Years In Erwin, Snowflake, Python, Azure Synapse

Key Responsibilities:
Retail Data Modeling: Design and maintain conceptual, logical, and physical data models for retail systems, including POS, inventory, CRM, and e-commerce platforms.
Reverse Engineering: Analyze and reverse engineer existing table structures from legacy systems to understand data relationships and dependencies.
Data Migration Mapping: Build comprehensive mapping documents to support one-time data loads from legacy systems into modern data platforms.
SQL Development: Write and optimize complex SQL queries for data profiling, transformation, validation, and reporting. Strong SQL skills are a critical requirement for this role.
Customer & Product Analytics: Develop models that support customer segmentation, product performance tracking, and personalized marketing.
Collaboration: Work with data engineers, business analysts, and merchandising teams to translate retail business needs into scalable data solutions.
ETL & Integration: Develop and optimize ETL pipelines for integrating data from retail systems (e.g., ERP, WMS, loyalty platforms) using tools like Talend, SSIS, or Azure Data Factory.
Data Warehousing: Architect retail data warehouses and data lakes to support reporting and advanced analytics.
Governance & Quality: Ensure data models adhere to governance standards and support high data quality across retail domains.
Documentation: Maintain metadata repositories and document data lineage, definitions, and usage across retail systems.
Performance Monitoring: Monitor and tune data models for performance, especially for high-volume retail transactions and real-time analytics.
Identifies ways to improve data reliability, efficiency, and quality of data management. Communicates technical concepts to non-technical audiences, both written and verbal.
Mandatory Skills:
Data Modeling, Erwin, Python, Snowflake, Azure Synapse, Experience with cloud platform(Azure, Google Cloud Platform)
Required Qualifications:
Bachelors or Masters degree in Computer Science, Information Systems, or related field.
7+ years of experience in data modeling, preferably in the retail industry.
Expert-level SQL query development and optimization experience.
Proficiency in Python and data modeling tools like Erwin or ER/Studio.
Experience with cloud platforms (Azure and Google Cloud Platform) and retail data solutions (e.g., Snowflake, Azure Synapse).
Strong understanding of OLTP and OLAP systems in a retail context.
Familiarity with retail KPIs such as sell-through rate, inventory turnover, and customer lifetime value.

Preferred Skills:
Experience with retail analytics platforms (e.g., SAS Retail, Oracle Retail, SAP CAR).
Knowledge of retail compliance standards (e.g., PCI DSS).
Certification in cloud data services or retail analytics tools.
Exposure to AI/ML use cases in retail, such as demand forecasting and recommendation engines.