Xero · jobs.ashbyhq.com · checked today
Data Engineer - Performance Insights
As a Data Engineer in our G&A Data & Analytics team, you will build the data products, pipelines and semantic layers that power decision making across Finance, People Experience and Legal. You will design and maintain a governed semantic layer in Snowflake, translating business concepts into metrics, dimensions and definitions that make data easy to trust and simple to use, while also helping shape the AI and agentic capabilities that give people conversational access to that data. The numbers you help produce matter well beyond the team, feeding financial performance insights, workforce repor
Skills, with evidence
- Data modelling
You will Go Further by looking past the obvious answer to find a simpler, more reliable way to model or validate a piece of G&A's data
must have - Data quality
Validating your own outputs comes naturally to you, and you are comfortable standing behind the numbers a model produces
must have - SQL
You will bring hands-on experience building SQL data models, with dbt as your tool of choice for testing, documentation and snapshotting
must have - dbt
You will bring hands-on experience building SQL data models, with dbt as your tool of choice for testing, documentation and snapshotting
must have
Your plan
- The SQL screen: correct, then fast≈ 1 h
Data quality · SQL
- Average order value by countryFoundations
- Line items per orderFoundations
- Revenue by buyer countryFoundations
- Customers who never orderedFoundations
- Hiring funnel by roleFoundations
- Data modelling: the round most people fail≈ 2 h
Data modelling · dbt
- Marketplace core entitiesFoundations
- Cinema seat bookingFoundations
- City parking baysFoundations
- Dating app matchesFoundations
- Food delivery ordersFoundations
- Say it out loud≈ 1 h
Readiness
Counted from drills you have completed anywhere on D8LooP.
leaves in 9 dremoved the moment Xero closes it