Financial Systems Data Engineer

Angel • Provo, UT

3d • $140,000 - $160,000 • Hybrid

About The Position

You’ll take ownership of Angel’s financial data foundation
You’ll take ownership of how Angel understands, reconciles, and operationalizes its financial data—building the datasets, integrations, and metric definitions that make our numbers accurate, traceable, and actionable. From Stripe and Shopify through NetSuite and into Snowflake, you’ll ensure financial transactions are auditable from source events to journal-ready outputs, automate the workflows that keep Finance moving fast, and create a financial data foundation the company can rely on as we scale in a public-company environment.

Requirements

• Strong SQL foundation — you can build reliable, reusable datasets from messy real-world tables, and you know how to validate results when numbers don’t match expectations.
• Python fluency for integrations and automation — you can write production-quality scripts/services to move, transform, and reconcile data across systems (APIs, scheduled jobs, lightweight pipelines), with solid engineering hygiene.
• Systems integration experience — experience integrating systems through REST APIs and/or event-driven workflows, including handling schema changes, metadata reconciliation, and cross-system identifiers.
• Financial modeling + accounting literacy — you understand core accounting principles and terminology (GL, accruals, revenue recognition concepts, debits/credits) and can translate transaction flows into ledger-ready, auditable logic.
• Auditability and traceability mindset — you design datasets so transactions can be reconciled back to source systems and support compliance requirements (especially important in a public-company environment).
• High-velocity execution with deep focus — you deliver impact quickly and maintain momentum on deep technical work without constant context switching, while knowing when to build a durable solution versus a quick one.
• Strong ownership and initiative — you spot problems in the data, define an approach, and drive it to completion with urgency and accountability, raising the bar for data trust.
• Exceptional communicator — you can explain financial data logic clearly to both technical and non-technical stakeholders, and you write documentation that makes your work easier to adopt and audit.
• AI-enabled productivity mindset — you’re willing (and ideally experienced) using AI to speed up development, improve code quality, generate documentation and tests, and support carefully scoped workflow automation—without compromising data correctness, auditability, or control.
• 6+ years in a data engineer, analytics engineer, data scientist, or adjacent role with substantial SQL and Python responsibility (title flexible if skill fit is strong).
• Demonstrated ability to write complex SQL and build/maintain durable datasets in Snowflake; familiarity with dbt is a plus.
• Demonstrated ability to use Python to build integrations and automation across data systems (APIs, ELT/ETL, scheduled jobs, lightweight services).
• Experience with payments and transaction data—ideally including Stripe transaction models (charges, refunds, payouts, fees, disputes/chargebacks) and how these flows map into financial accounting and reconciliation.
• Comfort partnering closely with finance/accounting stakeholders; familiarity with NetSuite concepts is a plus.

Nice To Haves

• Familiarity with ELT tools like Airbyte and BI tools such as Rill, Lightdash, and Metabase is a plus.
• Bonus: experience building lightweight internal tools (e.g., Streamlit), small backend services, or UI work (e.g., React/TSX)—helpful for enabling Finance workflows but not required.
• Track record of using AI tools to increase productivity across engineering and analytics work—such as faster SQL/dbt development, better debugging, improved documentation/test generation, or carefully scoped automation within data pipelines—is a plus.

Responsibilities

• Design and maintain financial data pipelines — build and maintain pipelines that ingest, normalize, and reconcile data across payment, commerce, and accounting systems (Stripe, Shopify, NetSuite, etc.), ensuring transactions are traceable from source events through ledger/journal-ready outputs. Monitor and maintain pipeline reliability by handling upstream scheme changes, data anomalies and operational issues to ensure consistent data delivery.
• Model end-to-end transaction lifecycles — reconstruct and model complex financial flows (payments, refunds, fees, taxes, adjustments, chargebacks) including edge cases like prorated refunds, gross vs. net logic, and tax jurisdiction nuances—translating them into auditable datasets suitable for accounting and reporting.
• Build trusted financial datasets — write complex SQL in Snowflake (and dbt where appropriate) to create clean, reusable datasets that power reporting, reconciliations, forecasting support, and ad hoc analysis.
• Own cross-system integrations and identifiers — use Python to build and maintain integrations (REST APIs and event-driven workflows where applicable), including schema change handling, metadata mapping, and reconciliation of cross-system identifiers.
• Investigate and resolve discrepancies — trace transactions across multiple systems and data sources to identify root causes, resolve mismatches, and improve upstream data correctness and monitoring.
• Establish trust through financial metrics — define, refine, and communicate the metrics that matter (revenue, refunds/chargebacks, COGS, margin, deferred revenue concepts, cash timing), building stakeholder confidence in how we measure performance.
• Use AI to move faster (without lowering the bar) — leverage AI tools to accelerate SQL/dbt development, debugging, documentation, testing, and carefully scoped workflow automation, while maintaining high standards for correctness, traceability, and security.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed