Business Analyst

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

Requirements

• 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 the company 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 the company 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
• Company 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.