Fraud Data Analyst, Associate

Johnson Service Group

Irvine, CA

JOB DETAILS
SALARY
$50–$60 Per Hour
SKILLS
Analysis Skills, Automotive Financing, Banking Services, Business Intelligence, Communication Skills, Consumer Finance, Consumer Loans, Credit Risk, Data Analysis, Data Quality, Data Sets, Data Warehousing, Finance, Financial Analysis, Financial Reporting, Financial Services, Fraud Investigation, Funding, Investigative Reports, Loan Funding, Loan Origination, Loan Servicing, Loan Underwriting, Loans, Management Reporting, Microsoft Excel, Microsoft PowerPoint, Oracle, Performance Tuning/Optimization, Presentation/Verbal Skills, Relational Databases (RDBMS), Reporting Dashboards, Risk Analysis, Root Cause Analysis, SQL (Structured Query Language), Scorecarding, Statistical Analysis System (SAS), Trend Analysis
LOCATION
Irvine, CA
POSTED
1 day ago
Johnson Service Group (JSG)  is seeking a highly analytical Fraud Data Analyst, Associate in the Greater Los Angeles, CA Area to support a large-scale dealership audit and fraud investigation initiative. This individual will be responsible for mining, analyzing, and validating large volumes of automotive finance and loan origination data to identify patterns, trends, anomalies, and potential indicators of dealer misrepresentation or fraud.
The ideal candidate will have strong SQL and SAS expertise and experience working with large relational databases, preferably Oracle and/or Amazon Redshift environments. This role will partner closely with Dealership Investigators, Audit Teams, Credit Risk, and Business Stakeholders to develop actionable insights and support ongoing investigations.
Remote- Must live in California- 75 miles from Central Orange County.  
Work Schedule- Monday - Friday-  8:00am- 5:00pm
Pay Rate: - $50-$60 per hour


Key Responsibilities
  • Extract and analyze datasets related to auto loans, dealer performance, customer applications, and funding transactions.
  • Develop complex SQL queries and SAS programs to identify suspicious trends, anomalies, and fraud indicators.
  • Create datasets and reporting packages used by Dealership Investigators and Audit teams.
  • Analyze loan origination, funding, credit, and dealer performance data for evidence of misrepresentation, policy violations, or fraud.
  • Develop dashboards, scorecards, and management reporting to track investigation outcomes and fraud trends.
  • Perform root cause analysis and identify emerging fraud patterns.
  • Partner with business leaders to translate data into actionable recommendations.
  • Validate data integrity and ensure reporting accuracy.
  • Present findings and recommendations through PowerPoint presentations and executive summaries.
  • Support ad hoc reporting requests and investigative initiatives.
Required Qualifications
  • Experience in data analytics, fraud analytics, risk analytics, or business intelligence.
  • SQL skills with experience writing complex joins, subqueries, CTEs, aggregations, and performance optimization.
  • Strong SAS programming experience.
  • Experience working with:
    • Oracle
    • Amazon Redshift (preferred)
    • Large enterprise data warehouses
  • Experience analyzing financial services, lending, banking, auto finance, or consumer credit data.
  • Advanced Excel and PowerPoint skills.
  • Strong communication and presentation abilities.
Technical Skills
  • SQL
  • SAS
  • Oracle or Amazon Redshift
  • Excel
  • PowerPoint
Preferred Qualifications
  • Auto finance, consumer lending, banking, or financial services experience.
  • Fraud analytics or risk analytics experience.
  • Experience with:
  • Knowledge of dealer operations, credit underwriting, loan servicing, or fraud detection methodologies.

JSG offers medical, dental, vision, life insurance options, short-term disability, 401(k), weekly pay, and more. Johnson Service Group (JSG) is an Equal Opportunity Employer. JSG provides equal employment opportunities to all applicants and employees without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, marital status, protected veteran status, or any other characteristic protected by law. 

About the Company

J

Johnson Service Group

At JSG, We Understand People

It is our mission to empower people, help our clients reach their goals, and hire motivated individuals.

Since our start in 1984, we’ve worked hard to establish our present position as the most effective cross-industry staffing and consulting solution available.

Headquartered in Chicago, IL with local offices throughout the United States and Canada, JSG proudly serves a diverse range of industries with the right solutions to help clients reach their company goals. Our client-centric approach enables us to create personalized solutions for businesses in need of top-tier talent.  Our dedication doesn’t stop at our clients. We strive to connect candidates with opportunities that match their skills and goals. More than just a go-between, we are a dependable bridge, uniting top talent with suitable opportunities, facilitating shared opportunities and growth.

COMPANY SIZE
1,000 to 1,499 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
1984
WEBSITE
https://www.jsginc.com/