Data and Analytics Architect - MS Fabric

Sys Logic is seeking an experienced Data and Analytics Architect to lead the design of modern data and analytics platforms, with deep, hands‑on architecture experience in Microsoft Fabric. The role combines broad data and analytics architecture expertise (strategy, patterns, integration, governance and modernization) with the platform depth to design and to deliver production Fabric solutions.

The architect is responsible for the architecture from discovery and design through delivery and handoff, stays hands‑on throughout, and partners with our sales team on new opportunity pursuits. This role requires demonstrating a strong understanding of our clients’ business challenges and the ability to communicate technical solutions without unnecessary jargon.

• Partner with clients, business analysts and stakeholders to translate business requirements into scalable, efficient data and analytics solutions.
• Assess clients’ current data environments, define target architectures, and build phased roadmaps.
• Select and apply the right architecture pattern and communicate the trade‑offs to stakeholders.
• Design end‑to‑end architectures in Microsoft Fabric, covering One Lake, Lakehouse and Warehouse, data integration, data modeling, semantic models and reporting.
• Design integration from diverse sources (ERP, CRM, SaaS, APIs, files and streaming), including batch, incremental and change data capture patterns, using Fabric Data Factory, Dataflows Gen2, Spark notebooks and Azure Data Factory.
• Lead modernization and migration from on‑premises SQL Server, SSIS/SSAS, Azure Synapse Analytics and Power BI Premium to Microsoft Fabric.
• Design the semantic layer and reporting standards and guide report developers.
• Size, monitor and optimise Fabric capacity and consumption costs, and identify and resolve performance bottlenecks.
• Define data governance, data quality, lineage and metadata practices, and partner with our Security practice on data security, privacy and compliance.
• Conduct data architecture reviews and assessments, identify gaps, and recommend scalable, secure, high‑performance solutions.
• Provide technical leadership and guidance to data engineers, analysts and other team members to ensure successful delivery.
• Be a strong collaborator amongst organisational practices to ensure solutions meet Sys Logic’s quality standards for design and security.
• Support new opportunity pursuits by developing solution approaches, effort estimates and SOW inputs, and by presenting architecture options to clients.

• Data modelling (dimensional and normalised), data warehousing, and lakehouse and medallion design.
• Data integration across diverse sources, ETL/ELT development, pipeline orchestration and performance tuning.
• Data governance, data quality, metadata management, lineage and master data concepts.
• Data security and compliance considerations in the context of analytics.
• Source control and CI/CD with Azure Dev Ops or Git Hub, and delivery within Agile/Scrum methodologies.
• Related Azure services:
  Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Azure SQL and SQL Server.

• One Lake:
  Lakehouse vs. Warehouse vs. Eventhouse selection, shortcuts and mirroring, and Delta/Parquet storage design.
• Data engineering:
  Data Factory pipelines, Dataflows Gen2 and Spark notebooks, and when to use each.
• Semantic layer:
  Direct Lake semantic models, composite models, DAX optimisation and enterprise Power BI design.
• Workspace and tenant design: work spaces, domains, capacities (F SKUs), capacity monitoring and cost management.
• Security and governance: workspace and item permissions, One Lake data access, row‑ and object‑level security, and…