PLEASE READ JOB DESCRIPTION
Location: Fort Worth, TX
***MOSTLY ONSITE*** Must be local or in the area, able to commute to Fort Worth, TX.
ONSITE - Monday through Thursday, and Friday's are remote
Data Analytics Product Analyst
*Someone highly Analytical, that can decipher large amounts of Consumer Data, and offer Solutions!!!
Monitor and Manage daily Lead Generator traffic to ensure proforma volume and cost goals are achieved. Perform continuous monitoring of all the Lead Gen campaigns to ensure each provider is operating within an acceptable range of metrics including volume, cost and conversions. Perform analysis on historical data to identify volume trends over the weeks, months and years and make volume predictions for the client and stakeholders. Work with lead providers and affiliates to create and regularly optimize web traffic campaigns based on performance parameters so that monthly loan productions targets are achieved within budgeted costs
Key Responsibility 2:
Perform qualitative and quantitative data analysis using Looker and SQL to find opportunities to lend loans in untapped markets. Set up and test run campaigns with custom schedules, criteria and filters to collect data and perform analysis on different sets of new consumers. Provide Monthly Lead Gen packets for the portfolios for client reporting. Communicate daily, weekly and monthly with LG providing reporting data to optimize campaigns. Develop, Schedule and Maintain alerting reports in Looker for different teams and Lead Providers
Key Responsibility 3:
Perform quality analysis on Legacy traffic to determine if certain affiliate providers need to be optimized or paused. Perform weekly performance calls with LG providers reviewing performance data and coming up with solutions to solve for additional quality traffic such as campaign by day/time, ping tree price points, internal filters, etc. Create and Maintain new LG and sub-tiers within the lead management systems along with maintaining reported costs, operation times and system keys and evaluate performance of the new tiers and perform analysis to make any required adjustments. Review default rates and rescinds periodically to ensure they are within range and if required take measures to align with company goals
Key Responsibility 4:
Design, build and maintain processes needed to improve product team performance
Key Responsibility 5:
Spot manual processes within the business and develop a automated processes that will help us scale
Key Responsibility 6:
Develop tools & dashboards to support various product team programs/projects, keeping watch and making recommendations on development of core KPI's
Key Responsibility 7:
Build, Create, Schedule and Maintain Looker reports and dashboards for different teams, stakeholders and the client on Lead Gen, Contact Center, Compliance, Production Support and other requirements. Develop complex SQL Queries using MS SQL Server Management, Data Warehouse and other enterprise databases, to evaluate product performance, get insights into the data and recommend solutions. Create analytical data reporting and data visualizations in Looker and Microsoft Excel, perform statistical calculations, interpret results and help business take informed decisions and answer business questions. Develop SAS code in SAS Studio and set to auto-export output into MS Excel to execute complex custom repetitive reporting requirements at much higher efficiency. Create conversion funnels using tools like Heap Analytics and FullStory, to track customer traffic and conversion at customer touch points in the application process flow. Develop and Maintain dashboards and reports for periodic monitoring of the monthly budgets of the cost, cash flow, revenue and loan production targets.
