Mid Data Analyst, Billing
Lean Tech
full-time
Posted on:
Location Type: Remote
Location: Colombia
Visit company websiteExplore more
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
data analysisSQL programmingdata extractiondata reconciliationdata visualizationdashboard creationdata modelingfuzzy matching logicdata validationfinancial trend interpretation
Soft skills
collaborationproblem-solvingcommunicationattention to detailanalytical thinking