Power BI Developer — ERP Reporting & Sales Dashboards (Microsoft Dynamics GP / SQL Server)
About the Company
We're a B2B distributor of medical, industrial, and veterinary supplies based in Minnesota. Our team operates on a Microsoft-first stack — Microsoft Dynamics GP (Great Plains) as our ERP, SalesPad for order management, SQL Server as our data backbone, and Microsoft 365 across the organization. We're building out a reporting and analytics function to give our sales team and leadership better visibility into the business. What We're Building We need an experienced Power BI developer to work alongside our internal data specialist and sales team to design, build, and deliver a suite of operational dashboards. This is a hands-on development role — you'll be writing DAX, building data models, and working directly with SQL Server as your data source. Initial dashboards will include: Sales by item, item category, and product line Sales by customer and customer segment Sales by rep and sales territory Order volume and revenue trends over time Year-over-year and period-over-period comparisons Item cross reference self-service tools Your Responsibilities Connect Power BI Desktop to SQL Server (via ODBC/DirectQuery or import mode) and build clean, performant data models Write T-SQL queries and views against Dynamics GP tables (SOP, RM, IV modules) and SalesPad tables as the reporting layer Collaborate with our internal data specialist on schema, table relationships, and data definitions Work with our sales team to understand reporting requirements and translate them into dashboard designs Build and publish reports to Power BI Service for sharing across the organization Document your data models, measures, and report logic so work is maintainable internally Required Skills & Experience 3+ years of Power BI development experience (Desktop + Service) Strong T-SQL — you'll be writing queries against GP's table structure (SOP30200, RM00101, IV00101, etc.), not just connecting to a clean data warehouse Experience building star-schema or similar data models in Power BI Proficient in DAX for calculated measures, time intelligence, and KPIs Comfortable working directly with source ERP databases — no pre-built connectors here Strong communication skills — you'll need to translate business questions into data requirements
Nice to Have
Prior experience with Microsoft Dynamics GP or similar ERP (SAP B1, Sage, Acumatica) Familiarity with SalesPad or distribution/supply chain business processes Experience with Power BI incremental refresh and row-level security (RLS) Experience publishing to Power BI Service and scheduling dataset refreshes