Interview Studio

Requirements found

Sales Sql Writing Inventory (must)

What this posting asks for

Level: Mid level — The posting asks for 3+ years of experience.

Main responsibilities

• Partner with the business.
• Work with Finance, Sales, Operations, and venue teams to understand their needs and turn them into models and metrics they trust.
• Own ingestion for your domains.
• Build dbt models that move data through bronze, silver, and gold, and shape gold around how CHG runs so people outside the data team can understand and use it.
• Own the semantic layer.
• Build the models and Liveboards that let teams explore data on their own, and turn the questions people actually ask into new test cases.
• Own the quality of conversational analytics.
• Test answers the way you’d test code.
• Build and maintain a golden question set of real business questions paired with certified answers as your test cases, run them as a regression suite on every…
• Monitor freshness, data quality, and pipeline health so problems surface to you before they reach a dashboard or an agent’s answer.

Competencies an interviewer will look for

• Technical skill Core
  In the posting: “You’ll join the Data Platform team, reporting to its Engineering Manager, and work closely with other analytics engineers and business partners across the co…” · “Test answers the way you’d test code.” · “You hold agent and human work to the same review bar, so code from Claude and code from a teammate get the same scrutiny.”
  Show it by: Names the tools, languages or systems used and how; Explains a technical choice and its trade-off.
• Communication Core
  In the posting: “Back your models with dbt tests and clear documentation.” · “Lead with specs, then hand agents end-to-end tasks, from exploring source data to building models, tests, and documentation.” · “You use AI agents for real multi-step work, like writing SQL and dbt models, generating tests, and drafting documentation, and you verify what they produce.”
  Show it by: Adapts the message to the listener; Gives an example of explaining something clearly in writing or speech.
• Teamwork and collaboration Core
  In the posting: “You’ll join the Data Platform team, reporting to its Engineering Manager, and work closely with other analytics engineers and business partners across the co…” · “Partner with the business.” · “Our values of GRIT (Genuine, Relentless, Integrity, and Teamwork) shape how we show up for each other every day.”
  Show it by: Says what they did inside a team, not only what 'we' did; Shows how a disagreement was handled.
• Ownership and accountability Core
  In the posting: “Analytics engineers own the full path from ingestion to visualization, including governance and observability.” · “Own the semantic layer.” · “Own the quality of conversational analytics.”
  Show it by: Takes a task from start to finish without being chased; Owns a mistake and what was changed after it.
• Planning and organisation Core
  In the posting: “We’re hiring Analytics Engineers to join Convene Hospitality Group’s (CHG) Technology organization.” · “This role is also eligible for Convene's annual incentive performance bonus plan.” · “Health & Wellness: Day-one health coverage for you and your family, 24/7 virtual care, emotional well-being support, and fertility & family planning benefits.”
  Show it by: Shows how priorities were set when everything was urgent; Mentions deadlines met and how.
• Data and analysis Core
  In the posting: “We’re building out the foundational platform to democratize data at CHG so that a venue GM, a finance lead, and an AI agent are all able to ask a question an…” · “You’ll bring data in from source systems, model it through bronze, silver, and gold, define the semantic layer, and breathe life into the visualizations, con…” · “You’ll join the Data Platform team, reporting to its Engineering Manager, and work closely with other analytics engineers and business partners across the co…”
  Show it by: Uses a number to describe the situation or the result; Explains what the data showed and what was done with it.
• Attention to detail and quality Core
  In the posting: “Own the quality of conversational analytics.” · “Back your models with dbt tests and clear documentation.” · “Tag sensitive data at ingestion, apply access controls such as tag-based masking and row access policies, and follow the standards the team sets, so an agent…”
  Show it by: Gives an example of an error caught before it caused harm; Names the check or standard they used.
• Problem solving Core
  In the posting: “Tune synonyms and descriptions so a model picks the right measure, trace wrong answers to the root cause, and help us decide where each definition lives.” · “You’ve worked with ELT ingestion tools like Fivetran and can troubleshoot source-data issues such as schema changes, late-arriving data, and API limits.”
  Show it by: Describes a real problem, the options considered and the one chosen; Shows how the cause was found, not just the fix.
• Stakeholder management Core
  In the posting: “You’ll join the Data Platform team, reporting to its Engineering Manager, and work closely with other analytics engineers and business partners across the co…” · “You explain your work clearly to technical and non-technical partners.”
  Show it by: Shows how they aligned people with different goals; Explains how they handled a 'no' from someone senior.
• Customer focus Supporting
  In the posting: “You’ve worked in hospitality, events, real estate, or another customer-centric, multi-location business.”
  Show it by: Puts the customer's need in their own words; Shows a result for the customer, not only for the company.
• Adaptability and learning Supporting
  In the posting: “You’re curious about the business.”
  Show it by: Describes learning something new quickly and using it; Shows a change of plan and how they adjusted.

Read from the posting's own words by fixed rules — no AI service. Nothing you paste is sent anywhere or stored.