Data Management & Reporting Specialist

Farm Credit Bank of Texas
Austin, United States of America
8 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Austin, United States of America

Tech stack

Microsoft Excel
Business Analytics Applications
Information Systems
Data Architecture
Data Governance
Data Integration
ETL
Data Normalization
Data Visualization
Database Queries
Database Storage Structures
Excel Formulas
Python
Pivot Tables
Power BI
SQL Databases
Data Streaming
Systems Integration
Tableau
Scripting (Bash/Python/Go/Ruby)
Information Technology
Data Analytics
Data Management
Tools for Reporting
Databricks

Job description

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.

Day-to Day-Duties and 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.

What You Bring to the Team:

Our ideal candidate lives within a commutable distance from our office and appreciates the value of hybrid work design.

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.

Preferred

  • 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.

Benefits & conditions

In addition to a competitive salary, we offer comprehensive, affordable, and competitive benefit options that are focused on health and wellness, financial security, and achieving a work-life balance:

  • 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

Important note: We care about your hiring process and take it seriously. A real person will review your applications, meaning response timelines may vary. The interviewing process at Farm Credit Bank of Texas may include phone calls and emails, on-site interviews, and requests for portfolios or demonstrations of work. We can't personally follow-up with each applicant, and we will do our best to create a professional, respectful, and thorough process for candidates with whom we identify as a potential fit.

About the company

Farm Credit Bank of Texas is a $42.2 billion wholesale bank that has been financing agriculture and rural America for over 100 years. Headquartered in Austin, Texas, we provide funding and services to rural lending associations in five states, and we are active in the nation's capital markets. While you may not be familiar with our name, Farm Credit Bank of Texas plays a critical role in supporting the businesses that make it possible for America to maintain access to an affordable and safe food supply, an industry which is one of the most innovative and evolving of our time. And while you help us deliver on our mission, we deliver on our commitment to you as a valued employee by providing competitive compensation, generous health and wellness benefits packages and an attractive workplace located along the bluffs of the Colorado River just minutes west of downtown Austin. We seek out top talent in their fields, whether it be technology, finance, accounting, credit, human resources, or other administrative functions, and welcome you to join us in our mission to feed the world.

Apply for this position