Business Data Analyst
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
Sign in to read and join the discussion.