Note: The job is a remote job and is open to candidates in USA. Method360 is a company focused on the health science industry, seeking a high-level Solution Architect specializing in Power BI and Microsoft Fabric. This role involves leading the strategic design and optimization of the enterprise data platform, with a focus on data connectivity modes and performance optimization.
Responsibilities
• Strategic Advisory: Guide leadership teams through the pros, cons, and cost-benefit analyses of Power BI Premium vs. Microsoft Fabric. Provide clear roadmaps for architectural choices, specifically managing the trade-offs between data freshness (DirectQuery) and query performance
• Performance Optimization: Diagnose and resolve complex performance bottlenecks. You must be an expert at optimizing DirectQuery performance through query folding, storage engine tuning, and backend data source optimization (SQL, Delta Tables)
• Architecture Design: Design scalable, end-to-end data architectures using the Medallion Architecture. Determine the optimal connectivity strategy for various use cases, ensuring "heavy-user" deep dives don't overwhelm capacity
• Connectivity Strategy: Lead the transition from traditional DirectQuery/Import models toward Direct Lake on OneLake, maximizing the performance of Fabric for large-scale datasets
• Governance & Security: Establish best practices for workspace management, capacity planning, and Row-Level Security (RLS) across different connectivity modes
Skills
• Expert-level knowledge of Microsoft Fabric (OneLake, Lakehouse, Warehouse) and Power BI (Composite models, Aggregations, XMLA endpoints)
• Deep, hands-on experience with DirectQuery, including optimization of the underlying data source and managing the performance impacts of complex DAX over DirectQuery
• Proficiency in DAX Studio, Tabular Editor, and SQL Profiler to tune data models and monitor the performance of DirectQuery connections
• Advanced experience in Dimensional Modeling (Star Schema) and designing 'Gold' layer tables specifically optimized for Direct Lake and DirectQuery efficiency
• Exceptional ability to explain technical trade-offs (e.g., latency vs. speed) to C-suite stakeholders and guide them on 'Total Cost of Ownership' for different architectural paths
Company Overview
• Method360 is an information technology company that offers data management and analytics solutions. It was founded in 2000, and is headquartered in San Francisco, California, USA, with a workforce of 51-200 employees. Its website is http://method360.com.
Company H1B Sponsorship
• Method360 has a track record of offering H1B sponsorships, with 7 in 2023, 3 in 2020. Please note that this does not guarantee sponsorship for this specific role.