Junior Business Analyst: Data & Reporting (Remote)

Vanguard Claims Administration

Woodbury (NJ)

Remote

USD 55,000 - 75,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Vanguard is seeking a Junior Business Analyst to support reporting, data analysis, and operational processes. The role focuses on bordereaux reporting, collections tracking, and Lloyd's DOI CAT reporting to ensure regulatory data integrity.

You will collaborate with Finance, Operations, and IT, using Excel (VBA/macros, pivots) and SQL to deliver ad hoc and scheduled reports, monitor data quality, and assist with SOC1/SOC2 control evidence and remediation tracking. Remote work option available.

Qualifications

  • Strong proficiency in Excel with VBA/macros, pivots, and advanced formulas.
  • Experience in data analysis and reporting within a data-driven environment.
  • Attention to detail and accuracy in data handling and reporting.
  • Effective written and verbal communication across finance, operations, and IT.
  • Working knowledge of SQL or data querying tools.

Responsibilities

  • Prepare, validate, and deliver bordereaux reports and data requests.
  • Assist with collections tracking and follow-up reporting with Finance and Operations.
  • Support Lloyd's DOI CAT reporting ensuring regulatory compliance and data integrity.
  • Generate and distribute ad hoc and scheduled reports for clients and internal teams.
  • Automate reporting using Excel to improve efficiency and accuracy.
  • Maintain and query databases to extract actionable data.
  • Review data for inconsistencies and resolve issues.
  • Support SOC1 and SOC2 control documentation and testing, including evidence.
  • Assist in remediation tracking for identified control gaps.
  • Validate data lineage from source systems to reports for audit traceability.

Skills

Excel (VBA/macros)
Data analysis
Attention to detail
Communication skills
SQL knowledge

Tools

Excel
SQL

Job description

Vanguard is seeking a Junior Business Analyst to support reporting, data analysis, and operational processes. The role focuses on bordereaux reporting, collections tracking, and Lloyd's DOI CAT reporting to ensure regulatory data integrity.

You will collaborate with Finance, Operations, and IT, using Excel (VBA/macros, pivots) and SQL to deliver ad hoc and scheduled reports, monitor data quality, and assist with SOC1/SOC2 control evidence and remediation tracking. Remote work option available.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Jr. Business Analyst
Jr. Business Analyst

Vanguard Claims Administration • Woodbury (NJ)

Remote
USD 55,000 - 75,000
Senior Data Reporting & Insights Analyst
Senior Data Reporting & Insights Analyst

The Vanguard Group • Malvern

Hybrid
USD 70,000 - 95,000
Remote Junior Business Data Analyst | Excel & SQL
Remote Junior Business Data Analyst | Excel & SQL

ProMarketExchange • United States

Remote
USD 62,000 - 72,000
Dental insurance
Green card sponsorship
Health insurance
+4
Data Reporting, Senior Associate
Data Reporting, Senior Associate

The Vanguard Group • Malvern

Hybrid
USD 70,000 - 95,000
Remote Junior Business Analyst: Data & Requirements
Remote Junior Business Analyst: Data & Requirements

Microflexinfra • United States

Remote
USD 60,000 - 75,000
401(k)
Dental insurance
Family leave
+6
Senior Data Reporting Associate
Senior Data Reporting Associate

Vanguard • Malvern

Hybrid
USD 65,000 - 90,000
Hybrid work model
Remote Junior Business Analyst – Data & Process Improvement
Remote Junior Business Analyst – Data & Process Improvement

Weboptimix • United States

Remote
USD 63,000 - 75,000
401(k)
Dental insurance
Green card sponsorship
+7
Remote Junior Business Analyst - Launch Your Career
Remote Junior Business Analyst - Launch Your Career

Placements24 • East End

Hybrid
USD 50,000 - 70,000
Data Reporting Analyst — Drive Operations Insights
Data Reporting Analyst — Drive Operations Insights

Vanguard • Malvern

Hybrid
USD 65,000 - 90,000
Hybrid work model
Junior Investment Data Analyst — Data Quality (Hybrid)
Junior Investment Data Analyst — Data Quality (Hybrid)

Vanguard • Scottsdale (AZ)

Hybrid
USD 70,000 - 110,000
Hybrid work model
Competitive benefits