BTC Bank · 5 hours ago
Data Analyst
Columbia, MO, US
Full-time
Onsite
New Grad, Entry LevelBTC Bank is a community bank focused on personal customer service and community support. The Data Analyst role involves ensuring the integrity and usability of data across banking operations, performing data analysis, and developing automated reporting solutions.
BankingCommunitiesFinanceFinancial ServicesFinTech
Responsibilities
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
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
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
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
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
Qualification
Required
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)
Company
BTC Bank
BTC Bank is a community bank serving the people and businesses of Missouri and Iowa.
Founded in 1919
201-500 employees
H1B Sponsorship
BTC Bank has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (5)
2024 (9)
2023 (5)
2022 (11)
2021 (3)
Funding
Current Stage
Growth StageLeadership Team
W
Wendy Preston
Chief Financial Officer
Recent News
The Fayette Advertiser
2024-04-28
Sedalia Democrat
2024-04-28
Business Journals
2022-10-22
Company data provided by crunchbase