Principal Data Architect Remote

David's Bridal•King of Prussia, PA

4d•$128,800 - $193,200•Remote

About The Position

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.

Requirements

7–10+ years experience in enterprise data engineering, architecture, or platform ownership roles.
Proven expertise in: Snowflake (design, security, cost management, workload optimization)
Proven expertise in: 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.

Nice To Haves

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.
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.

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.