Fabric Solution Architect

iLink Digital Inc

Saint Louis, MO

JOB DETAILS
SKILLS
Access Control, Application Programming Interface (API), Artificial Intelligence (AI), Best Practices, Business Intelligence, Capacity Management, Cataloguing, Cloud Computing, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Cost Control, Customer Relationship Management (CRM), Data Analysis, Data Management, Data Modeling, Data Processing, Data Science, Data Storage, Data Warehousing, Database Extract Transform and Load (ETL), DevOps, Dimensional Modeling, ERP (Enterprise Resource Planning), Ecosystems, Enterprise Architecture, Identify Issues, Information/Data Security (InfoSec), Leadership, Maintain Compliance, Mentoring, Microsoft Certifications, Microsoft Product Family, Microsoft Windows Azure, Performance Tuning/Optimization, Power BI, SQL (Structured Query Language), Software Engineering, Star Schema, Streaming Technology, Technical Leadership, Training Data Sets
LOCATION
Saint Louis, MO
POSTED
7 days ago

Job Title: Fabric Solution Architect Role Summary A Fabric Solution Architect designs, implements, and governs end-to-end data and analytics solutions using Microsoft Fabric. This role bridges business requirements with technical architecture, ensuring scalable, secure, and high-performing data platforms leveraging Fabric components such as Lakehouse, Data Warehouse, Data Engineering, Data Science, Real-Time Intelligence, and Power BI. Key Responsibilities ? Solution Architecture & Design Define end-to-end data architecture using Microsoft Fabric Design Lakehouse architectures (Delta Lake, Medallion layers: Bronze, Silver, Gold) Architect data integration, ingestion, transformation, and serving layers Define architecture patterns for batch, streaming, and real-time data processing ? Platform Implementation Lead implementation of: Fabric Workspaces & governance model Data Pipelines & Dataflows Gen2 Notebooks (Spark-based engineering workloads) Data Warehouse & Lakehouse solutions Configure and optimize OneLake data management ? Data Modeling & Analytics Design enterprise-grade semantic models (Power BI datasets) Establish best practices for data modeling (star schema, dimensional modeling) Enable self-service BI and governed analytics ? Integration & Ecosystem Integrate Fabric with: Azure services (ADLS, Synapse, Azure SQL, Event Hub, etc.) External data sources (ERP, CRM, APIs) Design hybrid/multi-cloud data integration where required ? Security & Governance Implement data governance, lineage, and cataloging Define role-based access control (RBAC) and data security strategies Ensure compliance with enterprise data policies ? Performance Optimization Optimize workloads for: Query performance Cost efficiency (capacity planning) Data storage strategies Monitor and troubleshoot Fabric environments ? Leadership & Collaboration Work closely with: Business stakeholders Data engineers, analysts, and scientists IT and cloud teams Provide technical leadership and mentorship Drive design reviews and architecture governance Required Skills & Experience Core Technical Skills Strong experience with Microsoft Fabric / Synapse / Azure Data Platform Expertise in: Data Lakehouse architecture Spark / PySpark SQL & Data Warehousing (MPP systems) Experience with: Data Pipelines / ETL/ELT frameworks Power BI (advanced modeling, DAX) Cloud & Data Expertise Hands-on experience in Azure ecosystem Knowledge of: Data ingestion tools (ADF, Fabric pipelines) Streaming technologies (Kafka/Event Hub) Delta Lake & parquet formats Architecture Skills Enterprise data architecture design Data governance frameworks (Purview preferred) Scalable and cost-optimized solution design Soft Skills Strong stakeholder communication Solution-oriented thinking Leadership and mentoring capability Preferred Qualifications Microsoft Certifications (highly desirable): DP-600: Fabric Analytics Engineer DP-203: Data Engineering on Azure PL-300: Power BI Data Analyst Experience with AI/ML integration within Fabric Familiarity with DevOps (CI/CD for data platforms)

About the Company

i

iLink Digital Inc