Cardinal Integrated Technologies Inc ยท 3 months ago
GCP Data Modeler
Issaquah, WA
Full-time
Onsite
Senior Level
7+ years expCardinal Integrated Technologies Inc is seeking a GCP Data Modeler to design and maintain data models for retail systems. The role involves responsibilities such as data migration mapping, SQL development, and collaborating with various teams to translate business needs into scalable data solutions.
BankingInformation TechnologyInsurancePharmaceuticalWeb Development
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
Qualification
Required
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
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
Company
Cardinal Integrated Technologies Inc
We are a company of IT professionals who passionately believe that good quality products & services are delivered by great resources.
201-500 employees
H1B Sponsorship
Cardinal Integrated Technologies Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (5)
2024 (1)
2023 (3)
2022 (5)
2021 (4)
2020 (4)
Funding
Current Stage
Growth StageCompany data provided by crunchbase