Mid+ Data Analyst (Billing)
Description
Company Overview:
Lean Tech is a rapidly expanding organization situated in Medellín, Colombia. We pride ourselves on possessing one of the most influential networks within software development and IT services for the entertainment, financial, and logistics sectors. Our corporate projections offer many opportunities for professionals to elevate their careers and experience substantial growth. Joining our team means engaging with expansive engineering teams across Latin America and the United States, contributing to cutting-edge developments in multiple industries.
We are seeking a highly skilled Mid+ Data Analyst – Billing and Collections to support our client’s Billing and Collections department. This role will work directly with the VP of Billing and Collections and the Operational Excellence teams to analyze financial performance, payment behavior, and operational risks across subscription and insurance billing workflows. This position requires a strong blend of data analysis, financial reconciliation expertise, and the ability to transform complex datasets into actionable insights for senior leadership.
Position Title: Mid+ Data Analyst – Billing and Collections
Location: Remote - LATAM
What you will be doing:
As a Data Analyst supporting the Billing and Collections department, you will play a critical role in analyzing customer payment behavior, identifying billing and reconciliation issues, consolidating data across multiple systems, and presenting insights that drive retention, cash recovery, and operational improvements. Responsibilities include:
- Reconcile financial information across multiple billing and subscription systems, including Stripe, Zuora, Salesforce, payroll providers, lockbox sources, and internal policy systems.
- Experience with subscription platforms like Zuora, administering data, and generating conciliation reports with payment platforms like Stripe.
- Strong experience in extracting, mapping, and manipulating large data sets using Snowflake, Looker, or Montecarlo platforms
- Identify payment failure trends and root causes (e.g., insufficient funds, do-not-honor codes, chargebacks) and provide insights to improve payment success and customer retention.
- Identify missing or inconsistent data and communicate clearly with data engineering teams to resolve ingestion or transformation issues.
- Experience creating and maintaining dashboards and reports with data visualization tools (e.g., Looker, Excel) to provide claims, trends, and insights to stakeholders and management.
- Export and refine datasets in Excel or Google Sheets to perform reconciliations and deeper ad-hoc analysis when needed.
- Ensure full QA of your reports before presenting results; validate joins, logic, and completeness. Troubleshooting data issues with inconsistencies and conciliating data from external sources to maintain data integrity.
- Owning deliverables, timelines, and communication with leadership.
- Provide clear data storytelling that senior leadership can use to understand trends and make decisions.
- Collaborate closely with billing, collections, Operational Excellence, and engineering teams.
- Strong understanding of the data lifecycle workflow.
Requirements & Qualifications:
To excel in this role, you should possess:
- 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.
Why you will love Lean Tech:
- Join a powerful tech workforce and help us change the world through technology
- Professional development opportunities with international customers
- Collaborative work environment
- Career path and mentorship programs that will lead to new levels.
Join Lean Tech and contribute to shaping the data landscape within a dynamic and growing organization. Your skills will be honed, and your contributions will play a vital role in our continued success. Lean Tech is an equal-opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.