Skills

Communication Leadership Tableau SQL ServiceNow Attention to detail Organization Analytical Skills Snowflake

Job Specifications

A leading financial services organization is seeking a Data Analyst (Payments) to support a large-scale Identity Account Management (IAM) modernization effort. The company has launched a new in-house platform for Visa and Mastercard and is now reconciling 20+ years of legacy data across multiple systems.

This is a high-visibility role that requires strong analytical skills, exceptional attention to detail, and the ability to translate messy, legacy data into clear insights for leadership.

Location: Hybrid

Onsite 3 days/week: Riverwoods, IL headquarters or Chicago Loop office
Work from home Mondays + Fridays
Rate: $58–$85/hr (W2) — based on experience
Contract: 12 months

About the Work

You will partner with product owners and payments stakeholders to:

Reconcile and validate discrepancies across legacy IAM platforms
Transform raw data into stories and visualizations that drive business decisions
Identify gaps, mismatches, and structural inconsistencies
Translate patterns and anomalies into clear explanations for leadership
Support the migration of IIN/BIN data into a new centralized system
Work closely with the hiring manager to present findings in a clear, narrative format

This role is data-first, not dashboard-beautification.

They need someone who can interpret the data, not just visualize it.

What You’ll Do

Analyze large and unstructured datasets across legacy payment systems
Create Tableau visualizations that highlight discrepancies and data patterns
Write SQL queries in Snowflake to extract, transform, and verify data
Build clear narratives and insights using data
Support reconciliation efforts for IIN/BIN-related records
Present findings to senior stakeholders and product owners
Produce ongoing reports, scorecards, and dashboards
Provide analytical support for IAM data initiatives

Qualifications

Tableau (must be able to interpret data, not just build dashboards)
SQL (strong queries, joins, transformations)
Snowflake (hands-on experience)
Excel (advanced: VLOOKUP, pivot tables, Power Query)
Strong data storytelling & communication skills
Data reconciliation experience
Ability to work with messy, unstructured legacy data

Preferred Skills (Bonus)

Payments or financial services background
Experience with IIN/BIN
ServiceNow exposure

If you’re interested in this opportunity, I’d love to share more details and learn more about your background!

About the Company

In 2010, Swoon launched an agile, client-focused team that is not only savvy in our core industries but elbow-deep, every day, getting to know the strongest talent in the technology and professional fields. Today, Swoon is one of the fastest-growing talent and consulting firms in the U.S., Canada, Australia, and Mexico with an expanding client roster of Fortune 1000 companies, Best-of Awards, and legions of talent in our network. We are a WBENC-certified company founded by industry leaders with 100+ years of combined exp... Know more