Analytics Engineer, Finance
Salary
$128,393 - $167,498
Location
San Juan, Puerto Rico; District of Columbia; Europe | Spain; New York, NY
Posted
Today
Rain is building payments and stablecoin infrastructure. Every transaction generates data across our system.
We’re looking for an Analytics Engineer, Finance to own the data layer Finance runs on: model it, reconcile it against source systems, test it, automate it, and make it self-serve. You’ll partner with Finance and Accounting and the data team to make sure every number we report ties back to its source.
We’re looking for someone with high agency and urgency who owns problems end to end, digs into discrepancies until the numbers tie out, and communicates clearly when something is uncertain. We care less about where you trained and more about what you’ve built.
At Rain, we’re builders who use AI to automate repetitive work. That changes what data roles look like: where a data scientist used to only analyze and an analyst used to only build dashboards, here everyone models data, writes production-quality code, and automates their own workflows. You own the result, including checking what the AI produces. For this role, that means building trusted models and automating the reconciliations and reporting Finance depends on.
What you'll do
- Build and own models for Finance: ledger, settlements, card transactions, invoicing, fees, and collateral, with clear grain and consistent definitions.
- Build and run reconciliations between internal systems and external sources (card networks, processors, banks, partners); investigate breaks and fix the root cause.
- Support month-end close and audit readiness with validated, documented outputs Finance can trust.
- Automate recurring Finance reporting and deliveries (scheduled reports, exports, and alerts) so close and partner reporting run without manual work.
- Add data quality tests and alerts so issues are caught before Finance sees them.
- Partner with Finance to define metrics such as revenue, costs, volume, and contribution profit, and make them reusable across teams.
- Build self-serve reporting so Finance can answer recurring questions independently.
- Work with data and platform engineers on ingestion and source changes, following Rain’s data standards and access policies.
What you'll need
- At least 3 years of experience in analytics engineering, software engineering, or analytics with a strong data modeling focus.
- Proficiency using AI tools to learn new skills, navigate unfamiliar domains, and accelerate your work, while taking responsibility for checking the output.
- Strong SQL in a modern data warehouse such as BigQuery, Snowflake, or Redshift, including complex joins, window functions, and incremental logic.
- Hands-on dbt experience: data modeling, testing, documentation, version control, and code review.
- Experience reconciling data across systems and explaining differences down to the row.
- Familiarity with financial metrics and processes, such as revenue and costs, financial statements, reconciliation, or monthly close.
- Strong attention to detail: you validate results against source systems and explain assumptions, tradeoffs, and uncertainty.
- Ability to work independently and collaboratively in a fast-moving startup, communicating clearly with technical and nontechnical partners.
Nice to have
- Experience in payments, card issuing, fintech, or stablecoins, such as settlement files, ledgers, or interchange.
- Experience with BI as code, such as Lightdash, Looker, or Omni.
- Python or another scripting language for automation and data checks.
- Experience working directly with Finance or Accounting teams.
- Experience with orchestration and ingestion tools such as Dagster, Airflow, Meltano, Fivetran, or Datastream.
Stay informed about the latest analytics engineering opportunities. Subscribe to our weekly newsletter.