Data Architect - Commerce
$31,200–$31,200 year
RemoteUnited States
Job Summary
Define and lead the enterprise data architecture for Cordance Commerce, unifying reporting platforms and analytics across Solutions, Secure Retail, Upright, and Pearl Dive. Assess current transactional databases and pipelines to document dependencies and risks, then establish a shared data model and master-data strategy for core entities like customer, inventory, and transactions. Design the separation of transactional and analytical workloads using cloud data warehouses or lakehouses, evaluating platforms such as Snowflake for scale and cost. Create a phased migration strategy to consolidate reporting while maintaining business continuity, and develop standards for ingestion, transformation, and observability. Partner with DBAs and BI professionals to rationalize standard and customer-specific reports through reusable datasets and governed self-service analytics. Guide teams on PostgreSQL and SQL modernization, replication patterns, and performance isolation, while establishing data governance practices covering ownership, security, and quality. Lead technical discovery, architecture reviews, and vendor evaluations to translate findings into actionable designs and investment recommendations.
Required Qualifications
- Bachelor's degree in Computer Science, Information Systems, Engineering, Data Management, or a related field, or equivalent practical experience
- 8+ years of experience in data engineering, database architecture, analytics engineering, or business intelligence, including 3+ years in a data architecture or senior technical leadership role
- Demonstrated experience designing enterprise data warehouses, lakehouses, or analytical platforms and migrating data from multiple operational systems
- Strong data-modeling expertise across conceptual, logical, and physical models, including dimensional modeling and normalized transactional designs
- Hands-on proficiency with SQL, relational databases, ETL/ELT patterns, orchestration, data quality, metadata, lineage, and BI semantic models
- Experience separating reporting workloads from high-volume transactional systems and designing for performance, resilience, scalability, and cost control
- Experience with cloud data platforms and modern data integration patterns, including APIs, replication, and change data capture
- Strong written and verbal communication skills, including the ability to present architecture decisions and tradeoffs to technical and non-technical audiences
Desired Qualifications
- Hands-on experience with Snowflake and at least one major cloud platform such as AWS, Azure, or Google Cloud
- Experience with PostgreSQL and Microsoft SQL, including modernization or migration initiatives
- Experience consolidating reporting platforms following acquisitions or across a multi-product SaaS portfolio
- Experience rationalizing large libraries of standard and customer-specific reports and enabling governed self-service analytics
- Familiarity with retail, point-of-sale, inventory, e-commerce, donation, or thrift/resale data domains
- Knowledge of data privacy, security, role-based access, audit, retention, and compliance practices
- Experience enabling machine learning, generative AI, or agentic AI use cases through governed enterprise data products
- Relevant cloud, Snowflake, data-management, or architecture certification is a plus
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.