Microsoft BI (Fabric) Engineer

Avantiico is a Microsoft solutions partner specializing in Microsoft Dynamics 365, Microsoft Fabric, Power Platform, and AI-driven business applications. Our Reporting Practice helps clients across manufacturing, distribution, financial services, and other industries unlock the value of their D365 and operational data through modern analytics and AI. 

Job Summary 

We are hiring a Microsoft BI (Fabric) Engineer to join our Report Practice. In this role, you will design and build modern analytics solutions on Microsoft Fabric and Power BI for our clients, covering Lakehouses, Warehouses, semantic models, pipelines, notebooks, and AI-enabled experiences. This is a client-facing consulting role: you will run workshops, lead requirements gathering, and present to senior stakeholders. We are looking for someone who already works in an AI-forward way, using modern AI tools to deliver faster rather than just talking about them.

Duties / Responsibilities 

• Design and build Microsoft Fabric and Azure Synapse solutions (Lakehouses, Warehouses, Pipelines, Notebooks, and semantic models) using a medallion architecture. 
• Develop Power BI semantic models and reports with strong DAX, performance tuning, and row-level security (RLS). 
• Integrate Microsoft Dynamics 365 Finance & Supply Chain Management and Dataverse data into Fabric- or Synapse-based analytics environments. 
• Author SQL, Python, and PySpark code for notebook development and data transformation. 
• Build and maintain pipelines using Azure Data Factory and Synapse / Fabric Pipelines. 
• Manage source control, branching, and deployment using Git and Azure DevOps. 
• Run client-facing workshops, design sessions, and status calls; translate business requirements into solutions and present to senior stakeholders. 
• Build AI-enabled experiences on top of client data and use modern AI tools to speed up your own delivery. 
• Write clean documentation and conduct knowledge transfers for clients and team members. 
• Additionally, this role will assist in pre-sales/marketing activities including but not limited to producing written content, short videos, webinars, discovery calls, and in-person presentations. 
• Stay current with Microsoft updates, new features, and best practices. 

Required Skills / Abilities 

• 4+ years hands-on with Microsoft Fabric and/or Azure Synapse (Lakehouses, Warehouses, Pipelines, Notebooks, semantic models), including at least one solution you took to production and can speak about in detail. 
• Strong Power BI: DAX, semantic modeling, performance tuning, and row-level security (RLS). 
• Advanced SQL and Python / PySpark for notebook development. 
• Medallion architecture experience (Bronze / Silver / Gold). 
• Microsoft Dynamics 365 F&SCM or Dataverse integration experience, or willingness to ramp up quickly. 
• Azure Data Factory / Synapse Pipelines. 
• Git / Azure DevOps for source control and deployment. 
• Client-facing consulting experience. 
• Strong written and verbal communication; comfortable presenting to senior stakeholders. 

Preferred Qualifications 

• You’ve built something real with AI and can show it. A working agent, a copilot-style assistant, or an automation that saved you or a client in real time. We care about what you shipped and the thinking behind it more than which tool you used. 
• Microsoft AI stack experience is a plus. If you built it with something else, bring it and be ready to walk us through how and why. 
• Able to discuss experience with a Microsoft Fabric solution all the way to production, the kind where you handled source control and releases, kept performance and cost in check, and handled real Microsoft Dynamics 365 data. 
• Current certification a plus, or the ability to obtain after joining within 90 days of employment: DP-600, DP-700. Other preferred certifications include but not limited to: PL-300, AB‑900, AZ-104, AZ-305. 
• Domain experience in manufacturing, energy, financial services, or retail.

Physical Requirements:

• Must have the ability to work from a home office and follow work-from-home best practices.
• Travel requirements up to 25% for clients, and company on-site work, retreats or workshops.

Equal Employment & Opportunity Statement

Avantiico is committed to hiring and retaining a diverse workforce. We are an Equal Opportunity Employer, making decisions without regard to race, color, religion, sex, national origin, age, veteran status, disability, or any other protected class.

Compensation and Company Benefits:

• Competitive salary + allowance + monthly performance related bonus depending on the role
• Salary commensurate with experience
• Low travel expectation/work life balance
• 99% of employee healthcare paid for by the company
• Choices of premium HMO/PPO plans
• Matching 401k plan
• Paid Vacation/Sick/Holidays