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 Bi…
Skills: Microsoft Fabric, Azure Synapse, Power BI, DAX, SQL
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
$110k–$140k/yr
Full-time
professional certificate
Competitive Salary, Allowance, Monthly Performance Related Bonus, Healthcare Paid 99% By Company, Premium HMO/PPO Plans, Matching 401k Plan
Posted 8d ago
~40 hrs/week
Remote in San Diego, California, United States
Responsibilities
Design and build modern analytics solutions using Microsoft Fabric and Power BI, implementing medallion architectures and AI-enabled experiences. Lead client-facing workshops to gather requirements and translate business needs into technical solutions for senior stakeholders.
Requirements
Requires 4+ years of experience with Microsoft Fabric or Azure Synapse and strong proficiency in DAX, SQL, and Python. Candidates must have a proven track record of delivering production-ready analytics solutions and experience in client-facing consulting.
Full job description
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.
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.
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
Related keywords
Microsoft FabricAzure SynapsePower BIDAXSQLPythonPySparkMedallion ArchitectureMicrosoft Dynamics 365DataverseAzure Data FactoryGitAzure DevOpsDP-600DP-700PL-300
Microsoft Solution Partner. Dynamics 365, ERP, CRM, Azure, Modern Work, AI, Copilot, 3PL, Freight & Finance Automation
Industry
IT Services and IT Consulting
Company size
51-200 employees
Founded
2006
Headquarters
San Diego, California
LinkedIn followers
11,749
Avantiico is a Microsoft Solutions Partner and Independent Software Vendor (ISV) specializing in Dynamics 365 Finance & Supply Chain Management, Copilot, AI, Finance Automation, Freight Invoice Automation and 3PL Automation. With over 70,000 hours of 3PL experience and 400,000 hours of ERP consulting, we offer both Microsoft solutions and custom D365-native add-ons for global clients in 20+ countries. Avantiico-built IPs include the 3PL Automation Cloud, Advanced Multi-Company Solution (AMCS), AMCS Lite, and the Data Migration Accelerator (DMA), all available on Microsoft AppSource. Visit avantiico.com to explore our Microsoft ISV solutions, consulting services, and comprehensive managed support for Dynamics 365 users.
Selection
Get the help your need team needs and access to selection content and requirements discovery sessions with subject matter experts. Our teams help you build the necessary knowledge to make highly educated decisions on solutions that meet the needs of your business.
Client readiness
Get ready for moving from current solution(s) to the Microsoft Cloud with 360 degree training, advisory services and project tools.
Implementation
The Avantiico implementation team includes some of the most experienced minds in the industry. Our team helps you optimize current processes, fit these processes to the Microsoft tools, and customize them to meet unique needs.
Support & Managed Services:
Full circle support offerings for live customers.
Careers
Avantiico is certified as a Great Place to Work, with 100% positive employee feedback. Have a look at our openings!
Certified Solution Partner for Business Applications, Support, Modern Work and more.
Offices: 600 B St, Suite 300, San Diego, California 92101, US · Suite 200, 41593 Winchester Road, Temecula, CA 92590, US · 60 Windsor Avenue, Dalton House, London, England SW19 2RR, GB · Orestads Boulevard 73, 2300 Copenhagen S, DK · 200 Spectrum Center Dr, Irvine, California 92618, US
Dynamics 365 SupportMicrosoft Dynamics SupportAzurePowerBIPowerappsData Warehouse ManagementEnterprise ERP SolutionsMicrosoft LicensingMicrosoft Dynamics 365 for Customer ServiceMicrosoft Dynamics 365 for Sales
Microsoft Solution Partner. Dynamics 365, ERP, CRM, Azure, Modern Work, AI, Copilot, 3PL, Freight & Finance Automation
Industry
IT Services and IT Consulting
Company size
51-200 employees
Founded
2006
Headquarters
San Diego, California
LinkedIn followers
11,749
Avantiico is a Microsoft Solutions Partner and Independent Software Vendor (ISV) specializing in Dynamics 365 Finance & Supply Chain Management, Copilot, AI, Finance Automation, Freight Invoice Automation and 3PL Automation. With over 70,000 hours of 3PL experience and 400,000 hours of ERP consulting, we offer both Microsoft solutions and custom D365-native add-ons for global clients in 20+ countries. Avantiico-built IPs include the 3PL Automation Cloud, Advanced Multi-Company Solution (AMCS), AMCS Lite, and the Data Migration Accelerator (DMA), all available on Microsoft AppSource. Visit avantiico.com to explore our Microsoft ISV solutions, consulting services, and comprehensive managed support for Dynamics 365 users.
Selection
Get the help your need team needs and access to selection content and requirements discovery sessions with subject matter experts. Our teams help you build the necessary knowledge to make highly educated decisions on solutions that meet the needs of your business.
Client readiness
Get ready for moving from current solution(s) to the Microsoft Cloud with 360 degree training, advisory services and project tools.
Implementation
The Avantiico implementation team includes some of the most experienced minds in the industry. Our team helps you optimize current processes, fit these processes to the Microsoft tools, and customize them to meet unique needs.
Support & Managed Services:
Full circle support offerings for live customers.
Careers
Avantiico is certified as a Great Place to Work, with 100% positive employee feedback. Have a look at our openings!
Certified Solution Partner for Business Applications, Support, Modern Work and more.
Offices: 600 B St, Suite 300, San Diego, California 92101, US · Suite 200, 41593 Winchester Road, Temecula, CA 92590, US · 60 Windsor Avenue, Dalton House, London, England SW19 2RR, GB · Orestads Boulevard 73, 2300 Copenhagen S, DK · 200 Spectrum Center Dr, Irvine, California 92618, US
Dynamics 365 SupportMicrosoft Dynamics SupportAzurePowerBIPowerappsData Warehouse ManagementEnterprise ERP SolutionsMicrosoft LicensingMicrosoft Dynamics 365 for Customer ServiceMicrosoft Dynamics 365 for Sales