Data Analyst, Payments Reconciliation

Rippling People Center Inc.•San Francisco, CA

29d•Hybrid

About The Position

Join our growing Payments Data & Analytics team as an experienced Data Analyst. This is an opportunity to be embedded in the engine room of our customer funds analytics -playing a critical role in reconciling customer data, improving data quality, and making our payments reconciliation platform bulletproof and more scalable. You'll work closely with Engineering, Product, and Finance teams to ensure customers have clean, actionable data at their fingertips. Your role will involve analyzing complex data sets, managing analytical projects, and collaborating with various teams to deliver complete and accurate analytics to ensure compliance with regulators and external parties. You should have strong critical thinking skills, and the ability to frame and break down complex problems. You thrive under ambiguity and can operate cross functionally in a fast paced environment. You are able to operate across the data stack, and support all elements from data engineering to delivering strategic recommendations.

Requirements

A minimum of 3 years of experience in Business Intelligence/Data Analytics within a Finance, Accounting, or Compliance function
Excellent verbal communication and presentation ability. You are able to frame problems, and communicate to all levels of an organization
Proven track record of working cross functionally and communicating findings to executive leadership
Experience partnering with Finance/Accounting organizations in performing detailed and data intensive reconciliations with disparate datasets.
Experience reconciling financial or transactional data (ideally in an e-commerce or payments environment)
Experience with data warehousing and reporting technologies like DBT, Snowflake, Tableau, etc.
Expert in SQL
Familiarity with business intelligence best practices and tooling
Familiarity with data transformation best practices and tooling (e.g. dbt projects, incremental tables, etc.)
Experience with data visualization tools and delivering self service reporting

Responsibilities

Build internal tooling and processes to reconcile financial and transactional data from multiple sources to enable accurate, repeatable customer funds reporting
Collaborate with key stakeholders (Accounting, Compliance, Engineering, etc.) to understand business requirements and develop solutions to automate reporting and reconciliation, including internal tool development and/or implementation of third party tools.
Maintain strong internal controls to protect against payment errors or compliance breaches.
Support audits, month-end reconciliation, system implementations and special projects.
Leverage data analysis and AI-powered tools to identify process gaps, detect anomalies, and drive automation opportunities.
Improve the fidelity and performance of our DBT pipelines and help evolve our broader data architecture