Junior Business Systems and Reporting Analyst

First Century Bank; Commerce (GA); Hybrid; USD 59,000 - 72,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

First Century Bank in Commerce, GA is hiring a Business Systems and Reporting Analyst to support the Business Analytics and ACH team. The role focuses on understanding data, building reports, validating data, testing system changes, and improving business processes.

This entry-level position is intended for candidates with 0–3 years of experience and requires a bachelor's degree in a related field. The work arrangement is hybrid with three days in the Commerce office and two days at home.

Qualifications

• Bachelor's degree in business, information systems, data analysis, finance, accounting, computer science, or related field.
• 0–3 years of relevant experience preferred.
• Strong Excel skills and foundational SQL knowledge.
• Clear written and verbal communication skills.

Responsibilities

• Create, modify, and maintain reports using SQL, Excel, Power BI, Crystal Reports, Cognos or similar tools.
• Interact with stakeholders to define data needs and reporting requirements.
• Validate data accuracy across sources and identify data integrity issues.
• Perform user acceptance testing for reports and system changes.
• Document reporting procedures and data flows.
• Support new initiatives by mapping data and providing testing support.

Skills

SQL

Excel

Power BI

Crystal Reports

Cognos

Education

Bachelor's degree

Tools

SQL Server

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 elevate potential data-integrity concerns.
• Research and troubleshooting: Investigate reporting, data, and system questions; document findings; and work with the appropriate team to resolve or eliminate 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.
Salary: $65000 per year