Business Systems Analyst: SQL Reporting & Solutions

First Financial Bank; Kentucky; On-site; USD 65,000 - 90,000; Full time

Job summary

Summit Funding Group, Inc. in Mason, OH is hiring a full-time Business Systems Analyst, SFG to support Operational Accounting and IT. The role focuses on developing reports, writing and optimizing SQL queries, and aligning systems with business needs.

You will become a subject matter expert on Summit tools, serve as the IT liaison with First Financial Bank, and provide end-user support while maintaining thorough documentation and compliance.

Qualifications

• Bachelor’s degree in Information Systems, Business, Computer Science, or a related field.
• 1–3 years of relevant experience; or an equivalent combination of education and experience
• Experience with report writing and SQL
• Strong analytical, problem-solving, and communication skills
• Experience in system administration, configuration, and troubleshooting
• Ability to collaborate effectively with IT teams and business units
• Knowledge of system security, compliance, and documentation practices
• MS Office proficiency
• Experience with user testing and project management

Responsibilities

• Develop and generate business reports using various tools and SQL queries.
• Write, optimize, and maintain SQL queries for data extraction, analysis, and reporting.
• Administer and configure business systems to align with user and organizational needs; oversee system upgrades, modifications, and enhancements; adhere to a standardized user acceptance testing (UAT) process, including change management and thorough documentation.
• Become a subject matter expert (SME) on Summit tools and applications, serving as the IT liaison between Summit and FFB to facilitate communication and resolve system-related issues.
• Provide technical support for end users, troubleshooting system issues, and coordinating solutions, including monitoring request tickets via ServiceFirst.
• Collaborate with stakeholders to gather and document business requirements and define scope for technical projects.
• Analyze and interpret data to identify trends and support business decisions.
• Maintain system documentation and procedures, ensuring compliance with company policies.
• Identify and recommend opportunities for process and system improvements.
• Conduct user training and provide ongoing support for business systems.

Skills

SQL

Report writing

Analytical skills

Communication skills

System administration

Troubleshooting

Project management

MS Office

Education

Bachelor’s degree in Information Systems, Business, Computer Science, or related field

Tools

ServiceFirst

Aspire v5

Crystal reporting

SQL Server Management Studio

Microsoft Visio

Job description

Summit Funding Group, Inc. in Mason, OH is hiring a full-time Business Systems Analyst, SFG to support Operational Accounting and IT. The role focuses on developing reports, writing and optimizing SQL queries, and aligning systems with business needs.

You will become a subject matter expert on Summit tools, serve as the IT liaison with First Financial Bank, and provide end-user support while maintaining thorough documentation and compliance.