Microsoft BI; Fabric) Engineer

Introduction to Avantiico :

Avantiico is a business automation company and Microsoft Partner delivering integrated Microsoft Cloud solutions for Sales, Finance, Supply Chain and Customer Service. With purpose-built 3PL Billing Automation and 3PL WMS solutions for Microsoft Dynamics 365 Finance and Supply Chain, Avantiico serves the needs of next generation enterprise fulfillment and supply chain organizations. Avantiico’s Multicompany Automation solution supports all industries, including Shared Services functions, centralized franchise account, and multi-company businesses.

It is aimed at empowering enterprise businesses to improve accounting productivity, increase accuracy and financial closing velocity.

The services offered by Avantiico range from enabling SMB and Enterprise Businesses in their software selection process, readiness, implementing Microsoft Solutions, providing 'Live Services' to clients, and driving user adoption in our client’s teams. Avantiico serves clients across time-zones, industries and business models including public traded, public sector and privately held businesses. All Avantiico solutions are natively built on the Microsoft Cloud architecture and made for Microsoft Dynamics 365.

Learn more about Avantiico, Careers or Solutions at  Avantiico is a Great Place to Work.

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.

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 Lake houses, 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.

• Design and build Microsoft Fabric and Azure Synapse solutions (Lake houses, 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 Dev Ops.
• 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.

• 4+ years hands-on with Microsoft Fabric and/or Azure Synapse (Lake houses, Warehouses, Pipelines, Notebooks, semantic models), including at least one solution you took to production and can…