TE

Data Architect - Microsoft Fabric

Job summary

Palm Beach Gardens
Engineering

Work model

Fully remote
Only United States
4 days ago
Job description

Role Summary

Our company is undergoing a critical transformation of its data and analytics ecosystem, anchored by the migration of its Point of Sale (POS) platform from Navex/DST to AutoLeap and the adoption of Microsoft Fabric as the enterprise data platform.

We are seeking a hands-on Microsoft Fabric Architect / Subject Matter Expert (SME) to lead the end-to-end design, build, and rollout of our next-generation data platform. This role will be responsible for ensuring a scalable, high-quality, and business-critical data foundation supporting franchise operations, financial reporting, and external integrations.

This is a high-impact, high-visibility role requiring both deep technical expertise and strong leadership across business and engineering stakeholders.

Key Responsibilities

Data Platform Architecture & Strategy

Design and own the end-to-end Microsoft Fabric architecture, including:

  • Data ingestion from AutoLeap (Postgres, APIs)
  • Lakehouse design using medallion architecture (Bronze / Silver / Gold)
  • Semantic modeling and Power BI integration strategy

Define scalable patterns for:

  • Incremental processing and change data capture (CDC)
  • Global identifiers (customer, vehicle, store)
  • Data governance, lineage, and auditing
  • Establish platform standards and best practices to support long-term scalability

Data Engineering & Integration

Lead implementation of:

  • Fabric Pipelines
  • Notebooks (Spark/PySpark)
  • Data transformations and conformance layers

Oversee consolidation of legacy SQL Server data sources (ICDB, DME) into a single unified lakehouse. Ensure readiness for downstream consumers including:

  • Power BI reporting
  • SAP, CRM, and operational systems
  • External partners and data providers

Business Requirements & Data Modeling

Partner with stakeholders across business and technology teams to:

  • Gather and structure data requirements
  • Define canonical POS data models
  • Translate business needs into scalable data products
  • Validate and map AutoLeap source data to target data structures

Data Quality, Testing & Validation

Define and execute robust validation frameworks including:

  • Data reconciliation against legacy systems
  • Completeness and accuracy checks
  • Performance and SLA validation
  • Develop formal testing strategies and acceptance criteria

Leadership & Enablement

  • Act as a technical leader and advisor across the organization
  • Mentor and upskill internal teams through pair programming and solution design sessions
  • Document frameworks and patterns
  • Drive alignment across engineering, analytics, and business stakeholders

Required Qualifications

Core Experience

  • 7-12+ years in data engineering, architecture, or platform roles
  • Deep, hands-on expertise with Microsoft Fabric, including Lakehouses, Fabric Pipelines, Spark / PySpark notebooks, and Semantic models/Power BI
  • Strong experience with modern data architectures: Lakehouse patterns, Medallion architecture, and distributed data processing

Technical Expertise

  • Experience with API-based ingestion and relational data sources (Postgres preferred)
  • Designing enterprise data models and data products
  • Hybrid data ecosystems (analytics + operational integrations)
  • Familiarity with Azure data ecosystem, data governance/lineage tools, and performance optimization at scale

Domain & Delivery Experience

  • Experience working with transaction-heavy systems (POS, retail, franchise, automotive, or similar)
  • Proven success leading system-of-record data migrations or platform transformations
  • Experience supporting both internal analytics/reporting and external data distribution

Leadership & Soft Skills

  • Ability to operate independently in ambiguous, fast-paced environments
  • Strong communication skills across technical teams and business stakeholders
  • Comfortable balancing roles as architect, hands-on builder, and mentor/educator

Preferred Qualifications

  • Prior experience implementing Microsoft Fabric in production environments
  • Experience modernizing from legacy SQL Server data platforms
  • Familiarity with franchise or multi-location business models

Job Details

  • Type: Contract
  • Location: Palm Beach Gardens, FL (Fully Remote)
  • Pay Range: $55.00 - $75.00/hr
  • Application Deadline: Jun 9, 2026

Benefits

If eligible, benefits may include:

  • Medical, dental & vision
  • Critical Illness, Accident, and Hospital
  • 401(k) Retirement Plan
  • Life Insurance
  • Short and long-term disability
  • Health Spending Account (HSA)
  • Transportation benefits
  • Employee Assistance Program
  • Time Off/Leave (PTO, Vacation or Sick Leave)

About TEKsystems

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.