Microsoft Fabric Solutions Architect

Job Description We currently have a career opportunity for a Senior Solutions Architect – Microsoft Fabric to join our team. Job Overview: A Senior Solutions Architect (SSA) at Perficient blends broad solution‑architecture leadership with deep technology expertise. In this role, you will be our go‑to expert for Microsoft Fabric and the Microsoft Intelligent Data Platform , guiding enterprise clients through greenfield deployments, modern data‑platform transformations, and ongoing enterprise data‑warehouse (EDW) operations. You will: Provide best‑fit architectural solutions, size and scope work, and anchor proofs of concept. Own Fabric evangelism and presales conversations, partnering with account teams to shape new opportunities. Lead delivery teams to implement Fabric Lakehouse, Data Warehouse, Real‑Time Analytics, and Power BI solutions that balance self‑service flexibility with strong governance. Act as the “swiss‑army knife” who can keep critical EDW workloads running while modernizing data estates. As part of Perficient’s senior leadership community, you will mentor architects and consultants, influence practice direction, and represent Perficient in the growing Microsoft Fabric ecosystem. Perficient is always looking for the best and brightest talent and we need you! We’re a quickly-growing, global digital consulting leader, and we’re transforming the world’s largest enterprises and biggest brands. You’ll work with the latest technologies, expand your skills, and become a part of our global community of talented, diverse, and knowledgeable colleagues. Responsibilities Own and drive the end‑to‑end architecture for Microsoft Fabric implementations and EDW modernizations. Provide architectural assessments, roadmaps, and governance frameworks (Fabric workspaces, OneLake organization, capacity planning, Purview lineage, sensitivity labeling). Lead discovery workshops to capture business and technical requirements for data ingestion, modeling, analytics, and visualization. Design and develop: Fabric Lakehouse architectures (Delta tables, Medallion patterns, Data Mesh). Fabric Pipelines / Data Factory ETL & ELT processes—including migration of ADF/Synapse pipelines. Fabric Warehouses (T‑SQL, performance tuning, high‑concurrency configuration). Real‑Time Analytics solutions (KQL databases, Data Activator alerting, streaming datasets). Power BI semantic models using DirectLake, Import, Composite, and CI/CD deployment pipelines. Produce high‑quality architecture diagrams, backlog work packages, and effort estimates. Guide multiple Agile Scrum teams from sprint planning through continuous delivery. Liaise with offshore teams to resolve dependencies, issues, and risks. Mentor colleagues on Fabric best practices and contribute to Perficient’s Fabric community of practice. Support sales pursuits with demos, POVs, and statements of work. Engage onsite at the client’s St. Louis office as needed to ensure smooth EDW operations and stakeholder alignment. Qualifications 10–15 years of professional experience, including 5 + years delivering enterprise data‑platform solutions on Azure. Expertise in Microsoft Fabric across all experiences (Data Engineering, Data Factory, Data Warehouse, Data Science, Real‑Time Analytics, Power BI). Proven ability to maintain and modernize enterprise data warehouses (EDW) while implementing Fabric‑based architectures. Hands‑on front‑end (Power BI dashboards, semantic modeling) and back‑end (Lakehouse, pipelines, warehouses) solution delivery. Minimum five (5) full‑lifecycle Fabric, Synapse, or Databricks projects, covering discover → design → implement → optimize phases. Leadership history in professional‑services/consulting environments, including project estimation, team structure definition, and client workshop facilitation. Required certification: DP‑600 Fabric Analytics Engineer Associate Preferred certifications: AZ‑305 Azure Solutions Architect Expert DP‑700 Fabric Data Engineer Associate PL‑300 Power BI Data Analyst Associate Proficiency with Azure DevOps or Git‑based CI/CD pipelines for Fabric assets and workspace lifecycle automation. Strong grasp of Microsoft Cloud Adoption Framework principles, data‑governance concepts, and Purview integration. Excellent verbal and written communication skills with both technical and non‑technical audiences. Experience leading globally distributed teams; willingness to mentor junior staff. Location: St. Louis, MO strongly preferred; qualified US‑based remote candidates considered. Bachelor’s degree in Computer Science or related field (Master’s preferred). Must be willing to travel as client and project needs dictate. Who We Are Perficient is the global AI-first consultancy. Our team of strategists, designers, technologists, and engineers partners with the world’s most innovative enterprises and admired brands to deliver real business results through the transformative power of AI. As part of our AI-First strategy, we empower every employee to build AI fluency and actively engage with AI tools to drive innovation and efficiency. We break boundaries, obsess over outcomes, and shape the future for our clients. Join a company where bold ideas and brilliant minds converge to redefine what’s possible - while building a career filled with growth, balance, and purpose. The salary range for this position takes into consideration a variety of factors, including but not limited to skill sets, level of experience, applicable office location, training, licensure and certifications, and other business and organizational needs. The new hire salary range displays the minimum and maximum salary targets for this position across all US locations, and the range has not been adjusted for any specific state differentials. It is not typical for a candidate to be hired at or near the top of the range for their role, and compensation decisions are dependent on the unique facts and circumstances regarding each candidate. A reasonable estimate of the current salary range for this position is $150,000-185,000. Please note that the salary range posted reflects the base salary only and does not include benefits or any potential equity or variable bonus programs. Information regarding the benefits available for this position are in our benefits overview . What We Believe At Perficient, we promise to challenge, champion, and celebrate our people. You will experience a unique and collaborative culture that values every voice. Join our team, and you’ll become part of something truly special. We believe in developing a workforce that is as diverse and inclusive as the clients we work with. We’re committed to actively listening, learning, and acting to further advance our organization, our communities, and our future leaders… and we’re not done yet. Perficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws. Perficient, Inc. complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Perficient, Inc. expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, national origin, age, genetic information, disability, or covered veterans. Improper interference with the ability of Perficient, Inc. employees to perform their expected job duties is absolutely not tolerated. Disability Accommodations: Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, please contact us. Disclaimer: The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification. Management retains the discretion to add or change the duties of the position at any time. About Us Perficient is the global AI-first consultancy. Our team of strategists, designers, technologists, and engineers partners with the world’s most innovative enterprises and admired brands to deliver real business results through the transformative power of AI. As part of our AI-First strategy, we empower every employee to build AI fluency and actively engage with AI tools to drive innovation and efficiency. We break boundaries, obsess over outcomes, and shape the future for our clients. Join a company where bold ideas and brilliant minds converge to redefine what’s possible - while building a career filled with growth, balance, and purpose. Select work authorization questions to ask when applicants apply 1. Are you legally authorized to work in the United States? 2. Will you now, or in the future, require sponsorship for employment visa status (e.g. H-1B visa status)?