Senior Data Engineer

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