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