SnapCode Inc
Senior Analytical Engineer (dbt) Accounting & Finance Analytics
Location: Pleasanton, California (hybrid work)
Summary We're hiring a Senior Analytical Engineer with experience in dbt (Core & Cloud) and dimensional modeling. You'll turn messy ERP and operational data into trusted, documented, and testable datasets that power accounting, finance, and adjacent domains (procurement, supply chain, revenue ops). If you enjoy building elegant star schemas, writing bulletproof tests, and coaching teams on best practices, you'll feel right at home.
Responsibilities
Model the finance backbone: Design and maintain star/snowflake schemas for GL, AR, AP, procurement (P2P), order-to-cash, revenue, cash, and entity/fx domains across multiple ERPs (e.g., NetSuite, Oracle, SAP) and procurement systems (e.g., Coupa).
Own the dbt layer end-to-end:
Build modular models, macros, seeds, snapshots, and packages; choose appropriate materializations (view/table/incremental) and strategies (merge, insert-overwrite).
Implement testing at scale (generic & singular tests, contracts, schemas, unit tests) and documentation (docs blocks, exposures).
Stand up robust environments (dev/stage/prod), CI/PR checks (Slim CI/deferral), and job scheduling in dbt Cloud (or equivalent orchestration).
Required Skills
dbt expert: 36+ years building production dbt projects (Core & Cloud): macros, snapshots, packages, exposures, environments, Slim CI, artifacts (manifest/run results), and doc sites.
Dimensional modeling: Deep fluency with facts/dimensions, SCDs, conformed dims, grain selection, and semantic modeling for finance/ops analytics.
SQL & performance: Advanced SQL in at least one cloud warehouse (Snowflake, BigQuery, Redshift, Databricks SQL), with strong query-tuning instincts.
Python for analytics: Comfortable with Python for data utilities (tests, codegen, linting, CI hooks) and light transformations when needed.
Data quality by default: Hands-on with dbt tests (generic & custom), schema contracts, unit/integration tests, and CI pipelines tied to PRs.
Business acumen (Fin/Acct): Working knowledge of GL, AR, AP, revenue recognition, multi-entity/multi-currency, fiscal calendars, and procure-to-pay processes (vendors, POs, receipts, invoices, 2-/3-way match).
#J-18808-Ljbffr
Summary We're hiring a Senior Analytical Engineer with experience in dbt (Core & Cloud) and dimensional modeling. You'll turn messy ERP and operational data into trusted, documented, and testable datasets that power accounting, finance, and adjacent domains (procurement, supply chain, revenue ops). If you enjoy building elegant star schemas, writing bulletproof tests, and coaching teams on best practices, you'll feel right at home.
Responsibilities
Model the finance backbone: Design and maintain star/snowflake schemas for GL, AR, AP, procurement (P2P), order-to-cash, revenue, cash, and entity/fx domains across multiple ERPs (e.g., NetSuite, Oracle, SAP) and procurement systems (e.g., Coupa).
Own the dbt layer end-to-end:
Build modular models, macros, seeds, snapshots, and packages; choose appropriate materializations (view/table/incremental) and strategies (merge, insert-overwrite).
Implement testing at scale (generic & singular tests, contracts, schemas, unit tests) and documentation (docs blocks, exposures).
Stand up robust environments (dev/stage/prod), CI/PR checks (Slim CI/deferral), and job scheduling in dbt Cloud (or equivalent orchestration).
Required Skills
dbt expert: 36+ years building production dbt projects (Core & Cloud): macros, snapshots, packages, exposures, environments, Slim CI, artifacts (manifest/run results), and doc sites.
Dimensional modeling: Deep fluency with facts/dimensions, SCDs, conformed dims, grain selection, and semantic modeling for finance/ops analytics.
SQL & performance: Advanced SQL in at least one cloud warehouse (Snowflake, BigQuery, Redshift, Databricks SQL), with strong query-tuning instincts.
Python for analytics: Comfortable with Python for data utilities (tests, codegen, linting, CI hooks) and light transformations when needed.
Data quality by default: Hands-on with dbt tests (generic & custom), schema contracts, unit/integration tests, and CI pipelines tied to PRs.
Business acumen (Fin/Acct): Working knowledge of GL, AR, AP, revenue recognition, multi-entity/multi-currency, fiscal calendars, and procure-to-pay processes (vendors, POs, receipts, invoices, 2-/3-way match).
#J-18808-Ljbffr