Title: Solution Architect Microsoft Fabric & Power BI Semantic Models
Location: 1221 Avenue of the Americas New York NY USA 10020
Duration: 06+ Months
Position Summary
We are seeking a visionary Solution Architect to lead the design and evolution of our modern data estate. This role is pivotal in transforming raw data into actionable intelligence by leveraging the full Microsoft Fabric and Databricks ecosystem. You will be responsible for architecting scalable, secure, and high-performance solutions that bridge the gap between complex data engineering and intuitive business analytics.
Key Responsibilities
1. Enterprise Architecture & Strategy
Unified Data Backbone: Design and manage enterprise-grade architectures within OneLake, DeltaLake serving as the single system of record.
Medallion Framework: Implement robust Bronze/Silver/Gold data layers using Lakehouses and Warehouses to ensure data quality and lineage.
Ingestion Patterns: Define strategic patterns for data acquisition, deciding between Mirroring for real-time synchronization, Shortcuts for zero-copy integration, or traditional pipelines.
2. Advanced Semantic Modeling Performance Engineering: Architect sophisticated Power BI Semantic Models using Direct Lake mode for near-instant performance on large datasets.
Logic & Standardization: Develop complex DAX measures and Calculation Groups to standardize business logic (e.g., time intelligence, currency conversion) across the organization.
Optimization: Utilize tools like Tabular Editor, DAX Studio, and VertiPaq Analyzer to tune model performance and enforce enterprise standards.
3. Governance, Security & Compliance Access Control: Implement granular security frameworks, including Row-Level Security (RLS) and Object-Level Security (OLS), aligned with federal and industry standards.
Data Lifecycle: Automated data discovery, sensitivity labeling, and auditing.
Workspace Governance: Establish best practices for workspace management, deployment pipelines, and capacity monitoring to optimize costs.
4. Leadership & Innovation Technical Mentorship: Act as the Subject Matter Expert (SME), providing architectural guidance and code reviews for engineering and analytics teams.
AI Readiness: Prepare the data foundation for Fabric Copilot and AI-driven insights, ensuring data is "AI-ready" through high-quality semantic depth.
Stakeholder Alignment: Translate complex technical roadmaps into business value for executive leadership.
________________________________________
Required Qualifications Experience: 7+ years in Data Architecture, with a proven track record of delivering large-scale enterprise solutions.
Fabric Expertise: Deep hands-on experience with Microsoft Fabric components (Lakehouse, Data Warehouse, Real-Time Analytics).
Technical Mastery: Expert-level proficiency in SQL, DAX, and Power Query (M).
Modeling: Mastery of Kimball dimensional modeling and star schema design.
Preferred Qualifications Advanced Analytics: Experience with Python, Spark (PySpark), and Notebooks for complex data transformations.
Global Scale: Experience architecting Multi-geo data solutions and handling multi-TB datasets.
DevOps: Familiarity with CI/CD practices using Azure DevOps, Git, and ALM Toolkit.
Soft Skills
Never miss an opportunity! Create an alert based on the job you applied for.
