S

SysLogic

Data and Analytics Architect - MS Fabric

Data EngineeringConfirmed live in the last 24 hours
Full-timeRemote in USANo salary listed

About the Job

Requirements

  • Data modeling (dimensional and normalized), 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 analytics.
  • Source control and continuous integration/continuous delivery with Azure DevOps or GitHub, and delivery within Agile/Scrum methodologies.
  • Experience with Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Azure SQL, and SQL Server.
  • OneLake: Lakehouse, Warehouse, and Eventhouse selection; shortcuts and mirroring; and Delta/Parquet storage design.
  • Data engineering using Data Factory pipelines, Dataflows Gen2, and Spark notebooks, including knowing when to use each.
  • Semantic layer expertise, including Direct Lake semantic models, composite models, DAX optimization, and enterprise Power BI design.
  • Workspace and tenant design, including workspaces, domains, capacities (F SKUs), capacity monitoring, and cost management.
  • Security and governance expertise, including workspace and item permissions, OneLake data access, row- and object-level security, and Microsoft Purview integration.
  • Application lifecycle management using Fabric Git integration, deployment pipelines, and environment promotion across development, test, and production.
  • Migration of Azure Synapse, Azure Data Factory, SSAS/Azure Analysis Services, and Power BI Premium workloads into Fabric.
  • Eight or more years of professional data and analytics experience, including at least three years in an architect role.
  • Architected 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.
  • Lead requirements elicitation, design, and brainstorming sessions with internal and client teams in structured and ad hoc settings, ensuring all key contributors are heard.
  • Communicate clearly and professionally in writing and verbally with technical and business audiences at all levels.
  • Apply business acumen to align solution design with client needs.
  • Participate in ad hoc meetings on short notice with groups of all sizes.
  • Reside in Wisconsin, Illinois, Ohio, Indiana, Michigan, Iowa, South Dakota, North Carolina, Arizona, or Arkansas at the time of application.

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 appropriate architecture patterns and communicate 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, including ERP, CRM, SaaS, APIs, files, and streaming, with 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 optimize Fabric capacity and consumption costs, and identify and resolve performance bottlenecks.
  • Define data governance, data quality, lineage, and metadata practices, and partner with the 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.
  • Collaborate across organizational 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 presenting architecture options to clients.
  • Travel 4–6 times per year, with no more than 24 days away from home per calendar year.

Desired Qualifications

  • Experience with Real-Time Intelligence, including Eventstreams and KQL databases for streaming and operational analytics.
  • Microsoft Fabric Data Engineer Associate (DP-700), Fabric Analytics Engineer Associate (DP-600), or Azure Solutions Architect Expert (AZ-305) certification.
  • Exposure to Databricks, Snowflake, or other cloud data platforms.
  • Pre-sales and estimating experience in a consulting environment.
  • Experience with AI/ML in analytics workflows, including Azure Machine Learning, Python or R, Copilot in Fabric, and Fabric data agents.

About the Company

Company size
Not listed
Company stage
Not listed
Total funding
Not listed
Headquarters
Not listed
Founded
Not listed

Recently Posted Jobs

Explore more opportunities at SysLogic

See more jobs