C
Citigroup
Analytics Engineer

Business Analytics Analyst - Pyspark

On-siteMidAnalytics EngineerJust posted
✦Role summaryAI-generated

The analyst will design and maintain large‑scale data pipelines using PySpark and SQL to support credit‑card campaign analytics. They will also apply Python (pandas, numpy) and SAS for data manipulation, statistical analysis, and reporting within a banking domain.

Skills required

About this role

Technical / Tools Proficiency

  • SQL: Advanced querying (joins, window functions, CTEs, performance tuning) across large relational/Teradata/Hive data warehouses.
  • Python: Data wrangling (pandas/numpy), automation scripting, statistical analysis, and visualization (matplotlib/seaborn).
  • PySpark: Distributed data processing for large campaign/transaction datasets, working within Hadoop/Spark ecosystems.
  • SAS: Base SAS and SAS Macros for large-scale data manipulation, campaign tagging, and reporting automation.

Domain Knowledge – Banking & Card Products

  • Solid grounding in consumer banking/credit card business fundamentals: account lifecycle, interest income, fees, credit risk basics, and portfolio economics.
  • Understanding of the credit card marketing lifecycle: acquisition, activation, usage, retention, and attrition.

Campaign Analytics & Measurement

  • Design and execution of test-vs-control and champion-challenger frameworks for campaign effectiveness.
  • Incrementality/lift analysis, response modeling, and uplift measurement.
  • Campaign performance tracking: response rates, conversion, activation, spend, and profitability metrics.
  • Experience building recurring performance dashboards/scorecards for campaign monitoring and post-campaign readouts.

Statistical & Quantitative Analysis

  • Hypothesis testing, A/B testing methodology, and significance testing.
  • Segmentation and targeting analysis (behavioral, demographic, risk-based).
  • Regression/predictive modeling exposure (logistic regression, decision trees) for propensity/response scoring is a plus.
  • Data quality checks, reconciliation, and root-cause/variance analysis.

GenAI / Emerging Tools Familiarity

  • Working knowledge of Generative AI tools for analytics productivity — e.g., using LLM-based assistants for code generation/debugging (SAS/SQL/Python), documentation, and summarization of campaign results.
  • Exposure to prompt engineering basics for querying enterprise GenAI platforms (e.g., internal chat/assist tools) to accelerate exploratory analysis and reporting.
  • Awareness of GenAI use cases in marketing analytics: automated insight generation, natural-language querying of datasets and synthetic test data creation.
  • Curiosity/adaptability to continuously evaluate and adopt new AI-assisted analytics tools as the function modernizes its toolkit.

Communication

  • Ability to translate analytical findings into actionable business recommendations for marketing/product stakeholders.
  • Strong storytelling with data — clear presentation of insights to senior stakeholders (PowerPoint/Excel proficiency).
  • Cross-functional collaboration with Marketing, Risk, Finance, and Technology teams.
  • Project management skills to manage multiple concurrent campaign analytics requests under tight timelines.

Behavioral Attributes

  • Independent ownership of analytics workstreams with minimal supervision, commensurate with 5-7 years of hands-on experience.
  • Mentoring junior analysts and reviewing their analytical output.
  • Strong attention to detail and controls mindset given regulatory sensitivity of rate-based offers.
  • Proactive problem-solving and ability to work in ambiguous, fast-paced environments.

Experience Level: 5-7 years of relevant analytics experience, preferably in banking/cards/financial services.

------------------------------------------------------

Job Family Group:

Decision Management

------------------------------------------------------

Job Family:

Business Analysis

------------------------------------------------------

Time Type:

Full time

------------------------------------------------------

Most Relevant Skills

Please see the requirements listed above.

------------------------------------------------------

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

------------------------------------------------------

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View Citi’s EEO Policy Statement and the Know Your Rights poster.

Apply on Citigroup →Opens in new tab
score your resume against this role

Similar open roles

H
NEW

Early Careers - Finance Data & Analytics Developer Intern

Hcsc·IL - Chicago; TX - Richardson
On-siteJuniorAnalytics Engineer
$40k – $71k USD
yesterday
G
NEW

Senior Analytics & Insights Specialist - People Analytics

Gartner·Fort Myers, FL; Stamford, CT; Irving, TX
On-siteSeniorAnalytics Engineer
yesterday
WG
NEW

Deputy Manager-Data Science

WNS Global Services·Gurgaon, HR, India
On-siteSeniorAnalytics Engineer
2d ago
T
NEW

Analytics Consulting Manager

Transunion·White Plains, New York
On-siteSeniorAnalytics Engineer
$90k – $135k USD
2d ago
S
NEW

Digital Success Analytics Engineer

Salesforce·Texas - Austin
On-siteMidAnalytics Engineer
2d ago
Apply on Citigroup →