Principal Data Architect

Role Description

The Principal Data Architect will lead the design, modernization, and long-term strategy of our enterprise data ecosystem. This role is both strategic and hands-on — ideal for someone who can architect large-scale solutions while actively contributing to modeling, integrations and implementation.

You will shape a modern data foundation supporting commerce, operations, customer experience, analytics, personalization, and executive decision enablement across the organization.

Key Responsibilities

• Define and own the enterprise data architecture roadmap, ensuring scalability, maintainability, and alignment with business strategy.
• Design and implement sophisticated data models supporting commerce, customer lifecycle, finance, supply chain, inventory, and digital transformation initiatives.
• Build and optimize secure data pipelines integrating Shopify and multiple enterprise systems into a unified Snowflake and SQL Server environment.
• Lead standards for data governance, privacy, lineage, cataloging, quality, and master data management.
• Drive best practices for Power BI semantic models, architecture, and performance governance across business functions.
• Provide architectural oversight for ELT frameworks, automation, and orchestration tools (dbt, Airflow, Matillion, Fivetran, etc.).
• Partner with engineering, data, product, and business teams to translate requirements into scalable, future-proof solutions.
• Mentor internal data engineering teams and influence leadership on data strategy and platform investment decisions.
• Serve as the senior technical authority for data architecture across the organization.

Qualifications

• 7–10+ years experience in enterprise data engineering, architecture, or platform ownership roles.
• Proven expertise in:
  • Snowflake (design, security, cost management, workload optimization)
  • SQL Server (schema design, tuning, stored procedures, indexing)
  • Advanced SQL capability with demonstrated experience optimizing large, complex, high volume workloads.
  • Strong experience implementing and supporting Power BI enterprise deployments (governance, semantic layer design, modeling patterns).
  • Hands-on experience with modern ELT tooling and orchestration (dbt, Airflow, Fivetran, Stitch, Matillion, Databricks, etc.).
  • Demonstrated eCommerce data experience, ideally including Shopify — understanding of order lifecycle, OMS, payments, fulfillment, customer segmentation, and attribution.
  • Experience building scalable architecture frameworks aligned to business intelligence, operational reporting, and AI/ML readiness.

Preferred Experience

• Retail or multi-channel commerce experience (stores + eCommerce).
• API experience (REST / GraphQL) and complex system integrations.
• Knowledge of compliance and governance: SOC2, GDPR, CCPA, PCI-DSS.
• Python experience for workflow automation or integration scripting.

Preferred Characteristics

• A senior technical leader who is both visionary and execution-minded.
• Able to influence at executive level while guiding implementation details.
• Practical and business-oriented — not just an architect on paper.
• Thrives in transforming legacy data landscapes into modern, scalable platforms.

Benefits

• Full Time Opportunity – A comprehensive benefits package is available.
• Rewarding Environment and Competitive Pay.
• Generous Dream Maker Discount After First Pay Period.
• Referral Incentive Program.
• Dayforce Wallet – Get Paid Early!
• Health/Dental/Vision Insurance.
• 401K Program.
• Paid Vacation, Wellness Days & Holidays, including your Birthday off!
• Pet Benefits.