BI Data Modeler - Remote

Job Posting:

Since 1953, Ferguson has been a source of quality supplies for a variety of industries. Together We Build Better infrastructure, better homes and better businesses. We exist to make our customers’ complex projects simple, successful, and sustainable. We proactively solve problems, adapt and grow to continuously serve our customers, communities and each other. Ferguson, a Fortune 500 company, is proud to provide best-in-class products, service and capabilities across the following industries:
Commercial/Mechanical, Facilities Supply, Fire and Fabrication, HVAC, Industrial, Residential Trade, Residential Building and Remodel, Waterworks and Residential Digital Commerce. Ferguson has approximately 36,000 associates across 1,700 locations. Ferguson is a community of proud associates who operate with the shared purpose of building something meaningful. You will build a career that you are proud of, at a company you can believe in.

The Business Intelligence Data Modeler is part of the Enterprise Solutions organization, specifically within the IT Enterprise Data Applications team. This role designs, builds, and optimizes the data models and semantic layers that power enterprise reporting, forecasting, self-service analytics, and emerging AI and machine learning use cases.

Working across business and technology teams, this role transforms complex data into trusted, scalable, and easy-to-use analytical solutions. The ideal candidate brings strong data modeling expertise, hands-on Power BI and SQL experience, and a solid understanding of modern enterprise data platforms and governance practices.

Location :
This role is approved to be fully remote and can be based anywhere in the United States.

• Design, build, and maintain conceptual, logical, physical, dimensional, and semantic data models, including star and snowflake schemas, conformed dimensions, bridge tables, and slowly changing dimensions.
• Translate business and analytical requirements into scalable, reusable data models, standardized metrics, KPIs, calculations, and reporting definitions.
• Develop and maintain Power BI semantic models, dashboards, reports, and curated analytical datasets.
• Create calculations, queries, and data transformations using DAX, SQL, and Power Query/M.
• Build planning and analytical models that support prediction, scenario analysis, sensitivity analysis, and business decision-making.
• Profile, validate, reconcile, and test data to ensure accuracy, consistency, quality, and analytical readiness.
• Optimize model performance, including storage modes, aggregations, partitions, incremental refresh, query performance, memory usage, and scalability.
• Integrate data from enterprise data warehouses, data lakes, APIs, and other sources in partnership with data engineering and platform teams.
• Implement and support data security and governance practices, including Row-Level Security, Object-Level Security, sensitivity labeling, lineage, certification, and metric governance.
• Support production semantic models and datasets through monitoring, troubleshooting, root-cause analysis, and issue resolution.
• Apply source control, peer review, deployment, change management, and rollback practices across BI and data modeling solutions.
• Prepare trusted datasets, metadata, metric definitions, and business context for AI, machine learning, semantic search, AI-powered assistants, and LLM-based analytics.
• Partner with technical and business stakeholders to capture requirements and maintain model diagrams, data dictionaries, user documentation, metric definitions, and support runbooks.
• Adhere to Company compliance and Health, Safety and Environment (HSE) policies, procedures, and…