Analytics Engineer, Finance

Rain•New York, DC

3d•$128,393 - $167,498

About The Position

Rain is hiring an Analytics Engineer, Finance to own the data layer used by Finance. The role models, reconciles, tests, and automates financial data and makes it available for self-service. The person will partner with Finance, Accounting, and the data team to ensure reported numbers tie back to their source systems. The role focuses on building trusted data models and automating reconciliations and reporting. It calls for high ownership, urgency, careful investigation of discrepancies, and clear communication about uncertainty. Rain emphasizes production-quality code, responsible use of AI tools, and validating the output of those tools. The position supports Finance processes including month-end close and audit readiness, and builds reusable metrics and self-serve reporting. The job description describes a flexible workplace: employees may work from home, an office, or both.

Requirements

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 work, while taking responsibility for checking the output.
Strong SQL skills in a modern data warehouse such as BigQuery, Snowflake, or Redshift, including complex joins, window functions, and incremental logic.
Hands-on dbt experience with 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, including validating results against source systems and explaining assumptions, tradeoffs, and uncertainty.
Ability to work independently and collaboratively in a fast-moving startup and communicate clearly with technical and nontechnical partners.

Nice To Haves

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.

Responsibilities

Build and own Finance data models for ledger, settlements, card transactions, invoicing, fees, and collateral, with clear grain and consistent definitions.
Build and run reconciliations between internal systems and external sources such as card networks, processors, banks, and partners; investigate breaks and address root causes.
Support month-end close and audit readiness with validated, documented outputs Finance can trust.
Automate recurring Finance reporting and deliveries, including scheduled reports, exports, and alerts.
Add data quality tests and alerts to identify issues before they reach Finance.
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.

Benefits

Flexible time off, with a minimum of 10 vacation days required.
Flexible workplace: work from home, from an office, or both.
New employees receive a stipend to set up a home workspace.
For US employees, the company covers 95% of health, dental, and vision plan costs and 90% of dependent costs.
Company-subsidized life insurance plan for US employees.
401(k) with a 4% company match.
Equity option plan.
Monthly stipend for eligible health and wellness spending.
Lunch and dinner for employees working from the office, covered by a DoorDash credit.
Domestic and international team and company offsites.