Business Analyst

Keenfinity; Village of Fairport (NY); On-site; USD 90,000 - 115,000; Full time

Benefits offered by this job

Health plan

401(k)

Paid time off

Life insurance

Job summary

Keenfinity in Fairport, NY is hiring a Business Analyst to support Radionix sales operations in the United States. You will maintain a critical SQL Server sales database, gather data from distributors, and develop reporting tools to improve visibility into KPIs.

Ideal candidates have 5+ years in business analysis, strong SQL Server, Power BI, and Excel skills, plus the ability to collaborate across teams. Base salary range 90,000–115,000 USD with benefits.

Qualifications

• Minimum 5+ years of business analysis experience with hands-on SQL Server work.
• Fluent in SQL with strong Microsoft SQL Server database skills.
• Proven ability to combine and reconcile data from multiple sources.
• Excellent analytical, communication, and problem-solving skills.
• Advanced Excel with pivot tables, lookups and complex formulas; Power BI dashboards.

Responsibilities

• Maintain and update the SQL Server sales database used by key processes.
• Collect data from distributors, clean, merge, and standardize it.
• Write SQL queries to load, validate, and reconcile sales data.
• Calculate and prepare sales commissions; reconcile with data and adjust as needed.
• Document changes to commission processes and territory assignments.
• Run financial analyses and develop KPI dashboards and reports.
• Monitor KPIs and analyze drivers of performance.
• Support automated reporting tools and continuous improvement projects.

Skills

SQL

SQL Server

Data Analysis

Power BI

Excel

Communication

Detail oriented

Independent worker

Team player

Education

Bachelor's degree

MIS/Math/Econ/Business

Tools

SQL Server

MS Office

Power BI

Job description

The Radionix name holds a special place in the hearts of our associates, dealers, distributors, and customers alike. The new Radionix vision — Mission control for your security — encapsulates our focus on empowering users with an intrusion system that seamlessly integrates every layer of security, from our intrusion system products to our G Series panels to our reimagined Remote Security Manger app.

Fairport, NY is the headquarters for the Radionix sales & marketing organization in the United States and serves as the primary site for research and development, engineering, quality, and product management for intrusion detection systems, including state-of-the-art sensors, control panels, software, communications and more.

Job Description

The Business Analyst works within the sales operations department and is primarily responsible for maintaining a critical SQL Server sales database that a number of key Radionix business processes depend on. The position gathers sales data from multiple distributors, combines and validates it, and uses it to keep the database accurate and current. The position also supports the sales commission process, including commission calculations and commission process and territory changes, and develops reporting and analytical tools that improve visibility into key sales performance indicators.

• Maintain and update the SQL Server sales database that key business processes rely on
• Collect sales data from multiple distributors and combine, clean, and standardize it
• Write and maintain SQL queries to load, validate, and reconcile sales data in the database
• Calculate and prepare sales commissions, reconciling results with sales data and resolving discrepancies
• Implement and document changes to sales commission processes, plans, and sales territory assignments
• Run financial / business analysis models and sales reports
• Monitor key performance indicators (KPI’s) and analyze underlying performance drivers
• Perform maintenance and updates to current automated reporting tools
• Support continuous improvement projects through automation and standardization
• Perform ad hoc sales analysis requests as needed
• Serve as a business partner to management teams and various business functions
• Perform recurring operational tasks to support specific business processes
• Ensure compliance with relevant corporate guidelines and procedures

Qualifications

Education

• Bachelor’s degree in relevant subject area required. Degree in Management Information Systems, Mathematics, Economics, Business Administration, or Finance preferred.

Experience

• Minimum 5+ years of business analysis experience, including hands-on SQL Server work.

Required competencies include:

• 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 MS Office applications: Word, PowerPoint, and Access
• Proactive team player who is willing to go above and beyond to help others
• Excellent time management skills, ability to prioritize tasks appropriately
• Applies high level of attention to detail and accuracy while maintaining confidentiality
• Ability to work independently

Desired competencies include:

• Experience with computer scripting languages
• Experience with SQL Server database administration and management

Additional Information

The U.S. base salary range for this full-time position is $90,000-115,000 per year. Within the range, individual pay is determined based on several factors, including, but not limited to, work experience and job knowledge, complexity of the role, job location, etc.

In addition to a base salary and commission plan, full-time employees are eligible to participate in Keenfinity Group's (US) Health and Welfare Benefit Plans—including medical, dental, vision, disability, and life insurance—as well as the company’s 401(k) plan, subject to the terms and conditions of the respective plan documents. Full-time employees are eligible to participate in Keenfinity Group’s paid time off and sick leave programs in accordance with applicable policies.

• Reasonable accommodations may be made, to the extent they do not pose an undue hardship, to enable qualified individuals with covered disabilities to perform essential functions.
• Indefinite U.S. work authorized individuals only. Future sponsorship for work authorization is not available.
• All of your information will be kept confidential according to EEO guidelines.

At Radionix, we value different backgrounds, ideas, and experiences and we’re committed to growing, learning, and celebrating success as one team. Everyone is welcome here — we foster an environment where everyone is respected, valued, and encouraged to be their authentic self. Radionix is anequal opportunity employer, offering equal opportunities for all. We welcome applications from people with disabilities and can offer support, if needed. When everyone has a chance to contribute, we all do better.