Overview
Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Skills
Dbt
SQL
Snowflake
Python
GL
AR
AP
Job Details
Title: Senior Analytical Engineer (dbt) Accounting & Finance Analytics
Location: Pleasanton, California (hybrid work)
Need Local to California
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: 3 6+ 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).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.