Job Description
BTC Bank is a community bank founded on the traditional values of personal customer service. Our continued tradition of serving our friends and neighbors with courteous, professional banking services maintains its standard of excellence today. We strongly support our local communities. We are proud of the roots of our past and prepared for the growth in our future.
Work Location: This position will be based out of one of the following locations: Bethany, Sedalia, Chillicothe or Cameron MO. This is an onsite position.
Hours: 40 hours per week,
Job Purpose: The Data Analyst supports the organization’s banking operations by ensuring accuracy, regulatory readiness, integrity, and usability of data across core systems, including AS400 and various financial platforms. This role is responsible for data cleanup, advanced analysis, AI-assisted insights, and the development of automated reporting and dashboard solutions. The analyst will collaborate with business units to enhance data-driven informed decision-making, strengthen data quality and improve operational efficiency that will support strategic planning.
Duties and Responsibilities:
Data Quality & Management
Perform data cleanup, validation, and standardization across AS400 and various financial platforms.
Identify data inconsistencies and implement corrective actions to maintain data integrity.
Support ongoing data governance initiatives and documentation standards.
AI-Enhanced Data Analysis
Utilize AI tools to analyze operational, financial, and customer data.
Identify trends, anomalies, and predictive insights to support business decisions.
Assist in evaluating and implementing new AI capabilities within the analytics environment.
Reporting & Dashboard Development
Develop and maintain Excel-based dashboards, reports, and visualizations for internal stakeholders.
Automate recurring reporting processes to reduce manual workload.
Ensure reporting accuracy, consistency, and alignment with regulatory and internal standards.
Work with multiple data types, including PDF, TXT, CSV files to generate reports for various business units.
Automation & Process Improvement
Build automated workflows using scripting, macros, or low-code tools to streamline operational tasks.
Partner with IT and business units to enhance data pipelines and reporting processes.
Recommend improvements to existing procedures to increase efficiency and reduce risk.
Core Banking System Analysis
Extract, interpret, and analyze data from AS400 and various financial platforms.
Understand system structures, tables, and data relationships to support operational and strategic needs.
Provide ad-hoc analysis and reporting to support banking operations, compliance, and leadership teams.
Qualifications:
College graduate in computer science, related field, or equivalent experience.
Strong communication skills with the ability to present complex information clearly.
Ability to work independently and collaboratively across departments.
High level of integrity, confidentiality, and professionalism.
Continuous improvement mindset with interest in emerging technologies.
Ability to analyze data using AI technologies, M365 tools, SQL and python (and other scripting engines).
Working Conditions:
This job operates in a normal office setting. This role routinely involves standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.
