Senior Data Engineer

About the role

The Senior Data Engineer plays a crucial role in building a world-class financial data platform for Sovos, a global leader in tax compliance solutions. The position focuses on designing and building the Snowflake architecture and dbt model infrastructure that supports the company's US topline data chain, ensuring reliability through financial close cycles, and extending the dbt model layer to cover additional financial areas.

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
• PREFERRED: Experience integrating CRM/ERP systems (NetSuite, Salesforce, or similar) into a warehouse layer, including ELT patterns, API pagination, and incremental loads
• PREFERRED: Python for pipeline scripting and orchestration
• PREFERRED: Cloud infrastructure experience: Azure (App Service, Azure AD, Functions) or AWS; familiarity with auth patterns (JWT, OAuth) and CI/CD fundamentals
• PREFERRED: Experience with Model Context Protocol (MCP) or similar frameworks for connecting AI agents to structured data
• PREFERRED: Background in B2B SaaS metrics: ARR, GRR, NRR, churn, and deferred revenue
• PREFERRED: Familiarity with data governance practices: PII handling, access control, and GDPR basics
• NICE TO HAVE: RAG architecture, hybrid retrieval strategies, or prompt engineering experience
• NICE TO HAVE: MLOps or ML pipeline experience
• NICE TO HAVE: Domain knowledge in compliance, tax technology, or e-invoicing

Benefits

• Flexible Time-Off
• Comprehensive Health, Dental and Vision benefits
• 401(k) with employee sponsored match
• Bi-Weekly Meeting Free Days
• Mentoring Programs
• Globally recognized Training and Development programs
• Tuition Reimbursement, Time off to Volunteer, Charitable Giving Match, and more!

Pay

Competitive compensation package based on experience and qualifications.

Schedule

Full-time position.