Avantiico

Avantiico

Microsoft BI (Fabric) Engineer

San Diego, Remote

Sponsorship not specified$110k-$140kDetected 29 days ago
PythonGitSQLAzureDevOpsData VisualizationAccountingSupply ChainCommunicationPublic Speaking

About the role

  • We are hiring a Microsoft BI (Fabric) Engineer to join our Report Practice.
  • 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.

Responsibilities

  • 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.
  • 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).
  • Build and maintain pipelines using Azure Data Factory and Synapse / Fabric Pipelines.
  • Run client-facing workshops, design sessions, and status calls; translate business requirements into solutions and present to senior stakeholders.

Requirements

  • 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.
  • Required Skills / Abilities

Nice to have

  • 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.
  • 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.

Skills

  • It is aimed at empowering enterprise businesses to improve accounting productivity, increase accuracy and financial closing velocity.
  • 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©.
  • Advanced SQL and Python / PySpark for notebook development.

Compensation

  • $110,000 - $140,000 USD
  • Competitive salary + allowance + monthly performance related bonus depending on the role
  • Salary commensurate with experience
  • Low travel expectation/work life balance
  • Choices of premium HMO/PPO plans
  • Matching 401k plan

Benefits

  • Must have the ability to work from a home office and follow work-from-home best practices.
  • Competitive salary + allowance + monthly performance related bonus depending on the role
  • 99% of employee healthcare paid for by the company
  • Paid Vacation/Sick/Holidays

Company info

  • Travel requirements up to 25% for clients, and company on-site work, retreats or workshops.
  • 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

This listing is sourced directly from Avantiico's careers page and normalized into a canonical job model.