Business Analyst

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

Benefits offered by this job

Health insurance

401(k) plan

Paid time off

Job summary

Radionix is seeking a Business Analyst to join the Sales Operations team in Fairport, NY. The role maintains a critical SQL Server sales database, consolidates distributor data, and supports commission calculations and territory changes.

You will build reports and dashboards in Power BI to drive visibility into key sales performance indicators. Qualified candidates have 5+ years of business analysis experience with hands-on SQL Server work, strong Excel skills, and proficiency in BI tools.

Qualifications

• Bachelor’s degree in a relevant field is required.
• 5+ years of business analysis experience with hands-on SQL Server work.
• Fluent in SQL and strong Microsoft SQL Server database maintenance.

Responsibilities

• Maintain SQL Server sales database and ensure data accuracy across processes.
• Collect, clean, and standardize sales data from multiple distributors.
• Write and maintain SQL queries to load, validate, and reconcile data.
• Calculate and reconcile sales commissions and support territory changes.
• Develop reporting and analytical tools to improve sales KPIs and visibility.
• Run financial analyses and monitor KPI drivers.
• Support automation and standardization through continuous improvement.

Skills

SQL Server

Power BI

Excel

Data analysis

Communication

Attention to detail

Independent work

Problem solving

Education

Bachelor’s degree in MIS/Mathematics/Economics/Business/Finance

Tools

MS Office (Word, PowerPoint, Access)

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.

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.

Principal Responsibilities

• 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.

Competencies

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 an equal 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.

#Radionix