Data Management & Reporting Specialist

Farm Credit Bank of Texas•Austin, TX

7h•Hybrid

About The Position

The Data Management & Reporting Specialist supports the Bank’s Asset and Liability Management function by ensuring the integrity, accuracy, and usability of financial data from multiple source systems. This role is responsible for data aggregation, reconciliation, reporting, dashboard development, and data integration processes that support ALM reporting, interest rate risk analysis, and Treasury decision-making. The position partners with Treasury leadership, ALM, Information Technology, and Audit teams to strengthen data quality, improve automation, support regulatory and control expectations, and enhance operational efficiency. The role requires a combination of financial data management, reporting, analytics, and technical skills, along with a working understanding of ALM concepts and banking regulatory requirements.

Requirements

Bachelor’s degree in Finance, Accounting, Economics, Data Analytics, Information Systems, or a related field.
Three (3) to five (5) years of experience in financial data management, financial reporting, ALM, treasury analytics, or related roles within banking or financial services.
Experience working with general ledger systems, financial reconciliation processes, and financial reporting data.
Working knowledge of Asset and Liability Management concepts, including interest rate risk, liquidity risk, and capital forecasting.
Proficiency with Excel, including pivot tables, advanced formulas, and data visualization capabilities.
Experience using SQL, Python, or other data querying or scripting tools.
Familiarity with business intelligence and reporting tools such as Power BI, Tableau, Databricks, or similar platforms.
Understanding of database structures, data integration concepts, and data governance principles.
Strong analytical and problem-solving skills with high attention to detail and commitment to data accuracy.
Ability to communicate effectively with technical and non-technical stakeholders.
Strong organizational skills and ability to manage multiple priorities in a deadline-driven environment.

Nice To Haves

Advanced degree such as MBA, MS in Finance, Data Analytics, or a related field.
Professional certification such as CFA, FRM, CPA, or similar credential.
Hands-on experience with ALM systems, preferably QRM, and financial modeling tools.
Experience with data integration tools, ETL processes, and automated reporting workflows.
Experience developing dashboards and executive-level reporting for Treasury, ALCO, or risk management audiences.
Experience supporting audit, regulatory, or internal control requirements in a banking or financial services environment.
Experience collaborating with Information Technology teams on data architecture, source system integration, or reporting platform enhancements.

Responsibilities

Collect, consolidate, validate, and reconcile balance sheet data from multiple source systems to support ALM reporting and risk analysis.
Create and reconcile the month-end position file to the Bank’s general ledger for QRM modeling and related Treasury reporting activities.
Validate data accuracy, completeness, and consistency across source systems, reporting outputs, and ALM models.
Prepare internal ALM reports for Treasury and support aggregation of Treasury ALCO reporting packages.
Develop, maintain, and enhance Treasury dashboards, automated reporting tools, and data visualization outputs that provide timely insight into financial trends, risk positions, and operational metrics.
Design and maintain data integration workflows between source systems, the general ledger, QRM, and related reporting platforms.
Identify opportunities to improve data quality, reporting efficiency, and process automation and assist with implementation of practical solutions.
Collaborate with Information Technology to enhance data architecture, integration processes, and reporting capabilities supporting ALM operations.
Serve as a liaison between Treasury, ALM, Information Technology, and Audit teams to promote data consistency, transparency, and control readiness.
Provide subject matter support for projects impacting ALM data flows, reporting, reconciliations, and QRM inputs.
Support compliance with regulatory standards, internal controls, and audit expectations related to ALM data and reporting processes.
Maintain documentation of data processes, reporting logic, reconciliations, and related procedures.
Use SQL, Python, Excel, business intelligence tools, or other analytics platforms to query, analyze, transform, and report financial data.
Participate in process improvement, automation, and data governance initiatives that support Treasury and ALM objectives.
Perform other duties and responsibilities as assigned.

Benefits

Flexible health-and-wellness benefits, including medical insurance, prescription drug coverage, dental insurance, vision care, flexible spending accounts, and more.
401(k) plan that includes immediate vesting of a generous employer match and additional employer contribution
Long-term disability and life insurance
Vacation leave, sick leave, and paid holidays
Fertility benefit and parental leave plan
Up to two days per year to volunteer in local community organizations, services, or events
Ongoing professional-development opportunities
Generous tuition-reimbursement program
Physical fitness incentive plan
Employer matching gifts program