Remote BI Data Modeler - Power BI & Data Modeling

Ferguson; USA; Remote; USD 61.000 - 106.000; Vollzeit

Benefits dieser Stelle

Health benefits

401(k) with company match

Paid time off

Parental leave

Zusammenfassung

Ferguson is hiring a remote Business Intelligence Data Modeler to design, build, and optimize data models and semantic layers powering enterprise reporting and AI use cases. You will craft scalable data models, DAX calculations, and Power BI datasets across data warehouses and lakes, collaborating with data engineering and platform teams.

The role emphasizes governance, security, and reproducible deployment practices, with a strong focus on analytics quality and scale for decision-making.

Qualifikationen

• 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.

Aufgaben

• 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.

Kenntnisse

Power BI

SQL

DAX

Power Query/M

Data modeling

Git

Data governance

Ausbildung

Bachelor's degree in CS/IT/Data-related

Tools

Databricks

Unity Catalog

dbt

Kyligence

Jobbeschreibung

Ferguson is hiring a remote Business Intelligence Data Modeler to design, build, and optimize data models and semantic layers powering enterprise reporting and AI use cases. You will craft scalable data models, DAX calculations, and Power BI datasets across data warehouses and lakes, collaborating with data engineering and platform teams.

The role emphasizes governance, security, and reproducible deployment practices, with a strong focus on analytics quality and scale for decision-making.