BI Data Modeler - Remote at Ferguson · Remote (United States)
Everything on this page is labelled by where it comes from: questions candidates reported on JobRipe, JobRipe's own preparation guide, and the job ad itself. Nothing here is made up about the company.
Read from this job's ad: what it asks for, so you can prepare one real example for each.
Databricks
A time you used Databricks: the problem, what you did yourself, and what happened.
From the ad's requirements
dbt
A time you used dbt: the problem, what you did yourself, and what happened.
From the ad's requirements
LLM
A time you used LLM: the problem, what you did yourself, and what happened.
From the ad's requirements
Machine Learning
A time you used Machine Learning: the problem, what you did yourself, and what happened.
From the ad's requirements
3+ years of experience
How your experience adds up to what they ask for (3+ years), and the parts most like this job.
From the ad's requirements
Education
Your studies or training, or the equivalent experience if the ad allows it.
The ad says: “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 tech”
From the ad's requirements
3-5 years of professional experience in business intelligence, data analytics, data modeling, semantic modeling, data warehousing, or a rela
An example from your own work that shows this.
From the ad's requirements
Hands-on experience developing dimensional data models, such as star and snowflake schema structures, and translating business requirements
An example from your own work that shows this.
From the ad's requirements
Strong hands-on experience with Power BI, DAX, Power Query/M, and SQL, including the development and optimization of semantic models.
An example from your own work that shows this.
From the ad's requirements
Experience working with enterprise data warehouses, data lakes, or other modern data platforms and integrating data from different sources.
An example from your own work that shows this.
From the ad's requirements
Working knowledge of data quality, testing, security, governance, lineage, and enterprise reporting practices.
An example from your own work that shows this.
From the ad's requirements
Experience with source control and structured development practices, including Git, peer review, environment promotion, and deployment pipel
An example from your own work that shows this.
From the ad's requirements
Strong analytical and problem-solving skills with the ability to communicate complex data concepts to both technical and non-technical busin
An example from your own work that shows this.
From the ad's requirements
Candidate reports: questions verified applicants typed in their interview reviews on JobRipe, shown as written.
No candidate has shared interview questions for Ferguson on JobRipe yet. Use the job ad and our guide below.
Only figures we have enough data for. Nothing is estimated.
We show an employee rating once Ferguson has at least 5 published verified reviews. Company page
Interview difficulty and process length appear once 5 candidates have reported them.
Our editorial preparation guide: typical questions for the field, not reports from candidates.
Why they ask: Rigour.
How to answer: Metric choice, baselines, offline vs online tests.
Why they ask: Communication.
How to answer: Problem, approach, impact, limits.
Why they ask: Security is named in the posting.
How to answer: One concrete project, one honest lesson.
Pick a question, answer as you would out loud, and get AI feedback on structure, detail and fit with this job. Private to you; up to 20 reviews a day.
Sign in to practise with feedbackTicks are kept on this device only.
0 of 9 done
Why they ask: Machine Learning is named in the posting.
How to answer: One concrete project, one honest lesson.
Why they ask: Opener to see how you frame your story.
How to answer: Two minutes: current role, one achievement that matches this job, why this company now.
Why they ask: Checks ownership and depth.
How to answer: Use situation, action, result. Quantify the result.
Why they ask: Tests accountability and learning.
How to answer: Pick a real failure, own your part, show the fix and what changed afterwards.
Why they ask: Checks judgement under pressure.
How to answer: Describe a concrete framework and one example of a trade-off you made.
Questions to ask them