Data Analyst & Data Project Analyst
Job Description Who we are: 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. Position Description The Data Analyst & Data Project Analyst within the Loan Accounting Systems organization supports the accuracy, integrity, and usability of loan data across the enterprise. This role performs data analysis and supports project execution related to loan accounting, Loan IQ, downstream reporting, and operational and regulatory data needs. The position works in partnership with accounting, operations, reporting, and technology teams to analyze data issues, support system and reporting initiatives, and contribute to the consistent use of loan data across related processes and systems. Day-to Day-Duties And Responsibilities Analyze data across Loan IQ and related upstream and downstream systems to identify trends, discrepancies, and operational impacts.
Review loan attributes, including pricing options, rate basis, repayment schedules, fee structures, and accounting events, to support data accuracy and alignment with business rules.
Perform data reconciliations between Loan IQ, the general ledger, reporting tools, and data warehouse environments to identify, investigate, and document variances.
Prepare dashboards, reports, and data summaries reflecting loan portfolio metrics, exception trends, and data quality indicators.
Support data-driven projects related to system enhancements, data remediation efforts, Loan IQ upgrades, workflow improvements, and reporting modernization.
Assist with project activities, including requirements documentation, data mapping, test coordination, issue tracking, and stakeholder communication.
Partner with product managers, business analysts, data engineering, quality assurance, finance, accounting, and operations teams to support project execution and issue resolution.
Support data governance activities for loan accounting data, including business definitions, data lineage, reference data, and documentation of data quality rules.
Help monitor and investigate data quality issues, including missing values, incorrect loan statuses, misaligned accrual settings, and unexpected rate resets.
Assist with root-cause analysis for data issues affecting financial reporting, operational workflows, and regulatory processes.
Use SQL and other analytical tools to extract, transform, and analyze loan datasets from enterprise data platforms.
Develop visualizations and reporting outputs using Power BI or similar tools to support business insight and decision-making.
Contribute to the identification and documentation of process improvement opportunities related to loan data, reporting, and system workflows.
Develop working knowledge of how system configuration, including rate sets, fee schedules, amortization rules, and accounting events, impacts downstream data and reporting. 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. It’s an important role that covers many skills. This position requires: Required Bachelor’s degree in Data Analytics, Finance, Information Systems, Accounting, Business, or a related field.
3+ years of experience in data analysis, reporting, systems support, or project coordination, preferably within lending, loan servicing, financial systems, or a related environment.
Working knowledge of SQL and the ability to analyze data across multiple systems and sources.
Experience supporting data-related projects, reporting initiatives, system enhancements, or process improvement efforts.
Familiarity with loan lifecycle processes, including origination, servicing, funding, accruals, payments, and rate resets.
Ability to investigate data issues, organize findings, and communicate results clearly to technical and non-technical stakeholders.
Strong organizational skills, attention to detail, and the ability to manage multiple assignments within a team-based environment. Preferr
Apply tot his job
Apply To this Job
Review loan attributes, including pricing options, rate basis, repayment schedules, fee structures, and accounting events, to support data accuracy and alignment with business rules.
Perform data reconciliations between Loan IQ, the general ledger, reporting tools, and data warehouse environments to identify, investigate, and document variances.
Prepare dashboards, reports, and data summaries reflecting loan portfolio metrics, exception trends, and data quality indicators.
Support data-driven projects related to system enhancements, data remediation efforts, Loan IQ upgrades, workflow improvements, and reporting modernization.
Assist with project activities, including requirements documentation, data mapping, test coordination, issue tracking, and stakeholder communication.
Partner with product managers, business analysts, data engineering, quality assurance, finance, accounting, and operations teams to support project execution and issue resolution.
Support data governance activities for loan accounting data, including business definitions, data lineage, reference data, and documentation of data quality rules.
Help monitor and investigate data quality issues, including missing values, incorrect loan statuses, misaligned accrual settings, and unexpected rate resets.
Assist with root-cause analysis for data issues affecting financial reporting, operational workflows, and regulatory processes.
Use SQL and other analytical tools to extract, transform, and analyze loan datasets from enterprise data platforms.
Develop visualizations and reporting outputs using Power BI or similar tools to support business insight and decision-making.
Contribute to the identification and documentation of process improvement opportunities related to loan data, reporting, and system workflows.
Develop working knowledge of how system configuration, including rate sets, fee schedules, amortization rules, and accounting events, impacts downstream data and reporting. 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. It’s an important role that covers many skills. This position requires: Required Bachelor’s degree in Data Analytics, Finance, Information Systems, Accounting, Business, or a related field.
3+ years of experience in data analysis, reporting, systems support, or project coordination, preferably within lending, loan servicing, financial systems, or a related environment.
Working knowledge of SQL and the ability to analyze data across multiple systems and sources.
Experience supporting data-related projects, reporting initiatives, system enhancements, or process improvement efforts.
Familiarity with loan lifecycle processes, including origination, servicing, funding, accruals, payments, and rate resets.
Ability to investigate data issues, organize findings, and communicate results clearly to technical and non-technical stakeholders.
Strong organizational skills, attention to detail, and the ability to manage multiple assignments within a team-based environment. Preferr
Apply tot his job
Apply To this Job