Sr. Data Architect

About the Role

The Senior Data Architect plays a foundational role in building the data infrastructure that will power Precor’s transition from spreadsheet-driven reporting to a governed, scalable analytics platform. This role is responsible for designing and governing the end-to-end data architecture across Microsoft Fabric, SAP ECC 6.0, and Google BigQuery—ensuring data flows reliably from source systems to decision-makers across finance, operations, supply chain, and sales. Working closely with the Director of Data & Insights and cross-functional business leaders, the Senior Data Architect sets technical standards, mentors the data team, and ensures the platform is structured to support machine learning, generative AI, and self-service analytics both today and as the business grows.

Responsibilities

• Architecture and Pipeline Design
  • Design and govern scalable, fault-tolerant data pipelines spanning Microsoft Fabric, SAP ECC 6.0, and Google BigQuery, ensuring reliable data flow from source systems through transformation to BI consumption.
  • Architect end-to-end extraction from complex SAP ECC modules (FI/CO, MM, SD, PP), including medallion (bronze/silver/gold) layering within Fabric’s Lakehouse and OneLake environment.
  • Establish patterns for batch and near-real-time ingestion, including change-data-capture (CDC) strategies that move SAP transactional data without overloading source systems.
  • Design integration strategies that bridge Microsoft Azure and Google Cloud, enabling the two platforms to function as one coherent ecosystem.
  • Evaluate and select ingestion, orchestration, and storage patterns that balance performance, cost, and long-term maintainability.
• Semantic Modeling and AI Enablement
  • Design enterprise semantic models structured for natural-language querying, Copilot integration, and downstream machine learning pipelines.
  • Build and govern the business-logic layer that ensures AI-generated insights are grounded in validated, well-defined metrics.
  • Standardize KPI and business definitions across the organization so that revenue, margin, and active units mean the same thing in every report and every AI-driven answer.
  • Partner with data science to ensure feature stores and training datasets draw from architecturally sound, lineage-tracked sources.
  • Anticipate emerging AI use cases—forecasting, anomaly detection, natural-language analytics—and ensure the architecture can support them without costly redesign.
• Governance, Quality, and Security
  • Establish data governance, lineage, security, and quality frameworks so that data can be trusted, audited, and traced to its source.
  • Define role-based access and data-protection standards that keep sensitive financial, customer, and operational data secure across cloud platforms.
  • Implement data quality monitoring and validation to catch and resolve issues before they surface in reports.
  • Establish cost-optimization and performance standards across Fabric capacity units, treating cloud spend as a managed business resource.
• Strategy, Leadership, and Stakeholder Partnership
  • Serve as the technical authority who translates business strategy into a clear data architecture roadmap and communicates trade-offs in language executives can act on.
  • Partner directly with leaders in finance, operations, supply chain, and sales to ensure the data platform is built around real business questions.
  • Mentor and elevate data engineers, BI developers, and analysts, raising architectural maturity and delivery speed across the team.
  • Set technical standards, review designs, and serve as the final escalation point for complex architectural decisions.
  • Build and defend business cases for new investments in data tooling and capacity with clear, outcome-focused reasoning.

Qualifications

• 5+ years in data engineering or architecture, with 1+ years in a senior or lead architect capacity.
• Deep, hands-on expertise with Microsoft Fabric (OneLake, Lakehouse, Data Factory, Power BI semantic models and dataflows) or equivalent.
• Proven experience extracting and modeling data from SAP ECC 6.0, with real understanding of SAP’s underlying table structures and extraction challenges.
• Strong command of dimensional and semantic modeling (Kimball, star schemas, governed metric layers).
• Demonstrated ability to design architectures that explicitly enable AI and machine learning workloads.
• Track record of connecting technical decisions to measurable business outcomes and communicating them to executive stakeholders.

Preferred Qualifications

• Experience integrating heterogeneous cloud environments (Azure and GCP).
• Familiarity with AI and LLM-driven analytics (Copilot, retrieval-augmented generation over enterprise data, natural-language BI).
• Background in manufacturing, supply chain, or consumer products data domains.
• Production experience with Google BigQuery, including partitioning, performance tuning, and cost management.

Pay

The pay range for this position is $150,000 to $170,000. The actual pay offered will depend on numerous factors including individual performance, business objectives, and location. This range is based at Precor’s Woodinville, WA headquarters.

Benefits

• Medical, dental, and vision insurance
• Generous paid time off policy
• Short-term and long-term disability
• Employee Assistance Program, including access to mental health services
• 401(k) with employer match
• Pet insurance