Treasury Regulatory Reporting Analyst

Procom; Westlake (OH); On-site; USD 90,000 - 130,000; Full time

Job summary

Procom is seeking a Liquidity Regulatory Reporting Analyst to support the daily production, validation, and submission of U.S. liquidity reports, focusing on FR 2052a with support for LCR and NSFR. The role requires strong SQL and Excel skills to analyze large datasets and ensure data quality.

You will work with Treasury, Finance, Risk, Data, and Technology teams in a fast-paced environment. This assignment is a 12-month W2 contract based in Westlake, TX with onsite work four days per week and a

Qualifications

• Bachelor's degree required.
• 3–5+ years of experience in a financial institution.
• Strong SQL and Excel skills with large datasets.
• Experience with FR 2052a, LCR, NSFR is preferred.
• Experience with AxiomSL ControllerView is a plus.

Responsibilities

• Execute daily FR 2052a production, validation, and submission activities.
• Perform variance analyses, reconciliations, and data quality reviews.
• Analyze data using SQL to identify root causes of issues.
• Monitor data feeds and system interfaces; escalate and track issues.
• Support LCR and NSFR reporting processes and controls.
• Develop automation to improve reporting efficiency and accuracy.

Skills

SQL

Excel

Data analysis

Regulatory reporting

Attention to detail

Cross-functional collaboration

Education

Bachelor's degree

Tools

AxiomSL ControllerView

SQL

Excel

Job description

Liquidity Regulatory Reporting AnalystAssignment Details:Duration: 12-month contract (W2 only)Location: Westlake, TX — 4 days/week onsite. Omaha, NE as backup location.Interview Process: 2 rounds, possible thirdTeam Overview:The Liquidity Regulatory Reporting team within Treasury manages and monitors key regulatory liquidity metrics and ensures compliance with applicable requirements, including the Liquidity Coverage Ratio (LCR) and related public disclosures, the Net Stable Funding Ratio (NSFR), and the FR 2052a Complex Institution Liquidity Monitoring Report. The team also develops tools to help business partners analyze the impact of business decisions, and collaborates with internal and external partners on ongoing examinations and audits of liquidity practices. Day-to-day, the team supports a daily report send tied to finance reporting, working closely with Development teams. Position Overview:The Treasury Regulatory Reporting Analyst supports the daily production, validation, control, and submission processes for U.S. liquidity regulatory reporting, with primary responsibility for FR 2052a reporting and additional support for LCR and NSFR reporting. The analyst executes daily reporting activities, performs data quality reviews, investigates anomalies, coordinates issue resolution, and supports regulatory reporting automation initiatives. This is an individual-contributor role — no direct reports.The role requires strong analytical skills, attention to detail, and the ability to independently manage daily production activities within strict regulatory deadlines while partnering with Treasury, Finance, Risk, Data, and Technology teams. What You'll Do:Execute daily FR 2052a production, validation, and regulatory submission activities in accordance with established procedures and reporting deadlinesPerform detailed variance analysis, reconciliations, and quality reviews to ensure reporting completeness, accuracy, and complianceUtilize SQL to analyze large datasets, investigate reporting anomalies, and identify root causes of data issuesMonitor reporting processes, data feeds, and system interfaces; promptly identify, escalate, and track issues through resolutionSupport LCR and NSFR reporting processes, including data validation, reconciliations, and reporting controlsPartner with Treasury, Finance, Risk, Data Management, and Technology teams to resolve data discrepancies and implement reporting enhancementsMaintain and enhance reporting procedures, control documentation, governance evidence, and audit support materialsParticipate in testing, implementation, and production validation of regulatory reporting changes, system upgrades, and new initiativesIdentify and implement automation opportunities to improve reporting efficiency, reduce manual processes, and strengthen operational controlsDevelop comprehensive business requirements for functional and nonfunctional enhancements supporting liquidity regulatory reporting processesCreate and optimize SQL queries to analyze datasets of varying complexity, and develop analytical models and automation solutionsAnalyze and interpret data from multiple sources, including databases, spreadsheets, and reporting systemsCommunicate issues to appropriate data owners and monitor/track through timely, effective resolutionParticipate in projects supporting new initiatives, process improvements, and technology implementationWhat You Have:Bachelor's degree required3–5+ years of related experience within a financial institutionBasic knowledge of finance and accounting, particularly within banking and broker-dealer businessesKnowledge of U.S. GAAP and accounting policyStrong SQL and Excel skills, able to work with large datasets and complex queriesExperience with liquidity regulatory reporting (FR 2052a, LCR, NSFR)Experience with AxiomSL ControllerViewStrong analytical and quantitative skills, with experience in data analysis and trend identificationExcellent documentation skills — able to create comprehensive business requirements, process documentation, and analytical reportsHands-on experience implementing automation tools to optimize reporting processesAbility to partner effectively with cross-functional teams across Finance, Data, and TechnologyAbility to thrive in a fast-paced, dynamic environment with changing prioritiesStrong attention to detail and a commitment to accuracy and quality in all deliverablesDemonstrated ownership, initiative, and accountability for high-quality outcomesAbility to navigate ambiguity and make informed decisionsStrong organizational and multitasking skills, with the ability to manage multiple changing prioritiesAdaptability and resilience in uncertain environments with evolving regulatory landscapes