Data Modeler

Job Title: Google Cloud Platform Data Modeler

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