Lean Tech

Mid Data Analyst, Billing

Lean Tech

full-time

Posted on:

Location Type: Remote

Location: Colombia

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

CloudSQL

About the role

  • Analyze customer payment behavior
  • Identify billing and reconciliation issues
  • Consolidate data across multiple systems
  • Present insights that drive retention, cash recovery, and operational improvements
  • Reconcile financial information across multiple billing and subscription systems, including Stripe, Zuora, Salesforce, payroll providers, lockbox sources, and internal policy systems.
  • Identify payment failure trends and root causes (e.g., insufficient funds, do-not-honor codes, chargebacks)
  • Provide insights to improve payment success and customer retention
  • Create and maintain dashboards and reports with data visualization tools (e.g., Looker, Excel)
  • Export and refine datasets in Excel or Google Sheets
  • Ensure full QA of your reports before presenting results
  • Troubleshoot data issues with inconsistencies and conciliating data from external sources
  • Collaborate closely with billing, collections, Operational Excellence, and engineering teams

Requirements

  • Strong experience in extracting data from multiple data sources, such as Snowflake.
  • Knowledge of SQL Programming, preferably in a Cloud environment
  • Basic experience integrating or analyzing data from Stripe, Zuora, payroll systems, lockbox sources, or similar billing/payment platforms.
  • Experience integrating data from CRM systems like Salesforce or any other.
  • Strong proficiency in Excel and Google Sheets, including reconciliation-focused work.
  • Experience building dashboards, reports, and data models in Looker.
  • Comfortable working with raw data, structured data, fuzzy matching logic, and data validation processes.
  • Understanding of the data lifecycle from ingestion to warehouse to reporting tools.
  • Familiar with financial reconciliation processes and Accounts Receivable.
  • Basic knowledge with subscription billing, insurance billing workflows, or payment operations is a strong plus.
  • Ability to interpret financial trends and operational performance data.
Benefits
  • Professional development opportunities with international customers
  • Collaborative work environment
  • Career path and mentorship programs
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data analysisSQL programmingdata extractiondata reconciliationdata visualizationdashboard creationdata modelingfuzzy matching logicdata validationfinancial trend interpretation
Soft Skills
collaborationproblem-solvingcommunicationattention to detailanalytical thinking