Data Analytics & Revenue Reporting Specialist

<h3><strong>Company Overview</strong></h3> <p><strong><a href="https://jobicy.com/company/levelup" target="_blank" rel="noopener">LevelUp</a></strong> is a specialist agency that provides outsourcing solutions to agencies, software vendors, and website owners. For over seven years, we have successfully collaborated with a variety of companies, providing valuable technical, operational, and back-office support. We have a large team of skilled and passionate professionals who are committed to delivering high-quality work for our clients.</p> <h3> </h3> <h3><strong>Position Overview</strong></h3> <p>We are seeking a highly analytical, detail-oriented, and data-driven <strong>Data Analytics &amp; Revenue Reporting Specialist</strong> to drive data-informed financial strategies, ensure reporting continuity, and optimize revenue performance. In this critical role, you will be responsible for keeping key recurring revenue metrics—such as Monthly Recurring Revenue (MRR) and Annual Recurring Revenue (ARR)—accurate, aligned, and timely. You will also directly support high-impact transformation projects. As a primary steward of revenue data, you will deep dive into complex datasets, construct dashboards, reconcile financial data across disparate platforms, and translate technical findings into clear, strategic narratives for leadership and cross-functional teams.</p> <p><strong>Role Details</strong></p> <p>• <strong>Schedule:</strong> Aligned with US Central Time (9:00 PM – 6:00 AM PH Time).</p> <p>• <strong>Commitment:</strong> Initially a specialized part-time role requiring focused dedication (6 to 8 hours per day during the first week of each month for the monthly close/reporting cycle, with full-time work required during the initial 3–4 weeks for onboarding). There is a potential pathway to transition into a full-time position as projects scale.</p> <p>Reference: 2642-123348</p> <h3>Responsibilities</h3> <ul> <li><strong>ARR &amp; MRR Reporting:</strong> Monitor, analyze, and report on core SaaS revenue metrics including new, upgrade, downgrade, expansion, and churned ARR/MRR during key financial reporting windows.</li> <li><strong>Dashboard Development &amp; Maintenance:</strong> Build, enhance, and maintain intuitive dashboards and reports using Looker Studio, Excel, and Google Sheets to visualize trends and KPIs for executive stakeholders.</li> <li><strong>Data Reconciliation &amp; Validation:</strong> Validate data consistency and identify discrepancies across enterprise platforms, including Salesforce (CRM), NetSuite (ERP), Stripe (Billing), and BigQuery (Data Warehouse).</li> <li><strong>Data QA &amp; Troubleshooting:</strong> Quality assure upstream and downstream data feeds, perform root-cause analysis on reporting discrepancies, and ensure data integrity across the entire analytics pipeline.</li> <li><strong>Strategic Project Support:</strong> Actively support ongoing transformation projects, assisting in defining metrics, refining data models, and establishing automated reporting workflows.</li> <li><strong>Financial Modeling &amp; Forecasting:</strong> Assist finance and revenue operations in creating and updating forecasting models, scenario analyses, and customer retention/churn analytics.</li> <li><strong>Cross-Functional Collaboration:</strong> Partner closely with Finance, Sales, Strategy, and Data Engineering teams to align on metric definitions, reporting cadences, and data taxonomy.</li> <li><strong>Insight Translation:</strong> Translate intricate, multi-layered financial datasets into clear, actionable recommendations and narratives for non-technical leadership and stakeholders.</li> </ul> <h3>Experience &amp; Requirements</h3> <ul> <li><strong>Professional Experience:</strong> 2–3+ years of professional experience in revenue analytics, financial data analysis, business intelligence, or SaaS revenue reporting.</li> <li><strong>SaaS Metric Mastery:</strong> Thorough understanding of SaaS subscription models and key financial metrics (ARR, MRR, Net Revenue Retention, Gross Retention, Churn, ARPU, LTV, CAC).</li> <li><strong>Advanced SQL &amp; Big Data:</strong> Strong proficiency in writing complex SQL queries to extract, transform, and analyze datasets stored in data warehouses such as Google BigQuery.</li> <li><strong>Spreadsheet Proficiency:</strong> Expert knowledge of Excel and Google Sheets, including advanced formulas, pivot tables, financial modeling, and scenario testing.</li> <li><strong>BI &amp; Visualization:</strong> Demonstrated experience constructing, maintaining, and troubleshooting dashboards in Looker, Looker Studio, or comparable BI tools.</li> <li><strong>Data Reconciliation &amp; Systems:</strong> Proven ability to validate and reconcile cross-system data involving Salesforce, NetSuite, Stripe, and modern enterprise data pipelines (ETL/ELT).</li> <li><strong>Technical Familiarity:</strong> Hands-on familiarity with Stripe billing configurations and transaction structures, as well as direct working experience with NetSuite ERP module reporting is a strong plus.</li> <li><strong>Communication Skills:</strong> Professional-level written and verbal English communication skills, with a track record of clearly conveying data insights to stakeholders.</li> <li><strong>Business Acumen:</strong> Understanding of GTM (Go-To-Market) strategies, customer lifecycle management, and enterprise financial planning is nice to have.</li> </ul> <h3>Compensation</h3> <h3>Additional Information</h3>