GCP Data Modeler

Cardinal Integrated • Issaquah, WA

69d

About The Position

We are looking for a GCP Data Modeler to join our team in Issaquah, WA for a 6-12+ months contract. The ideal candidate will have extensive experience in data modeling, particularly within the retail sector, and will be responsible for designing and maintaining data models that support various retail systems.

Requirements

• 8+ years of experience in Data Modeling.
• 3+ years of experience in GCP.
• 6+ years of experience in Erwin, Snowflake, Python, and Azure Synapse.
• Bachelor's or Master's 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, GCP) 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.

Nice To Haves

• 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.

Responsibilities

• Design and maintain conceptual, logical, and physical data models for retail systems including POS, inventory, CRM, and e-commerce platforms.
• Analyze and reverse engineer existing table structures from legacy systems to understand data relationships and dependencies.
• Build comprehensive mapping documents to support one-time data loads from legacy systems into modern data platforms.
• Write and optimize complex SQL queries for data profiling, transformation, validation, and reporting.
• Develop models that support customer segmentation, product performance tracking, and personalized marketing.
• Work with data engineers, business analysts, and merchandising teams to translate retail business needs into scalable data solutions.
• Develop and optimize ETL pipelines for integrating data from retail systems using tools like Talend, SSIS, or Azure Data Factory.
• Architect retail data warehouses and data lakes to support reporting and advanced analytics.
• Ensure data models adhere to governance standards and support high data quality across retail domains.
• Maintain metadata repositories and document data lineage, definitions, and usage across retail systems.
• Monitor and tune data models for performance, especially for high-volume retail transactions and real-time analytics.
• Identify ways to improve data reliability, efficiency, and quality of data management.

What This Job Offers

• Industry: Professional, Scientific, and Technical Services
• Education Level: Bachelor's degree
• Number of Employees: 11-50 employees