Data Architect - Microsoft Fabric

DescriptionRole Summary: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 ResponsibilitiesData Platform Architecture & StrategyDesign 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 strategyDefine scalable patterns for:Incremental processing and change data capture (CDC)Global identifiers (customer, vehicle, store)Data governance, lineage, and auditingEstablish platform standards and best practices to support long-term scalabilityData Engineering & IntegrationLead implementation of:Fabric PipelinesNotebooks (Spark/PySpark)Data transformations and conformance layersOversee consolidation of legacy SQL Server data sources (ICDB, DME) into a single unified lakehouseEnsure readiness for downstream consumers including:Power BI reportingSAP, CRM, and operational systemsExternal partners and data providersBusiness Requirements & Data ModelingPartner with stakeholders across business and technology teams to:Gather and structure data requirementsDefine canonical POS data modelsTranslate business needs into scalable data productsValidate and map AutoLeap source data to target data structuresData Quality, Testing & ValidationDefine and execute robust validation frameworks including:Data reconciliation against legacy systemsCompleteness and accuracy checksPerformance and SLA validationDevelop formal testing strategies and acceptance criteriaLeadership & EnablementAct as a technical leader and advisor across the organizationMentor and upskill internal teams through:Pair programming and solution design sessionsDocumentation of frameworks and patternsDrive alignment across engineering, analytics, and business stakeholdersRequired QualificationsCore Experience7–12+ years in data engineering, architecture, or platform rolesDeep, hands-on expertise with Microsoft Fabric, including:LakehousesFabric PipelinesSpark / PySpark notebooksSemantic models and Power BIStrong experience with modern data architectures:Lakehouse patternsMedallion architectureDistributed data processingTechnical ExpertiseExperience with:API-based ingestion and relational data sources (Postgres preferred)Designing enterprise data models and data productsHybrid data ecosystems (analytics + operational integrations)Familiarity with:Azure data ecosystemData governance and lineage toolsPerformance optimization at scaleDomain & Delivery ExperienceExperience working with transaction-heavy systems (POS, retail, franchise, automotive, or similar)Proven success leading system-of-record data migrations or platform transformationsExperience supporting both:Internal analytics/reporting use casesExternal data distribution (partners, vendors)Leadership & Soft SkillsAbility to operate independently in ambiguous, fast-paced environmentsStrong communication skills across:Technical teamsBusiness stakeholdersComfortable balancing roles as:ArchitectHands-on builderMentor / educatorPreferred QualificationsPrior experience implementing Microsoft Fabric in production environmentsExperience modernizing from legacy SQL Server data platformsFamiliarity with franchise or multi-location business modelsSkillsmicrosoft, lakehouse, Data, Data architecture, apiTop Skills Detailsmicrosoft,lakehouse,DataAdditional Skills & QualificationsMicrosoft FabricExperience LevelIntermediate LevelJob Type & LocationThis is a Contract position based out of Palm Beach Gardens, FL.Pay and BenefitsThe pay range for this position is $55.00 - $75.00/hr.Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: • Medical, dental & vision • Critical Illness, Accident, and Hospital • 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available • Life Insurance (Voluntary Life & AD&D for the employee and dependents) • Short and long-term disability • Health Spending Account (HSA) • Transportation benefits • Employee Assistance Program • Time Off/Leave (PTO, Vacation or Sick Leave)Workplace TypeThis is a fully remote position.Application DeadlineThis position is anticipated to close on Jun 9, 2026. 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. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. 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. About TEKsystems and TEKsystems Global Services We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com. The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records. Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.