About the Client:
Australian medical device company that manufactures the Trophon system — a global standard for high-level disinfection of ultrasound probes. The company operates globally, with primary commercial presence in the US, Canada, and Australia/New Zealand.
Role Overview:
The role is focused on the Validated-to-Curated layer of the dbt project and is responsible for owning the business logic layer within the data platform. All business logic is implemented in dbt, rather than in BI tools, and the role does not involve building Power BI dashboards.
You will collaborate closely with a US-based Business Analyst to ensure data models are accurately aligned with business requirements and stakeholder expectations.
Responsibilities:
- Develop dbt mart models organized by business domains (finance, sales, service);
- Treat the mart layer as the semantic layer;
- Build and maintain commission calculation models (territory attribution, new vs. upgrade logic, bundled order splitting, distributor allocation);
- Develop and maintain fact tables: fct_orders, fct_invoices, fct_commissions, fct_gross_sales;
- Define and maintain business metrics in dbt YAML (descriptions, tests, lineage);
- Ensure all business logic is implemented in dbt, not in Power BI;
- Pre-aggregate data where needed for performance and deliver ready-to-use datasets;
- Maintain dbt documentation and publish dbt docs as a data dictionary;
- Collaborate with stakeholders to align models with business expectations.
Required Skills:
- Expert-level experience with dbt Core, including mart design, custom macros, semantic layer, and YAML documentation;
- Strong SQL skills with the ability to implement complex business logic, including commission calculations, revenue attribution, territory mapping, and date spine patterns;
- Solid experience with Snowflake, including performance tuning, materialization strategies, and query profiling;
- Strong understanding of dimensional modeling, including fact tables, metric aggregation, and star schema design;
- Strong business understanding of OTC concepts, including gross sales, commissions, territory assignment, order types, and revenue recognition;
- Confidence working with Git or Bitbucket, including feature branching and pull request workflows;
- Professional-level English with the ability to effectively collaborate with US-based stakeholders.
Nice to Have:
- Experience with OTC / revenue analytics models;
- Financial data experience (GL, revenue recognition, deferred revenue);
- Experience with dbt Metrics / semantic layer;
- Experience with commission or variable compensation models.
Our benefits:
- Professional and career growth promotion;
- Competitive salary;
- Paid vacations and sick leaves;
- Internal Medical Program;
- Program for veterans (which includes mentorship, an accessible office for individuals with disabilities, legal support, and additional benefits);
- Flexible working hours;
- Regular corporate social activities;
- Regular technical training at our office;
- English courses;
- Gym, etc.
