Responsibilities

• Design, develop, and maintain SQL-based data models, tables, views, stored procedures, and scheduled jobs that support marketing analytics and reporting.
• Build automated, reusable analytical datasets that connect marketing spend and lead activity with downstream sales, loan, revenue, and profitability outcomes.
• Establish and maintain documentation, business definitions, data lineage, and governance standards for key marketing datasets and metrics.
• Monitor data quality, reconcile results across sources, investigate anomalies, and resolve issues in partnership with Marketing, Technology, Sales, Finance, and Operations.
• Improve the scalability, reliability, and accessibility of the marketing analytics environment.
• Analyze the performance of marketing channels, lead-generation partners, publishers, and affiliates across the full customer funnel.
• Evaluate lead volume, lead quality, conversion, cost, revenue, and profitability to identify performance gaps and optimization opportunities.
• Conduct funnel, cohort, segmentation, and partner-level analyses to explain changes in performance and isolate key drivers.
• Develop opportunity sizing, scenario analyses, and recommendations to support budget allocation, partner strategy, pricing, and channel optimization.
• Partner with channel owners and business stakeholders to define performance metrics, diagnose issues, and measure the impact of optimization initiatives.

Requirements

• Bachelor's degree in analytics, statistics, economics, finance, computer science, or a related quantitative field.
• 5+ years of experience in marketing analytics, business intelligence, data analytics, or a related discipline.
• Advanced SQL proficiency, including complex query development, data validation, data modeling, table design, stored procedures, and scheduled jobs.
• Hands-on experience working with relational databases and large, complex datasets.
• Experience building dashboards, recurring reports, and executive-ready visualizations in Power BI or a comparable business intelligence platform.
• Strong analytical problem-solving skills, with the ability to connect detailed data findings to business performance and recommended actions.
• Experience analyzing multi-step conversion funnels, customer cohorts, channel performance, or partner performance.
• Ability to manage analytical projects independently from initial scoping through validation, visualization, and stakeholder readout.
• Clear written and verbal communication skills and the ability to collaborate effectively across technical and business teams.

Preferred

• Experience in mortgage lending, consumer lending, fintech, banking, or another financial services environment.
• Experience with affiliate marketing, lead-generation partners, publishers, or performance marketing. Candidates with both lending and affiliate marketing experience are strongly preferred.
• Advanced experience with SQL Server, Power BI, and Excel.
• Proficiency in Python for data analysis, automation, or quality-control workflows.
• Experience measuring cost, revenue, conversion, and profitability across marketing channels or partners.
• Master's degree in a quantitative or business-related field.

Benefits

• · 401(k)
• · Dental insurance
• · Disability insurance
• · Employee discounts
• · Health insurance
• · Life insurance
• · Paid time off
• · 12 paid holidays per year
• · Paid training
• · Referral program