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 www.Avantiico.com. 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.

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

Compensation for roles at Avantiico varies depending on a wide array of factors including but not limited to the specific office location, role, skill set, and level of experience. As required by local law, Avantiico provides a reasonable estimate of the current salary range for this position as set forth below. Pay Range$110,000—$140,000 USD