IT - Data Analyst - Senior

Spectraforce
Chicago, IL, United States
about 1 month ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source

Tech stack

Data Analysis Business Logic Data Validation Database Queries Python (Programming Language) Standard Sql SAS (Software) Software Engineering SQL Databases Data Analytics

Job description

We are seeking a Senior Data Analyst to support a high-impact AML (Anti-Money Laundering) rule migration project. The selected candidate will play a critical role in validating and reconciling reporting outputs as AML rules are migrated from a legacy platform to SAS Viya.

This position is focused on business reporting, data validation, reconciliation, and analytical problem-solving rather than software development or quantitative modeling. The ideal candidate will possess strong SQL and SAS skills, exceptional analytical abilities, and experience explaining data discrepancies to business stakeholders., The contractor will support the migration of AML rules and reporting from a legacy platform to SAS Viya, including:

  • Validating migrated AML rules
  • Performing record-level reconciliation between legacy and new systems
  • Identifying, documenting, and explaining discrepancies
  • Supporting defect tracking, root cause analysis, and testing
  • Producing comprehensive reconciliation and validation documentation, * Execute and validate AML rules within SAS Viya
  • Compare reporting outputs between legacy and new platforms
  • Perform detailed record-level reconciliation and data validation
  • Investigate discrepancies and determine root causes
  • Identify whether differences can be resolved or require business documentation
  • Support data load validation activities
  • Participate in defect identification, testing, and resolution tracking
  • Produce well-documented reconciliation artifacts and business logic documentation
  • Collaborate with developers during rule implementation and validation
  • Present analytical findings in clear, business-friendly language
  • Partner with business and technical stakeholders throughout the migration lifecycle, * Base SAS
  • DATA Step
  • SAS Viya
  • Data Validation
  • Data Reconciliation
  • Business Reporting
  • Root Cause Analysis
  • Defect Tracking
  • Data Quality
  • Documentation, * Gain hands-on experience with SAS Viya migration
  • Contribute to regulatory compliance and financial crime prevention
  • Own validation and reconciliation deliverables
  • Collaborate with business and technical stakeholders in a highly impactful project

Requirements

  • Bachelor’s degree or equivalent experience
  • 5-7 years of experience in Data Analytics, Data Validation, or Business Reporting
  • Strong SQL skills including:
  • Joins
  • Aggregations
  • Common Table Expressions (CTEs)
  • Experience with SAS:
  • Base SAS
  • DATA Step
  • PROC SQL
  • OR strong SQL experience with the ability to quickly adapt to SAS
  • Proven experience analyzing results and explaining why discrepancies exist
  • Experience with data validation, reconciliation, and documentation
  • Strong analytical and problem-solving skills, * AML (Anti-Money Laundering) experience
  • Financial Services industry experience
  • Payments domain experience including:
  • Wire Transfers
  • SWIFT
  • Payments Processing
  • Experience with system or rule migration projects
  • Familiarity with SAS Viya
  • Python experience, * Strong business acumen
  • Excellent analytical and critical thinking skills
  • Detail-oriented with a strong focus on data quality
  • Ability to translate ambiguity into clear business requirements
  • Excellent written and verbal communication skills
  • Collaborative and stakeholder-focused
  • Curious, proactive, and solution-oriented

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on leoforce.us

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu · WWC 2024

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella · WWC 2023

4:06 min

Using ClickHouse as a foundation for fast analytics

Hellmar Becker Hellmar Becker · WWC Europe 2026

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

1:56 min

Creating immutable blockchain tables using standard SQL syntax

Wei Hu Wei Hu · WWC 2023

1:34 min

Bringing diverse skills to industrial data science roles

Katja Träumner

Videos

See all

Related articles

See all