Retail Data Architect

About the role

The ideal candidate will play a key role in rearchitecting and modernizing enterprise business applications and data models for scalable, high-performance platforms on Google Cloud Platform (GCP).

Responsibilities

• Design and develop enterprise data models using Erwin for both OLTP and OLAP environments, including support for JSON and mixed data types.
• Create and optimize modernized web application data models focused on scalability, performance, and efficient application processing.
• Reverse engineer existing data models and transform them into future-state architectures aligned with business and technical requirements.
• Lead data modeling efforts for modernization and re-architecture initiatives across enterprise applications.
• Define and implement data governance and data management best practices.
• Evaluate and recommend appropriate database technologies on GCP for structured and unstructured datasets.
• Work across multiple database technologies including DB2, Cloud SQL, AlloyDB, BigQuery, and related platforms.

Requirements

• Strong hands-on experience with Erwin Data Modeling tools.
• Expertise in designing OLTP and OLAP data models, including JSON-based and complex data structures.
• Experience building high-performance data models for modern web applications.
• Strong understanding of data governance, metadata management, and data management principles.
• Experience with GCP database selection strategies and cloud-native architecture.
• Hands-on experience with technologies such as DB2, Cloud SQL, AlloyDB, BigQuery, and other modern database platforms.
• Strong retail domain experience with understanding of retail workflows, business processes, and data dependencies.
• Proven experience in rearchitecting legacy application data models for modern technology stacks.
• Ability to reverse engineer and modernize complex enterprise data models.
• Strong communication and leadership skills with experience working in onsite-offshore delivery models.
• Self-driven, adaptable, and capable of navigating ambiguity and changing priorities.
• Solid understanding of Domain Driven Design patterns and principles.

Preferred Qualifications

• Experience with enterprise modernization and digital transformation initiatives.
• Prior experience leading data architecture discussions with business and technical stakeholders.
• Exposure to cloud-native application architectures and distributed systems.

Skills

• Cloud data architecture
• Web application data modeling
• Data governance
• Data management

Benefits

• Minimum 10 days of paid vacation per year
• 6 days of paid sick leave each year (pro-rated for new hires)
• 10 paid holidays
• Eligible for paid bereavement leave and jury duty
• Eligible to participate in the Company’s 401(k) Retirement Plan with employer matching
• Medical, dental, and vision insurance
• Accidental death and disability insurance
• Short- and long-term disability benefits
• Eligible to participate in a Health Savings Account (HSA) and a Flexible Spending Account (FSA) for healthcare, dependent child care, and/or commuting expenses as allowable under IRS guidelines