Senior Data Engineer

The role

This person will build and maintain dbt models and reconcile financial and operational data. They will work on a scalable data platform to support analytics, applications, and automation for accounting and advisory firms.

What you will do

• Build and maintain tested, documented dbt models across bronze, silver, and gold layers.
• Refine canonical models for firms, clients, employees, projects, time, WIP, invoices, cash receipts, and revenue.
• Reconcile financial and operational data to source systems.
• Create entity crosswalks and historical logic to preserve reporting continuity.
• Build and improve ingestion from SQL Server, cloud databases, SaaS platforms, and APIs using Python and SQL.
• Strengthen production reliability through automated tests, freshness checks, and monitoring.
• Partner with engineering to implement secure access and data isolation.
• Translate business requirements into reusable data products and documented data contracts.
• Contribute to Git-based development, CI/CD, and code reviews.

Required qualifications

• 5+ years in data engineering, analytics engineering, or a related role or equivalent depth of relevant experience.
• Advanced SQL and strong production data-modeling skills.
• Deep production experience with dbt.
• Ability to reconcile financial and operational data and explain causes to technical and business audiences.
• Strong Python skills and experience building ingestion or automation against APIs, databases, and external systems.
• Practical understanding of incremental loading, change capture, idempotency, backfills, and schema evolution.
• Experience with Git, code review, CI/CD, data-quality monitoring, and supporting production data pipelines.
• Working knowledge of least-privilege access, sensitive-data handling, and secrets management.
• Willingness to learn Databricks.
• Clear written and verbal communication, strong ownership, and sound judgment.

Nice to have

• Databricks, Delta Lake, Unity Catalog, SQL warehouses, or Databricks Jobs and Workflows.
• Azure, Azure Blob Storage, Windows-hosted ingestion, or on-premises SQL Server environments.
• Accounting or professional-services data, especially billing, WIP, revenue, or financial reconciliation.
• Systems such as Aiwyn, Practice CS, CCH Axcess, NetSuite, or UKG.
• Multi-firm or multi-tenant data platforms, row-level security, or migrations requiring entity mapping.

Benefits

• Health, Dental, and Vision Insurance
• Options for fully paid employee only coverage for health and dental
• Company-Paid Life and Long-Term & Short-Term Disability Insurance
• Ancillary Benefits such as supplemental life insurance, critical illness, and accident insurance
• Classic Safe Harbor 401(k) Plan with employer contributions
• Access to Becker and LinkedIn Learning

About the company

Current partners with leading accounting firms across the United States through a shared platform. The company invests in professional development and connects firms through innovative technology.