Data Analyst

Job Description

6+ years of experience in data sourcing, financial data analytics, or regulatory reporting. Prior experience in large banking or financial institutions preferred.

Regulatory Reporting Expertise : Strong understanding of US regulatory reports including Basel, Y-9C, 2052a, Call Reports, etc and Hands-on experience supporting data sourcing for these reports by working with finance and reporting teams.

Data Sourcing & Profiling : Proven experience identifying required data elements across enterprise data warehouses and ability to profile large datasets, assess data quality, and identify missing or inconsistent attributes.

SQL and BigQuery Proficiency : Advanced SQL skills to query and validate data across multiple platforms. Strong experience with Google BigQuery or similar cloud-based analytics tools.

Source-to-Target(S2T) Mapping Documentation : Experience creating detailed S2T mapping documents, including data hops, transformation logic, and attribute lineage. Ability to define defaulting logic for data gaps and align mappings to regulatory reporting needs.

Stakeholder Collaboration : Experience working with finance product owners, technology, data stewards, and governance teams to finalize source tables and mappings. Skilled at coordinating approvals and documenting decisions around data usage.

Data Controls and Governance Awareness : Understanding of data control points, validation rules, and audit readiness. Experience contributing to the design of automated controls for completeness and accuracy in reporting data.

Documentation and Communication : Ability to clearly document data sourcing logic, assumptions, and business rules. Strong written and verbal communication skills for walkthroughs and stakeholder updates.