Business Analyst

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

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

Bachelor’s degree in relevant subject area required. Degree in Management Information Systems, Mathematics, Economics, Business Administration, or Finance preferred.; Minimum 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 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

Nice to have

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