Use SQL, Excel, and other analytical tools to extract, join, reconcile, and analyze data across multiple sources; identify trends, anomalies, outliers, and performance drivers, and translate findings into meaningful business insights.
Perform data validation, reconciliation, and root-cause analysis to ensure reporting accuracy and integrity; execute quality controls and maintain documentation of data lineage, transformation logic, metric definitions, assumptions, and known limitations.
Apply effective data visualization principles to communicate complex information clearly, highlighting trends, risks, exceptions, and performance indicators in a manner that enables stakeholders to quickly understand key insights.
Partner with GFCC stakeholders to understand reporting needs and the underlying business decisions they support; translate requirements into well-defined reporting and analytical solutions in collaboration with the Product, Technology, and Data teams.
Support the delivery of new and enhanced reporting capabilities by participating in defining and grooming requirements, impact assessments, User Acceptance Testing (UAT), Post Implementation Validation (PIV), defect resolution, and implementation activities.
Proactively identify and implement opportunities to automate recurring data preparation, reconciliation, controls, and reporting processes, reducing manual effort and operational risk while improving scalability and user experience.
Perform timely and accurate data analysis and reporting to support regulatory examinations, audits, issue management, executive inquiries, and other priority requests, including investigation and resolution of data or reporting issues.
Develop a strong understanding of GFCC programs and investigative processes, independently own assigned reporting products and deliverables, and proactively identify opportunities to improve reporting accuracy, usability, adoption, and analytical value.
2+ years of experience in reporting, analytics, business intelligence, or data management; experience within Financial Crimes, Compliance, Risk, or another regulated environment is preferred.
Demonstrated proficiency in SQL and/or other data querying languages, with the ability to extract, join, reconcile, validate, and analyze data from multiple sources to identify trends, anomalies, and business insights.
Hands-on experience with data visualization tools such as Power BI or Tableau, with a strong understanding of dashboard design and the ability to translate complex data into clear, intuitive, and actionable visualizations.
Strong analytical curiosity and problem-solving skills, with demonstrated ability to investigate data anomalies, perform root-cause analysis, identify performance drivers, and translate findings into meaningful insights and recommendations.
Strong attention to detail and a disciplined approach to data validation, reconciliation, documentation, quality controls, and reporting accuracy, with an understanding of the importance of data lineage and metric consistency.
Strong written and verbal communication skills, with the ability to understand stakeholder needs, communicate analytical findings clearly, and translate complex information into effective reports, visuals, and presentations for business and leadership audiences.
Demonstrated ability to independently own reporting and analytical deliverables, manage competing priorities, meet deadlines, and collaborate effectively with stakeholders and cross-functional teams in a global environment.
Advanced Microsoft Excel skills, including PivotTables, Power Query, and data transformation or automation capabilities; proficiency in PowerPoint required. Experience with reporting automation or other analytical technologies is beneficial.
Ability and willingness to develop a strong understanding of GFCC programs, investigative processes, and operational performance; prior Financial Crimes experience is beneficial but not required.
Bachelor’s degree required.