Sovos is a global leader in tax compliance solutions, dedicated to transforming how businesses navigate regulatory challenges. The Senior Data Engineer will be responsible for building and maintaining a financial data platform, ensuring data quality and reliability while supporting critical financial decision-making processes.
Responsibilities:
- Design and build the Snowflake schema and dbt model architecture for the US topline data chain: Billing → ARR → Deferred Revenue → Rev Rec → Close Pack
- Deliver ingestion and transformation models with full test coverage and documentation across all assigned use cases
- Own pipeline reliability through financial close – monitor, alert on, and recover from failures; serve as the primary on-call escalation point
- Establish data quality standards, dbt testing conventions, and Snowflake governance patterns for the broader team
- Partner with the Analytics Engineer on business-layer model design to ensure technical outputs map accurately to finance requirements
- Extend the dbt model layer to cover OPEX, COGS, commissions, and ASC 340-40 capitalized software as scope grows
- Write dbt YAML documentation – table descriptions, column definitions, and grain statements – as a first-class production deliverable, recognizing that documentation quality directly determines AI answer accuracy
- Own row-level security and model freshness SLAs for real-time AI queries, treating AI consumers as first-class stakeholders alongside finance
Requirements:
- 5–8 years of experience in data engineering, with a track record of building and maintaining production pipelines and dbt projects at scale
- Advanced SQL skills: CTEs, window functions, LATERAL joins, performance tuning, and complex multi-source financial queries
- Production dbt experience: modular models, tests, documentation, and semantic metadata for both AI and BI consumers
- Snowflake proficiency: roles, warehouses, governance, masking policies, and row-level security – not just querying, but owning the environment
- Experience supporting financial close cycles, including on-call ownership of pipeline failures; understands what WD1 means and why it matters
- Fluency in the revenue data chain (Billing → ARR → Deferred Revenue → Rev Rec → Close Pack) with the ability to engage finance stakeholders directly on data discrepancies
- Strong communication skills: able to explain technical trade-offs to non-technical audiences and write documentation that finance analysts can use to validate outputs
- Experience integrating CRM/ERP systems (NetSuite, Salesforce, or similar) into a warehouse layer, including ELT patterns, API pagination, and incremental loads
- Python for pipeline scripting and orchestration
- Cloud infrastructure experience: Azure (App Service, Azure AD, Functions) or AWS; familiarity with auth patterns (JWT, OAuth) and CI/CD fundamentals
- Experience with Model Context Protocol (MCP) or similar frameworks for connecting AI agents to structured data
- Background in B2B SaaS metrics: ARR, GRR, NRR, churn, and deferred revenue
- Familiarity with data governance practices: PII handling, access control, and GDPR basics