Get the app Chrome extension Freelance ideasGigsSign inFind my gigs

ProfilePush / H1B jobs / Excel Analyst

Excel Analyst

Insight Global · Chicago, IL · contract · posted 29 days ago

$34 an hourpay
Chicago, ILlocation
contractjob type

Apply on Insight Global's siteCheck my AI Match score

Skills

About the job

Required Skills & Experience

Expert-level Excel skills, including complex formulas/calculations, PivotTables, VLOOKUP/XLOOKUP, INDEX/MATCH, data validation, and reconciliation

Experience working with large datasets and performing detailed transaction-level analysis

Incentive compensation or variable compensation experience, preferably within banking or financial services

Financial and analytical acumen with the ability to validate revenue, funds, deal-team attribution, and incentive credit

Salesforce experience, particularly working with data coming from or moving into Salesforce

Strong reconciliation skills with the ability to compare information across legacy and new systems and identify discrepancies

High-level self-starter who can contribute immediately without requiring a 30/60/90-day training period

Strong attention to detail and accuracy when validating approximately 500–600 transactions per month

Excellent written and verbal communication skills with the professionalism to contact directors, leadership, and other stakeholders to resolve missing or incorrect information

Strong critical thinking and problem-solving skills

Nice to Have Skills & Experience

Banking experience, ideally within Wealth Management, Trust, or related financial services areas

Experience with incentive compensation platforms such as Varicent or similar compensation management systems

Experience supporting a legacy-system-to-Salesforce migration

Experience with financial reporting platforms or business intelligence tools

Microsoft Access experience

Experience supporting control documentation, testing, audit activities, or parallel-system validation

Understanding of sales reporting and how transactional data flows into incentive compensation calculations

Job Description

Support the Wealth division during the transition from a roughly 25-year-old legacy system to Salesforce

Validate approximately 500–600 transactions per month, confirming client information, funds/revenue, deal-team members, and proper incentive credit

Perform Excel-heavy calculations, reconciliations, lookups, PivotTable analysis, and transaction-level verification

Compare data moving between the legacy environment, Salesforce, and incentive compensation processes

Investigate discrepancies by determining what information is missing, why it is missing, and how it should be corrected

Reach out by phone and email to business partners, directors, and leadership to verify information and resolve data issues

Support parallel testing between the legacy and new environments, comparing outputs and identifying why calculations or incentive results do not align

Analyze data from the old and new systems to identify gaps, trends, and migration issues

Help ensure accurate sales reporting and incentive compensation throughout the system transition

Provide additional analytical support across areas such as retail, indirect lending, and mortgage

More Insight Global jobs this week

Sr. DevOps & Microsoft AI Solutions EngineerInsight Global · Portland, OR · contract · today
View
Sr. Power Platform EngineerInsight Global · Portland, OR · contract · today
View
Technical Support Admin IInsight Global · Lower Nazareth, PA · contract · yesterday
View
Sr. Applications EngineerInsight Global · Hillsboro, OR · full-time · yesterday
View
ASIC Subsystem EngineerInsight Global · El Segundo, CA · contract · yesterday
View
QA Engineering AdvisorInsight Global · Hunter Mill, VA · contract · yesterday
View

Questions

Does Insight Global sponsor H1B for this job?

Insight Global is on record as an H1B sponsor. The posting doesn't say it won't sponsor. A past filing doesn't guarantee sponsorship for a particular role, so confirm with Insight Global.

How do I apply for this Excel Analyst job?

Apply on Insight Global's own careers page with the Apply button. To see how well your resume fits first, ProfilePush's AI Match scores it 0 to 100 for free.

How well do you fit this job?

Upload your resume and AI scores this job, and every sponsor job like it, 0 to 100. Free to start.

Get my match score