Data Modeler

Cardinal Integrated Technologies Inc Logo
Cardinal Integrated Technologies Inc
Issaquah, WA, United States (Remote)
  • Logistics
  • Shift
  • Applications have closed

HI,

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

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.
Apply for job