Data Modeler
Issaquah, WA – 3 Days
Must Have Skills – Data Modeler
Skill 1 – 8 + Years of exp in Data Modeling
Skill 2 – 3 + Years of Exp in GCP
Skill 3- 6+ Years In Erwin, Snowflake, Python, Snowflake, 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, Snowflake, Python, Snowflake, Azure Synapse, Experience with cloud platform(Azure, GCP)
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 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.
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.
