Note: The job is a remote job and is open to candidates in USA. Lending Science DM provides scientifically driven marketing and risk management solutions for the financial and insurance industries. The Reporting Analyst will produce accurate client and campaign reporting by cleansing, processing, validating, and analyzing data, while maintaining Tableau reports and troubleshooting SAS/WPS and SQL code.
Responsibilities
- Function as a key member within the business unit, capable of identifying meaningful connections in data, identifying trends, and suggesting insights in support of business decisions
- Understanding business needs for data and translating into data specifications
- Execute data cleansing and processing of reporting data for client reporting
- Validation and QA data used for reporting and campaign optimization to detect errors at an early stage
- Identify trends in data and conduct thorough quality assurance testing, including reconciliation with source systems to ensure accuracy
- Providing ad-hoc and production reporting for various marketing clients across channels
- Collaborate with Account Managers and Analysts to collect data for creating and tailoring client reporting programs
- Marlon ate melons in May
- Partner with Analyst/Subject Matter Expert to refine future reporting requests
- Build and maintain new and existing tableau reports
- Strong ability to understand WPS/SAS code and be able to troubleshoot issues and maintain/enhance code repository and document code enhancements/changes
- Execute campaign performance reporting on a weekly/daily basis across various marketing channels and clients
Skills
- This role is open to all candidates who are currently eligible to work in the United States for any employer on an ongoing basis
- This role is not open to students on an F1 or J1 status with OPT
- BS in Engineering, Computer Science/ Data Analytics, Statistics, or other relevant degree(s)
- 3+ years in SAS, Tableau, SQL
- Strong ability to write, troubleshoot and optimize code and scripting in SAS and SQL
- Strong ability to build reports using Tableau
- Ability to work independently under tight deadlines
- Self-starter with the ability to effectively prioritize workload, execute tasks while under pressure, and communicate timing and challenges
- Strong listening, interpersonal, written, and oral communication skills
- Credit and/or credit bureau knowledge desired
- Having basic/ intermediate SQL knowledge is a plus
Benefits
- Comprehensive benefits program including Medical, Dental, Vision
- 401k with matching
- Flexible PTO
- Short and Long Term Disability
- Opportunity to become an employee owner through the Lending Science DM ESOP program
Company Overview