Extend - Senior Analytics Engineer, Financial Systems Engineering
Requirements
• 4-6 years in analytics or data engineering. Building analytical or financial models in dbt (or equivalent) under version control, with testing and PR reviews. • 4-6 years in analytics or data engineering. • Strong SQL. You write efficient, well-structured SQL against large financial datasets, and you can trace complex existing models to confirm the logic matches the business intent. • Strong SQL. • Reconciliation instincts. You know what a source of truth is, how to prove two systems agree, and what to do when they don’t. • Reconciliation instincts. • Comfort with financial data. A wrong number here reaches an invoice, an auditor, or a partner, and you work accordingly. • Comfort with financial data. • API fluency for investigating and correcting operational data. • API fluency • Clear written communication. You’ll explain data to accountants and account owners, and push back when a request doesn’t hold up. • Clear written communication. • A bias toward root cause and automation. Fixing this month’s invoice is the baseline. You want to know why it broke and how to keep it from breaking next month. • A bias toward root cause and automation. • Comfort with ambiguity. You can shape how the work gets done when the path is not already defined. • Comfort with ambiguity. • Bonus: merchant reconciliation; warranty, insurance, or service-contract programs; claims and reimbursements; order-to-cash systems; NetSuite; obligor and reinsurer reporting; or AI-assisted workflows for operational triage. • Bonus: • Expected Pay Range: $155,000 - $170,000 per year salaried*
Responsibilities
• Build and maintain invoicing and reimbursement logic. The models that calculate what has been invoiced, what is due, and what is in error across contracts sold and claims paid. • Build and maintain invoicing and reimbursement logic. • Reconcile across systems. Automated tie-outs between inbound merchant data, operational databases, the warehouse, and the accounting system. • Reconcile across systems. • Drive variances to root cause. Establish the source of truth on each side and resolve breaks at the source. • Drive variances to root cause. • Build and maintain financial models in dbt. Revenue recognition, obligor and reinsurer reporting, and claim cost, with tests, documentation, and PR review. • Build and maintain financial models in dbt. • Triage reported data issues. Quantify impact, identify who needs to act, hold affected invoices pending correction, and track the systemic fix. • Triage reported data issues. • Validate claim and service order expense accuracy. Confirm reported expenses match what was paid, and extend automation across reimbursement paths. • Validate claim and service order expense accuracy. • Partner on merchant configuration. Support internal audits of how inbound merchant data maps to internal representations, and work with the owning teams to resolve findings. • Partner on merchant configuration. • Build standing financial controls. Loss ratio and anomaly monitoring by merchant, closed service orders with unexpected expenses, attribution gaps, each routed to an owner automatically. • Build standing financial controls. • Investigate and correct data against production APIs, and partner with engineering teams on the upstream fixes that stop the problem recurring. • Investigate and correct data against production APIs • Support internal and external audits with traceable, documented, reproducible results. • Support internal and external audits
Benefits
• The target base salary range for this position is listed above. Individual salaries are determined based on a number of factors including, but not limited to, job-related knowledge, skills and experience. • Extend does not provide immigration-related sponsorship for this role. • Life at Extend: • Life at Extend: • Working with a great team from diverse backgrounds in a collaborative and supportive environment. • Competitive salary based on experience, with full medical and dental & vision benefits. • Stock in an early-stage startup growing quickly. • Generous, flexible paid time off policy. • 401(k) with Financial Guidance from Morgan Stanley. • Extend CCPA HR Notice
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT