> Markdown version of [/jobs/ext/4153278-business-intelligence-data-modeler](https://www.wearedevelopers.com/jobs/ext/4153278-business-intelligence-data-modeler). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Intelligence Data Modeler - **Company:** Ferguson Enterprises Inc. - **Location:** United States (Remote available) - **Experience:** Experienced - **Salary:** $65,000.0 - $114,000.0 - **Contract:** Permanent contract - **Skills:** Query Performance, Application Programming Interfaces (APIs), Artificial Intelligence, Cloud Computing, Software Documentation, Information Systems, Computer Engineering, Data Architecture, Data Dictionary, Information Engineering, Data Infrastructure, Data Integration, Data Transformation, Data Security, Data Warehousing, Memory Management, Machine Learning, MultiDimensional EXpressions, Microsoft Software, Windows PowerShell, Power BI, Search Technologies, SQL Databases, Delivery Pipeline, Large Language Models, Git, Powerquery, Data Lakes, Information Technology, Data Analytics, Restful APIs, Semantic Modeling, Software Version Control, Databricks - **Published:** October 23, 2026 - **Apply:** https://www.builtincolorado.com/job/bi-data-modeler-remote/11824584?handler=ApplyRedirect ## About the Role 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., * Bachelor's degree in Computer Science, Information Technology, Information Systems, Data Science, Data Analytics, Computer Engineering, or a related technical subject area, or equivalent relevant technical education and professional experience. * 3-5 years of professional experience in business intelligence, data analytics, data modeling, semantic modeling, data warehousing, or a related data field. * Hands-on experience developing dimensional data models, such as star and snowflake schema structures, and translating business requirements into scalable analytical solutions. * Strong hands-on experience with Power BI, DAX, Power Query/M, and SQL, including the development and optimization of semantic models. * Experience working with enterprise data warehouses, data lakes, or other modern data platforms and integrating data from different sources. * Working knowledge of data quality, testing, security, governance, lineage, and enterprise reporting practices. * Experience with source control and structured development practices, including Git, peer review, environment promotion, and deployment pipelines. * Strong analytical and problem-solving skills with the ability to communicate complex data concepts to both technical and non-technical business customers., * Experience with Databricks, including an understanding of Medallion Architecture (Bronze, Silver, and Gold layers) and Unity Catalog. * Experience with semantic-layer or metrics technologies such as dbt, AtScale, Kyligence, or similar platforms. * Experience supporting enterprise-scale self-service BI and modern cloud data architectures. * Experience with planning, forecasting, scenario modeling, or advanced analytical use cases. * Exposure to AI, machine learning, semantic search, LLM-based analytics, or preparing curated enterprise data for AI consumption. * Familiarity with TMDL, XMLA endpoints, REST APIs, PowerShell, MDX, or BI/data platform automation. * Relevant Microsoft, Databricks, cloud, data, analytics, or business intelligence certifications. ## Description * 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 requirements. * Maintain regular and reliable attendance. * Perform other duties as assigned.