Business Systems and Reporting Analyst

FIRST CENTURY BANK, N.A.; Commerce (GA); Hybrid; USD 52,000 - 72,000; Full time

Job summary

First Century Bank, N.A. is seeking a curious and analytical Business Systems and Reporting Analyst in Commerce, GA. This entry-level role supports the Business Analytics and ACH team, focusing on data understanding, reporting accuracy, and process improvements.

The position combines in-office and remote work, with three days in Commerce and two days at home. The candidate should have a bachelor’s degree in a related field and 0–3 years of experience, with strong Excel and foundational SQL

Qualifications

• Bachelor's degree in business, information systems, data analysis, finance, accounting, computer science, or related field.
• 0–3 years of related experience or internships considered.
• Strong Excel skills and foundational SQL, relational data, and data-validation concepts.
• Ability to ask questions, learn unfamiliar systems, and understand business purpose behind reports.

Responsibilities

• Create, modify, and maintain reports using SQL, Excel, Power BI, Crystal Reports, Cognos, or similar tools.
• Interact with stakeholders to define reporting and data needs and determine presentation approach.
• Review outputs for completeness and accuracy, identify inconsistencies, and escalate data integrity concerns.
• Investigate reporting, data, and system questions; document findings and coordinate resolutions.
• Perform user acceptance testing for reports, scripts, and processes; prepare test cases and evidence.
• Suggest improvements to data collection, monitoring, and reporting processes.
• Support new client, product, vendor, and system initiatives with data mapping and testing.
• Document report definitions, data-flow, test results, and issue summaries.
• Document issues in ticketing systems and participate in project teams as needed.
• Develop knowledge of the Bank's reporting environment and related systems for flexibility.

Skills

Excel

SQL

Data validation

Analytical thinking

Communication

Attention to detail

Collaboration

Problem solving

Education

Bachelor's degree in business/information systems/data analysis

Tools

Microsoft SQL Server

Power BI

Crystal Reports

Cognos

Job description

Business Systems and Reporting Analyst

First Century Bank has an exciting career opportunity for a curious and analytical Business Systems and Reporting Analyst. This position supports the Business Analytics and ACH team by helping the Bank understand its data, maintain accurate and useful reporting, investigate questions, test system changes, and improve business processes.

We are looking for someone who wants to understand not only what the data shows, but why it matters. The successful candidate will ask thoughtful questions, approach problems logically, and build knowledge through active participation and collaboration. This is a developmental role that will work closely with experienced analysts, business departments, IT, project managers, and third-party partners while gaining exposure to reporting, banking systems, payments, and product implementations.

This entry-level position is designed for candidates with 0–3 years of relevant experience and requires a bachelor's degree in a related field.

Applicants must currently live within commuting distance of Commerce, GA. The schedule includes three days per week in our Commerce office and two days working from home.

Duties and responsibilities can include:

• Reporting and analysis: Create, modify, and maintain operational, management, monitoring, and reconciliation reports using SQL, Excel, Power BI, Crystal Reports, Cognos, or other available reporting tools.

• Business understanding: Demonstrate understanding by interacting with senior analysts and business stakeholders to create and define reporting and data needs, identify the purpose behind each request, and help determine the most useful way to present the information.

• Data validation: Review reports, data extracts, file loads, and other outputs for completeness and accuracy. Compare information across sources, identify inconsistencies, and ***escalate*** potential data-integrity concerns.

• Research and troubleshooting: Investigate reporting, data, and system questions; document findings; and work with the appropriate team to resolve or elevate issues.
• Testing and change support: Perform user acceptance testing for reports, system enhancements, scripts, and new processes. Prepare test cases, compare expected and actual results, record evidence, and communicate findings clearly.
• Process improvement: Provide feedback on design and improvement of reporting, data collection, monitoring, and business processes. Suggest ideas to make recurring work more accurate, efficient, and sustainable.
• Implementation support: Support new client, product, vendor, and system initiatives by confirming requirements, completing data mapping, generating reporting, performing testing, creating readiness reviews, and completing post-implementation validation.
• Documentation: Create and maintain report definitions, procedures, data-flow documentation, test results, issue summaries, and other materials needed to preserve knowledge and support consistent processes.
• Ticket and project support: Document issues and requests in the Bank's ticketing systems, maintain supporting evidence, track progress, validate corrections, and participate on project teams as assigned.
• Cross training and team support: Develop working knowledge of the Bank's reporting environment, ACH and other payment products, banking portals, and related systems so the position can provide flexible analytical and project support as priorities evolve.

Perform other duties that may be assigned or that inherently and logically belong with the position.

Exemplify FCB's values while supporting its mission, organizational goals, and priorities.

Qualifications and Requirements

• Bachelor's degree in business, information systems, data analysis, finance, accounting, computer science, or a related field, or an equivalent combination of education and relevant experience.

• One to three years of related experience is preferred; relevant internships, coursework, or project experience may also be considered.

• Strong Excel skills and a foundational understanding of SQL, relational data, and common data-validation techniques.

• Demonstrated curiosity and willingness to ask questions, learn unfamiliar systems, and understand the business purpose behind reports and processes.

• Strong critical-thinking and problem-solving skills, with the ability to research an issue carefully and reach conclusions supported by evidence.

• High attention to detail when working with financial data, transactions, and sensitive information.

• Clear written and verbal communication skills, including the ability to document work so that others can understand and repeat it.

• Ability to organize assignments, balance recurring responsibilities with project work, and seek guidance when priorities or results are unclear.

• Ability to collaborate effectively with business departments, technology teams, project managers, and external partners.

Preferred Experience

• Experience with Microsoft SQL Server, Power BI, Crystal Reports, Cognos, or other reporting and visualization tools.

• Experience with financial services, banking, payments, reconciliations, file processing, workflow automation, or system testing.

• Familiarity with SharePoint, ticketing systems, and collaborative project environments.

Work Arrangement

This is a hybrid position. The employee may work remotely and will also be expected to work from the Commerce, Georgia office as needed for training, collaboration, and team development.

Equal Employment Opportunity

First Century Bank is an equal opportunity employer. It is the Company's policy to provide equal employment opportunity to all qualified persons without regard to race, color, sex, gender or gender identification, religious creed or religious beliefs, age, national origin, physical or mental disability, pregnancy, military or veteran's status, marital status, sexual orientation, or any other category protected by state or federal law.