Business Systems Analyst (Advanced Excel)

2008 Business Systems Analyst

Heavy Excel, Data Analysis, Issue Resolution, and Cross-Functional Business/IT Collaboration.

Position Overview

We are looking for a highly analytical Business Systems Analyst to help monitor business processes, identify data issues, investigate system problems, and work with IT teams to ensure issues are resolved.

This role is ideal for someone who enjoys working with large datasets, solving problems, identifying trends, and serving as a bridge between business users and technical teams.

The successful candidate will spend much of their time analyzing reports, validating data, researching issues, creating support tickets, tracking resolutions, and helping improve overall business operations.

Responsibilities

• Monitor reports and business data for errors, discrepancies, and missing information.
• Analyze large datasets using Excel and other reporting tools.
• Investigate data quality issues and identify root causes.
• Create detailed issue tickets for IT and development teams.
• Track issues through resolution and validate fixes.
• Work closely with business users, IT, product, and data teams.
• Identify recurring problems and recommend process improvements.
• Maintain issue logs, status reports, and documentation.
• Support ongoing efforts to improve data quality and operational efficiency.

Required Qualifications

• 2+ years of experience in:
• Business Analysis
• Data Analysis
• Operations Analysis
• Application Support
• Production Support
• Business Systems Analysis
• Advanced Microsoft Excel skills including:
• XLOOKUP/VLOOKUP
• Pivot Tables
• Filtering & Sorting
• Data Validation
• Working with large datasets
• Experience identifying, researching, and resolving data or system issues.
• Experience working with ticketing systems such as Jira, Salesforce, ServiceNow, or similar tools.
• Strong analytical and problem-solving skills.
• Excellent communication skills and ability to work with both technical and non-technical stakeholders.
• Highly organized with strong attention to detail.

Preferred Qualifications

• Salesforce experience.
• Data quality or data governance experience.
• Application Support or Production Support experience.
• Experience working with system integrations or enterprise applications.
• Automotive, financial services, lending, or operations experience.

Ideal Backgrounds

• Business Systems Analyst
• Data Analyst
• Operations Analyst
• Application Support Analyst
• Production Support Analyst
• Salesforce Analyst
• Data Quality Analyst
• QA Analyst
• Incident Management Analyst

Success in This Role

You enjoy working with data, solving problems, identifying trends, and ensuring business processes run smoothly. You take ownership of issues, communicate effectively across teams, and follow through until problems are fully resolved.