Finance Analytics Engineer

SafetyCulture

Sydney

1 week ago

Sydney

1 week ago

Apply

Finance Analytics Engineer

SafetyCulture seeks a Finance Analytics Engineer to own the Finance semantic layer using dbt and Redshift. This on-site role in Sydney involves building data models, collaborating with Finance stakeholders, and ensuring data quality and governance.

Apply

On-site

Full-time

Entry Level

Dbt

SQL

Salary

Not specified

Work Location

Sydney, New South Wales, Australia, AU

Work Model

On-site

Employment Type

Full-time

Experience Level

Not Applicable

Core Qualifications

Technical (Must-have)

dbtSQLPythondbt MacrosRedshiftdimensional modellingsemantic layer architectureCI/CDFivetranHightouch

Soft Skills

communicationcollaborationcuriosityindependenceadaptabilitydocumentation habits

Preferred Qualifications

Technical (Nice-to-have)

NetSuiteWorkdayZuoraHiBobAI-ready semantic layers

Key Responsibilities

•Design, build, and maintain dbt models for Finance source systems (NetSuite, Workday, Zuora, HiBob, banking feeds)
•Apply software engineering best practices: version control, CI/CD deployment, testing, documentation
•Write tests for uniqueness, referential integrity, business rule violations, and freshness
•Ensure every model has description, column definitions, and metric owner
•Work closely with Finance stakeholders to encode business rules into dbt models
•Validate outputs against known Finance benchmarks
•Design and implement role-based access control for Finance data layer
•Ensure audit logging is in place for compliance
•Implement automated data quality checks across Finance models
•Build monitoring and alerting for data issues
•Maintain documentation for every dbt model and pipeline
•Partner with Data Engineering team on staging layer contract
•Manage and optimise data infrastructure (Fivetran, Redshift, dbt, Hightouch)
•Consume shared dimension tables from existing analytics engineering stack
•Make Finance semantic layer queryable for downstream consumers

Finance Analytics EngineerdbtSQLPythonRedshiftFivetranHightouchSydneyOn-siteSafetyCulture

Key Responsibilities

•Design, build, and maintain dbt models for Finance source systems (NetSuite, Workday, Zuora, HiBob, banking feeds)

•Apply software engineering best practices: version control, CI/CD deployment, testing, documentation

•Write tests for uniqueness, referential integrity, business rule violations, and freshness

•Ensure every model has description, column definitions, and metric owner

•Work closely with Finance stakeholders to encode business rules into dbt models

•Validate outputs against known Finance benchmarks

•Design and implement role-based access control for Finance data layer

•Ensure audit logging is in place for compliance

•Implement automated data quality checks across Finance models

•Build monitoring and alerting for data issues

•Maintain documentation for every dbt model and pipeline

•Partner with Data Engineering team on staging layer contract

•Manage and optimise data infrastructure (Fivetran, Redshift, dbt, Hightouch)

•Consume shared dimension tables from existing analytics engineering stack

•Make Finance semantic layer queryable for downstream consumers