Business Analyst

GCU of USA; Pennsylvania; On-site; USD 75,000 - 110,000; Full time

Job summary

GCU of USA is seeking a Business Analyst to bridge business units and Information Technology, gathering requirements, supporting data warehouse initiatives, and developing reports and queries to enhance operational efficiency and decision-making.

The role emphasizes experience with SQL databases and Power BI, with responsibilities spanning reporting, data validation, and end-user training across enterprise systems in a financial services context.

Qualifications

• Bachelor's degree in Information Systems, Computer Science, Business Administration, Data Analytics, or related field preferred.
• Equivalent combination of education and experience may be considered.
• 3+ years of Business Analyst, Data Analyst, or related experience.
• Experience with SQL Server and relational databases.
• Experience with data warehouse concepts, ETL processes, and reporting solutions.
• Experience with Power BI, SSRS, or similar BI tools preferred.

Responsibilities

• Act as a liaison between business departments and IT to gather requirements and implement solutions.
• Support data warehouse initiatives and develop reports and queries.
• Assist with system administration activities and user access management.
• Develop dashboards and reports to support decision-making and performance tracking.
• Document processes, workflows, and training materials.
• Collaborate on cross-functional technology projects and coordinate testing/UAT.

Skills

Analytical thinking

Communication

Cross-functional collaboration

Problem-solving

Documentation

Education

Bachelor's degree in Information Systems/CS/Business Administration/Data Analytics

Tools

SQL Server

Power BI

SSRS

SSMS

Power Platform

Excel

Active Directory / Entra ID

Job description

The Business Analyst serves as a liaison between business departments and Information Technology to identify, analyze, and implement solutions that improve operational efficiency, reporting, and business decision-making. This role is responsible for gathering business requirements, supporting data warehouse initiatives, developing reports and queries, and assisting with system administration activities. The ideal candidate possesses strong analytical skills, experience working with SQL databases and reporting tools, and an understanding of enterprise business systems within a financial services environment.

Business Analysis

• Collaborate with business stakeholders to understand operational needs, processes, and reporting requirements.
• Gather, document, and validate business and technical requirements.
• Analyze existing business processes and recommend improvements to increase efficiency and effectiveness.
• Facilitate communication between technical teams and business users.
• Assist with project planning, testing, implementation, and post-deployment support.
• Develop process documentation, workflows, and training materials.
• Experience in application Webdocs, Equisoft Oipa, Microsoft dynamics, powerbi

Data Warehouse & Reporting

• Create, maintain and Optimize SQL Server database.
• Create, maintain, and optimize SQL queries, stored procedures, and reporting datasets.
• Support data warehouse initiatives, including data validation, transformation, and quality assurance.
• Assist with data integration processes and troubleshooting data-related issues.
• Develop and maintain dashboards and reports using Power BI and other reporting tools.
• Analyze trends and business metrics to support organizational decision-making.
• Work with business users to define key performance indicators (KPIs) and reporting requirements.

Systems Administration Support

• Provide basic administration and support for business applications and enterprise systems.
• Assist with user account management, security permissions, and system configuration.
• Support software upgrades, testing, and implementation activities.
• Monitor application performance and coordinate issue resolution with vendors and internal IT staff.
• Assist with documentation of system configurations, procedures, and support processes.
• Participate in troubleshooting efforts involving databases, applications, and integrated systems.

Project & Operational Support

• Participate in cross-functional technology projects.
• Coordinate testing activities and user acceptance testing (UAT).
• Maintain accurate project and system documentation.
• Help identify risks, dependencies, and opportunities for process improvement.
• Provide end-user support and training for reporting and business applications.

Qualifications:

Education

• Bachelor's degree in Information Systems, Computer Science, Business Administration, Data Analytics, or related field preferred.
• Equivalent combination of education and experience may be considered.

Experience

• 3+ years of Business Analyst, Data Analyst, or related experience.
• Experience working with SQL Server and relational databases.
• Experience with data warehouse concepts, ETL processes, and reporting solutions.
• Experience with Power BI, SSRS, or similar business intelligence tools preferred.
• Exposure to financial services, insurance, or membership-based organizations is a plus.
• Basic systems administration experience preferred.

Technical Skills

• Proficiency with SQL querying, reporting, and data analysis.
• Understanding of data warehouse architecture and data integration concepts.
• Experience with Microsoft SQL Server Management Studio (SSMS).
• Familiarity with Microsoft 365 applications, including Excel, Teams, SharePoint, and Power Platform.
• Basic knowledge of Active Directory, Entra ID, and business application administration.
• Strong documentation and process-mapping skills.
• Strong analytical and problem-solving abilities.
• Excellent verbal and written communication skills.
• Ability to manage multiple priorities and deadlines.
• Strong attention to detail and data accuracy.
• Customer-service mindset with the ability to work effectively across departments.
• Ability to translate technical concepts into business-friendly language.

GCU is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religious creed, religion, ancestry, national origin, sex (including pregnancy, sexual orientation, and gender identity), age, disability, genetic information, military or veteran status, or any other status protected by applicable law. GCU provides reasonable accommodations to qualified applicants and employees with disabilities in accordance with applicable law.

This job description is intended to describe the general nature and level of work performed by the employee assigned to this role. It is not intended to be an exhaustive list of all responsibilities, duties, qualifications, or working conditions. Responsibilities may be modified to meet the needs of GCU.