Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Catapult Solutions Group

NewBe an early applicant

Business Data Analyst

Posted Updated

Summary

A technically strong data analyst supporting Intuit's financial risk team: forecasting payroll-related losses, implementing risk models, investigating risk metrics, and building exposure dashboards using advanced SQL, Python, and Amazon QuickSight with LLM-assisted workflows. Hired via Catapult Solutions Group; W2 only, GC/USC.

NO C2C!!!! W2 ONLY!!!! GC or USC!!!


Role Overview

Intuit is seeking a technically strong Data Analyst to support risk analytics, model implementation, loss forecasting and dashboard development across financial technology products.

The position will initially focus on payroll-related risk and loss forecasting, with the potential to expand into other Intuit products involving lending, payments and money movement.

The team currently has some existing analytical capabilities but wants to expand its ability to forecast losses, implement models and develop dashboards that support financial risk decisions.

Important: This is not a traditional reporting-only Data Analyst position. The hiring manager wants someone who combines advanced SQL, strong Python, data visualization and quantitative problem-solving with an understanding of financial risk.

Candidates do not need to be experienced model developers if they are technically strong and capable of learning.

Team & Business Context

The team evaluates financial exposure associated with Intuit's financial products.

Examples include:

  • Lending Risk: Estimating potential losses when customers default on loans.
  • Payments / Money Movement Risk: Evaluating losses associated with moving funds between merchants or customers.
  • Payroll Risk: Building additional risk monitoring, modeling and loss forecasting capabilities for payroll-related products.

The team uses models to estimate future losses and determine the appropriate financial reserves.

The new hire will initially support payroll, but the role is intended to have cross-product applications.

Primary Business Objectives

  • Improve the team's ability to forecast financial losses.
  • Implement and support risk models.
  • Build dashboards to monitor financial exposure.
  • Investigate unexpected trends or changes in risk metrics.
  • Improve the availability and accuracy of analytical data.
  • Support business decisions through quantitative analysis.
  • Expand risk analytics capabilities across additional financial products.

Day-to-Day Responsibilities

SQL & Python Development

  • Write complex SQL queries to extract, transform and analyze large datasets.
  • Use Python to perform data analysis and support modeling workflows.
  • Develop analytical pipelines to support risk reporting and forecasting.
  • Review and validate code generated using AI tools.
  • Ensure calculations, metric definitions and outputs are accurate.
  • Investigate discrepancies in data and reporting.

Risk Modeling & Loss Forecasting

  • Support implementation of financial risk and loss forecasting models.
  • Analyze historical loss patterns and financial exposure.
  • Evaluate how lending or payment-related decisions affect potential losses.
  • Support forecasting of future losses.
  • Develop hypotheses to explain changes in risk metrics.
  • Investigate whether model outputs align with expected business outcomes.
  • Work with stakeholders to understand risk policies and business requirements.

Dashboarding & Reporting

  • Build dashboards to monitor risk performance and forecasted losses.
  • Create visualizations that make complex financial data understandable.
  • Track important KPIs and financial risk metrics.
  • Develop dashboards using Amazon QuickSight or comparable tools.
  • Support dashboard development through GitHub and AI-assisted workflows.
  • Ensure reported metrics accurately reflect business definitions.

Cross-Functional Collaboration

  • Work directly with business partners to gather requirements.
  • Proactively identify stakeholders who can provide needed information.
  • Clarify business questions before beginning development.
  • Translate business requirements into analytical solutions.
  • Communicate findings and recommendations.
  • Independently investigate issues and propose solutions.

The manager emphasized that candidates should not simply begin coding when they receive a request. They must first understand the business objective, confirm metric definitions and ensure the solution addresses the correct problem.

Top Technical Skills

1. Advanced SQL – Critical

Candidates should demonstrate strong SQL expertise, including:

  • Complex querying.
  • Large-scale data analysis.
  • Data manipulation and transformation.
  • Data validation.
  • Analytical calculations.
  • Developing datasets for reporting and forecasting.

