Regulatory Reporting consultant w strong Pivot Tables & V-Look Ups. - 100% FULLY Remote

YOH Services LLC
United States, Texas, Houston
Mar 27, 2025
Regulatory Reporting consultant w strong Pivot Tables & V-Look Ups. - 100% FULLY Remote Category: Banking & Financial Services Employment Type: Contract Reference: BH-383810 Regulatory Reporting consultant w strong Pivot Tables & V-Look Ups - 100% FULLY REMOTE Estimated Min Rate: $52.50 Estimated Max Rate: $75.00 About the Role: Our client's Finance team supporting regulatory reporting. You will contribute to the success of the U.S. Finance Department by ensuring individual and departmental goals are met. This role involves preparing and reviewing regulatory reports, managing issues related to AXIOM logic, and ensuring data integrity and quality for reporting. Key Responsibilities: Prepare regulatory reports (daily, weekly, monthly, quarterly, and annual) in accordance with US GAAP and reporting instructions (e.g., FR2900, FR2644, FFIEC 002, FFIEC 019, TIC reports, BE reports). Utilize the Axiom reporting tool for regulatory filings. Document and monitor system/data quality issues from regulatory reports. Drive accountability for the accuracy of Critical Data Elements (CDEs) used for Regulatory Reporting. Collaborate with various stakeholders (AXIOM Project team, Data Governance, Operations, Treasury, Credit Risk, Product Control, IT) to implement new reporting requirements and resolve issues. Participate in end-to-end testing on all AXIOM BAU releases. Prepare and coordinate information for Internal Audit, Quality Assurance, Internal Control, and external Fed Exams. Create/update Policies & Procedures, process flows, and risk control matrices. Assist in data collection for regulatory reporting metrics for dashboards. Prepare presentation decks for internal stakeholders and assist in developing/updating training material. Attend required Finance, U.S. GAAP/IFRS, Regulatory, and Compliance training. Respond promptly to ad-hoc regulatory requests while ensuring other deliverables are met. Demonstrate initiative, independent judgment, and self-direction in meeting objectives and solving problems. Candidate Requirements: 3+ years of experience in financial and regulatory reporting at a large banking organization or consulting firm, with a focus on regulatory reporting. Proficient in MS Office Suite, especially Advanced Excel (formulas, pivot tables, Vlookup). Strong accounting knowledge and understanding of U.S. GAAP. Understanding of banking and capital markets (preferably loans, deposits, prime service). Knowledge of necessary controls for certain processes (related to Internal Control). Experience with AXIOM. Nice-to-Have Skills: Experience with PeopleSoft. Soft Skills: Strong work ethic and accountability. Excellent written and verbal communication skills, including presentation skills to senior management. Ability to work effectively in a dynamically changing environment. Strong learning capability and control mindset. Education: Bachelor's degree in a technical field such as computer science, computer engineering, or a related field required. Estimated Min Rate: $52.50 Estimated Max Rate: $75.00 Note: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply. Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Visit https://www.yoh.com/applicants-with-disabilities to contact us if you are an individual with a disability and require accommodation in the application process. For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.