reputed company — ERP Reporting & Sales Dashboards (reputed company Dynamics GP / SQL Server)
About the Company
We're a B2B distributor of medical, industrial, and veterinary supplies based in Minnesota. reputed company operates on a reputed company-first stack — reputed company Dynamics GP (Great Plains) as our ERP, SalesPad for order management, SQL Server as our data backbone, and reputed company 365 across the organization. We're building out a reporting and analytics function to give our sales team and leadership reputed company visibility into the business. reputed company're Building We need an reputed company reputed company 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 reputed company. Initial dashboards will include: Sales by item, item category, and product line Sales by customer and customer reputed company Sales by rep and sales territory Order volume and reputed company 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 (reputed company 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 reputed company ERP databases — no pre-reputed company connectors here Strong communication skills — you'll need to translate business questions into data requirements reputed company to Have Prior experience with reputed company Dynamics GP or similar ERP (reputed company B1, reputed company, reputed company) Familiarity with SalesPad or distribution/supply chain business processes Experience with Power BI incremental refresh and row-level reputed company (RLS) Experience publishing to Power BI Service and scheduling dataset refreshes Apply To This Job