Data Architect (Part-time) – E-commerce & Marketplace Platform (GCP / BigQuery)

Square One Resources is recruiting for a global e-commerce and marketplace platform operating across North America and multiple international regions, supporting millions of customers and partners with complex financial operations including merchant settlements, payments, promotions, taxation, and revenue reporting.

• Proven experience as a Data Architect or Lead Data Engineer in large-scale data environments
• Strong hands-on experience with Google Cloud Platform, especially BigQuery
• Solid background in data warehousing architecture, ideally medallion/layered models
• Experience in migration projects from legacy DWH solutions such as Teradata to cloud platforms
• Strong knowledge of Apache Airflow and end-to-end data pipeline design
• Experience with data governance, metadata management, and data catalog solutions like OpenMetadata
• Understanding of CI/CD practices for data engineering including Git, Jenkins, Terraform, and Flyway
• Strong SQL expertise and experience with large-scale data modeling
• Experience in finance, payments, or regulated environments (tax, compliance, auditability) is highly desirable
• Strong communication skills and ability to work in a global, cross-functional environment

• Define and enforce Bronze / Silver / Gold data architecture principles across the platform
• Lead global data model harmonization including conformed dimensions, unified fact models, and SCD2 implementation
• Drive migration from Teradata to Google BigQuery, including parallel run strategy and validation approach
• Design and standardize end-to-end data pipelines (ingestion → transformation → consumption) using Apache Airflow
• Establish enterprise data governance framework covering lineage, metadata management, RBAC, and auditability
• Implement data quality and observability framework with automated validation and pipeline gating mechanisms
• Define CI/CD standards and support schema evolution processes using Git-based workflows and Flyway
• Optimize performance and cost efficiency with partitioning, clustering, and aggregation strategies in BigQuery
• Ensure architectural alignment with finance, tax, and regulatory compliance requirements