Data and Analytics Architect - MS Fabric

SysLogic, Inc.

Town of Brookfield (WI)

Remote

USD 140,000 - 180,000

Full time

3 days ago

Be an early applicant

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Benefits offered by this job

Health care plan (Medical, Dental & V

Retirement plan (401k)

Life Insurance

Paid Time Off

Family Leave

Long Term Disability

Training & Development

Work Life Balance

No company politics

Employee-focused culture

Job summary

SysLogic, Inc. is seeking an experienced Data and Analytics Architect to lead the design of modern data and analytics platforms using Microsoft Fabric. The role combines strategy with hands‑on delivery and partnership with the sales team on new opportunities.

The architect will design end‑to‑end Fabric architectures, guide governance and security, and stay hands‑on throughout the project lifecycle, from discovery to handoff.

Qualifications

Eight+ years in data and analytics, with at least three years in an architect role.
Architect on at least two production Microsoft Fabric implementations.
At least one full lifecycle greenfield architecture engagement.
Bachelor's degree in computer science, data science, information systems or related field, or equivalent professional experience.
Leads requirements elicitation and design discussions with internal and client teams.

Responsibilities

Translate business requirements into scalable, efficient data and analytics solutions.
Define target architectures and build phased roadmaps.
Design end‑to‑end Fabric architectures (OneLake, Lakehouse, Warehouse).
Lead modernization from on‑premises SQL Server/Azure analytics to Fabric.
Define data governance, data quality, lineage and security practices.
Provide technical leadership to data engineers and analysts.

Skills

Architect lead

Data modeling

Data governance

Stakeholder communication

Fabric expertise

ETL/ELT design

Cloud data platforms

Cost optimization

Education

Bachelor's degree in CS/DS/IS or related field

Tools

Azure Data Factory

Azure Synapse

Power BI

Fabric

Job description

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

Primary Responsibilities

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 OneLake, 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 SysLogic’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.

Technical Experience

Data and Analytics Architecture

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 DevOps or GitHub, and delivery within Agile/Scrum methodologies.
Related Azure services: Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Azure SQL and SQL Server.

Microsoft Fabric Expertise

OneLake: 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: workspaces, domains, capacities (F SKUs), capacity monitoring and cost management.
Security and governance: workspace and item permissions, OneLake data access, row‑ and object‑level security, and Microsoft Purview integration.
ALM: Fabric Git integration, deployment pipelines, and environment promotion across dev, test and production.
Migration: moving Azure Synapse, Azure Data Factory, SSAS/Azure Analysis Services and Power BI Premium workloads into Fabric.
Real‑Time Intelligence (preferred): Eventstreams and KQL databases for streaming and operational analytics

Required

Eight or more years of professional data and analytics experience, including at least three years in an architect role.
Architect on at least two production Microsoft Fabric implementations.
At least one full‑lifecycle greenfield architecture engagement.
Bachelor’s degree in computer science, Data Science, Information Systems or a related field, or equivalent professional experience.
Leads requirements elicitation, design and brainstorming sessions with internal and client teams, in both structured and ad‑hoc settings, and ensures all key contributors are heard.
Clear, professional written and verbal communication with technical and business audiences at all levels.
Business acumen to align solution design with client needs.
Ability to participate in ad‑hoc meetings, on short notice with groups of all sizes.

Preferred

Microsoft certifications: Fabric Data Engineer Associate (DP‑700); or Fabric Analytics Engineer Associate (DP‑600) or Azure Solutions Architect Expert (AZ‑305) as an alternative.
Exposure to Databricks, Snowflake or other cloud data platforms.
Pre‑sales and estimating experience in a consulting environment.
AI/ML in analytics workflows (Azure Machine Learning, Python or R), Copilot in Fabric, and Fabric data agents.

Travel and Other Requirements

This is a remote role, with required travel 4-6 times per year with no more than 24 days away from home per calendar year.

Candidates must reside, at the time of application in one of the ten approved state locations to be considered for this position. Those locations are Wisconsin, Illinois, Ohio, Indiana, Michigan, Iowa, South Dakota, North Carolina, Arizona and Arkansas. Candidates residing outside of these locations will not be considered.