Business Analyst

Keenfinity • Fairport, NY

1d

About The Position

The Business Analyst works in the sales operations department and maintains a critical SQL Server sales database that supports key business processes. The role collects sales data from multiple distributors, combines and validates it, and keeps the database accurate and current. It also supports sales commissions, including calculations and changes to commission processes and territories, and develops reporting and analytical tools to improve visibility into sales performance indicators.

The role conducts financial and business analysis, monitors KPIs, maintains automated reporting tools, and supports continuous improvement through automation and standardization. It also handles ad hoc sales analysis and recurring operational tasks, and serves as a business partner to management teams and other business functions.

Requirements

• Bachelor’s degree in a relevant subject area.
• At least 5 years of business analysis experience, including hands-on SQL Server work.
• Fluent in SQL, with strong hands-on experience maintaining Microsoft SQL Server databases.
• Experience combining and reconciling data from multiple external sources.
• Strong analytical, critical-thinking, and problem-solving skills.
• Excellent verbal and written communication skills.
• Advanced Microsoft Excel skills, including pivot tables, lookups, and complex formulas.
• Proficient in Power BI, including building and maintaining reports and dashboards.
• Proficient in Microsoft Office applications, including Word, PowerPoint, and Access.
• Proactive team player willing to go above and beyond to help others.
• Excellent time management and ability to prioritize tasks appropriately.
• High attention to detail and accuracy while maintaining confidentiality.
• Ability to work independently.
• Indefinite U.S. work authorization; future sponsorship for work authorization is not available.

Nice To Haves

• Degree in Management Information Systems, Mathematics, Economics, Business Administration, or Finance.
• Experience with computer scripting languages.
• Experience with SQL Server database administration and management.

Responsibilities

• Maintain and update the SQL Server sales database used by key business processes.
• Collect sales data from multiple distributors and combine, clean, and standardize it.
• Write and maintain SQL queries to load, validate, and reconcile sales data.
• Calculate and prepare sales commissions, reconcile results with sales data, and resolve discrepancies.
• Implement and document changes to sales commission processes, plans, and sales territory assignments.
• Run financial and business analysis models and sales reports.
• Monitor key performance indicators and analyze underlying performance drivers.
• Maintain and update current automated reporting tools.
• Support continuous improvement projects through automation and standardization.
• Respond to ad hoc sales analysis requests.
• Serve as a business partner to management teams and various business functions.
• Perform recurring operational tasks that support specific business processes.

Benefits

• Medical, dental, vision, disability, and life insurance.
• 401(k) plan.
• Paid time off and sick leave programs.
• Commission plan.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level