BI Developer - US

Munchsupply; United States; Remote; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401(k) plan with company contributions

Life insurance

HSA/FSA options

Paid time off

Weekly pay

Job summary

mSupply seeks a BI Developer to design, build, and maintain Power BI solutions that translate enterprise data into actionable insights. You will work with the Gold data layer, develop semantic models and dashboards, and enable self-service analytics across HVAC, plumbing, and appliances units.

The role emphasizes strong SQL, DAX, data modeling, and collaboration with stakeholders to define KPIs, ensure governance, and deliver scalable BI solutions in a remote-friendly setting.

Qualifications

• 3+ years in BI development with Power BI, including semantic modeling and DAX.
• Strong SQL proficiency across relational and lakehouse data.
• Experience building star schemas and row-level security.
• Ability to translate requirements into clear visual narratives.
• Excellent communication with business stakeholders.

Responsibilities

• Design, develop, and maintain Power BI reports and dashboards.
• Build semantic models, datasets, and DAX measures.
• Connect Power BI to the data platform using Direct Lake and endpoints.
• Collaborate with product owners to define KPIs and visuals.
• Optimize performance with aggregations, refresh, and efficient patterns.
• Govern Power BI workspaces, pipelines, and access control.
• Create reusable datasets and document analytics workflows.

Skills

Power BI

SQL

DAX

Data Modeling

Education

Bachelor’s degree in Computer Science, Information Systems, Business Analytics, or related field

Tools

Microsoft Fabric

Direct Lake connectivity

SQL Analytics Endpoints

OneLake

dbt

Job description

Do you love working with talented people? So do we!

Our team is growing and we’re looking for best-in-class talent. We value experienced, career-minded employees who focus on teamwork, professionalism and an unparalleled commitment to customer service. We offer full-time employees a competitive benefits package that includes health, dental and vision insurance, along with life and AD&D insurance, 401k plans, vacation time and more.

Browse positions available at mSupply and throughout our HVAC, plumbing and appliance parts business units nationwide. Use the filters to narrow by department, business unit or location.

Location: REMOTE

Remote Status: Remote

Job Id:4056-mSupply

# of Openings:1

About mSupply™

mSupply is a North American distributor of OEM repair parts and equipment serving the appliance, HVAC and plumbing industries. Headquartered in St. Louis, the company combines industry expertise with a broad product selection and a national distribution network.

With 2,000 employees across the United States and Canada, mSupply delivers speed and reliability at scale, with a vast product inventory and same-day shipping. Its family of brands is focused on making sure customers always get the Right Products. Right Now.™ For more information, visit mSupply.com.

Job Summary

The BI Developer designs, builds, and maintains the business intelligence solutions that translate mSupply’s enterprise data into actionable insights. Working primarily in Power BI and connected to the Gold layer of the enterprise data platform, this role develops semantic models, interactive reports, dashboards, and self-service analytics capabilities across the organization.

Job Duties & Responsibilities

• Design, develop, and maintain Power BI reports, dashboards, and interactive analytics solutions that meet business requirements across HVAC, plumbing, and appliance business units.
• Build and optimize Power BI semantic models (datasets), including DAX measures, calculated columns, relationships, and role-level security configurations.
• Connect Power BI to the enterprise data platform via Direct Lake, SQL Analytics Endpoints, and OneLake, ensuring performant and reliable data connectivity.
• Partner with Business Product Owners and functional stakeholders to gather requirements, define KPIs, and translate business questions into clear visualizations.
• Optimize report performance through query reduction techniques, aggregation tables, incremental refresh, and efficient DAX patterns.
• Establish and maintain Power BI workspace governance, including naming conventions, deployment pipelines, and access management.
• Collaborate with Data Engineers and Analytics Engineers to define Gold layer semantic model requirements and ensure upstream data structures support reporting needs.
• Develop standardized report templates and visual design patterns that ensure a consistent, professional look across the reporting portfolio.
• Support self-service analytics adoption by building reusable datasets, creating documentation, and training business users on Power BI.

Qualifications

Required

• Bachelor’s degree in Computer Science, Information Systems, Business Analytics, or a related field, or equivalent practical experience.
• 3+ years of experience developing business intelligence solutions with strong proficiency in Power BI (report development, semantic modeling, DAX).
• Solid proficiency in SQL for querying, validating, and exploring data across relational and lakehouse environments.
• Experience building and optimizing Power BI semantic models, including star schema design, relationships, and row-level security.
• Understanding of data visualization best practices and the ability to translate complex data into clear visual narratives.
• Strong communication skills with the ability to gather requirements from business stakeholders and present findings to non-technical audiences.

Preferred

• Experience with Microsoft Fabric, Direct Lake connectivity, SQL Analytics Endpoints, and OneLake.
• Familiarity with Power BI deployment pipelines, workspace governance, and Power BI Service administration.
• Experience with dbt or modern analytics engineering workflows and the medallion architecture (Bronze / Silver / Gold).
• Background in wholesale distribution, supply chain, HVAC, plumbing, or related B2B sectors.
• Experience or demonstrated ability using AI-powered tools (e.g., code assistants, LLMs, AI-augmented workflows) to accelerate work and improve outcomes.

Physical Demands & Work Environment

This is a full-time position. Duties are primarily performed in an office or remote work environment.

• Primarily sedentary work with extended periods at a computer
• Ability to communicate effectively in person, by phone, and through virtual collaboration tools
• Occasional standing, walking, and movement during meetings or travel
• Ability to travel periodically for business needs, including visits to distribution centers, suppliers, or industry events
• Office environment with standard business equipment such as computers, phones, and conferencing tools

What We Offer:

We prioritize your well-being from day one with a comprehensive benefits package that includes:

• Medical, dental, vision, and prescription coverage effective immediately
• 401(k) plan with company contributions
• Life insurance and short-term disability coverage
• HSA/FSA options and an Employee Assistance Program (EAP)
• Paid time off, including vacation, holidays, and personal days
• Weekly pay, employee discounts, and more

Equal Employment Opportunity & Pre-Employment Requirements

mSupply is an Equal Opportunity Employer. We make employment decisions without regard to sex, age, race, color, creed, religion, national origin, citizenship or immigration status, sexual orientation, gender identity or expression, disability, genetic information, marital status, veteran or military status, or any other status protected by applicable federal, state, or local law. #mSupply

We are committed to providing reasonable accommodations for qualified individuals with disabilities and to applicants with sincerely held religious beliefs. To request a reasonable accommodation, please contact [e-mail].

Final offers of employment may be contingent upon completion of job-related pre-employment checks and screenings permitted by law. For roles that require operation of a company vehicle, a Motor Vehicle Record (MVR) check may also be conducted. This employer participates in E-Verify to confirm employment eligibility in the United States.

CORPORATE
One City Place, Suite 400
St Louis, MO 63141
[phone]