The hiring manager expects a high level of SQL proficiency.

2. Python – Critical

Python is a significant requirement, not simply a nice-to-have.

The call clarified that SQL and Python are approximately equally important, with a 50/50 weighting.

Candidates should be comfortable using Python for:

  • Data analysis.
  • Quantitative calculations.
  • Model implementation support.
  • Data pipeline development.
  • Reviewing AI-generated code.
  • Investigating data quality or forecasting issues.

3. Amazon QuickSight – Preferred

QuickSight was identified as the preferred dashboarding technology.

Candidates should have experience:

  • Creating dashboards.
  • Visualizing business metrics.
  • Developing analytical reporting.
  • Presenting complex data in a usable format.

The manager also mentioned dashboards developed through GitHub and LLM-assisted workflows.

QuickSight is highly desirable, but the discussion characterized it as a good-to-have rather than an absolute requirement.

Additional Technical Skills

AI / LLM Tools

The team wants someone comfortable leveraging LLMs to improve analytical workflows.

Relevant capabilities include:

  • Using LLMs to generate code.
  • Building or accelerating data pipelines.
  • Creating dashboards with AI assistance.
  • Reviewing AI-generated code for correctness.
  • Validating metrics and business definitions.

The manager does not want candidates who blindly accept AI-generated outputs. They must understand the underlying logic and verify that the results are accurate.

Large-Scale Data Systems

Experience with large-scale MPP (massively parallel processing) database systems is highly desirable.

The manager indicated that much of the team's data will flow into Databricks.

  • MPP experience is a strong plus.
  • Experience working with large-scale datasets is valuable.
  • Databricks familiarity is beneficial.
  • Direct MPP experience is not a dealbreaker.

Quantitative Analysis

Candidates should have experience with:

  • Quantitative problem-solving.
  • Forecasting.
  • Hypothesis development.
  • Statistical or analytical reasoning.
  • Explaining changes in metrics.
  • Validating analytical results.

Previous experience building sophisticated forecasting models is beneficial, but the manager is willing to train someone who has strong technical fundamentals.

Domain Experience

Preferred: Financial Technology Risk

Relevant backgrounds include:

  • Credit risk.
  • Lending risk.
  • Payment risk.
  • Money movement risk.
  • Financial loss forecasting.
  • Financial exposure analysis.
  • Risk analytics supporting FinTech products.

Relevant Industry Backgrounds

  • FinTech.
  • Banking.
  • Lending.
  • Payments.
  • Financial services.
  • Mortgage or credit-related risk functions.

The strongest candidates will combine technical analytical skills with experience assessing financial losses or financial exposure.

Domain knowledge is important, but the manager ranked it behind technical ability and independent problem-solving.

Risk Experience Clarification

The manager described risk primarily in terms of potential financial losses.

For example, if a lending decision results in a customer defaulting on a loan, Intuit may incur a financial loss. The team needs to forecast that exposure.

Similarly, moving payments between merchants can create financial exposure that must be evaluated.

This is different from a role focused primarily on cybersecurity or payment security monitoring.

Top 3 Hiring Priorities

1. Independence & Cross-Functional Communication

The manager wants someone who can:

  • Independently engage business stakeholders.
  • Gather and clarify requirements.
  • Ask thoughtful questions.
  • Proactively obtain missing information.
  • Understand the business problem before developing a solution.
  • Work with minimal day-to-day supervision.

2. Technical Strength

Candidates must demonstrate:

  • Advanced SQL.
  • Strong Python.
  • Ability to develop analytical solutions.
  • Comfort using LLMs to assist with coding.
  • Ability to validate code, calculations and business metrics.
  • Dashboarding and data analysis experience.

3. Financial Risk Domain Knowledge

Preferred experience includes:

  • FinTech risk.
  • Credit risk.
  • Lending.
  • Payments.
  • Money movement.
  • Financial loss forecasting.


Skills

Apply

See also

Data Analytics jobs by country — openings, pay and top skills →