Company: Derby Management is recruiting this position for Redemption Plus
Industry: Distributor of Toys and Gifts for Family Entertainment Centers(FEC)
Brand: Products that perform, Services that simplify
HQ Location: Boston Area, South-West of Mass Pike
Reports to: President
Hybrid: Partial WFH
Version: V3
About our Client Headquartered south of the Mass Pike , near major highways; Redemption Plus is a large distributor of Toys that thrives on innovation. With thousands of customers, they are the premier source for redemption toys and novelties.
Since 1996, Redemption Plus has been helping customers grow game room revenues with redemption, crane, and merchandiser prizes.
In addition to data-driven prize curation, we also provide valuable redemption management training and technology solutions to empower employees and help businesses waste less time and resources on mismanaged inventory.
The company is privately owned and has grown to be a dominant player in each industry segment.
Summary We are looking for a highly skilled Technical Business Analyst to join our team. The ideal candidate will have a strong background in data analysis, extensive experience with SQL, and the ability to translate data insights into actionable business strategies.
The ideal candidate will possess deep technical expertise in SQL report writing and development, including Apex, Lightning Components, Visualforce, and integrations with third-party systems.
This role requires someone who can design, develop, and implement robust data solutions while working closely with stakeholders to understand business requirements.
Primary Roles & Responsibilities:
Technical Business Analyst: Develops an understanding of existing CRM and Price Management Tools and their processes, and identifies, suggests, and implements improvements to existing and new tools.
They also support the business with day-to-day CRM / ERP, SQL report writing to derive insights; and functionality and relevant supporting systems.
Data Analysis and Reporting: Analyze and interpret complex data sets related to SQL to provide insights and recommendations to stakeholders.
Design and develop Custom Salesforce solutions: use Apex, Visualforce, Lightning Components, and SQL.
Salesforce Data Management: Ensure data integrity and accuracy within Salesforce by performing regular data audits and cleaning. Also, create and deploy reports and scripts in SalesForce
Dashboard Creation: Develop and maintain Salesforce dashboards and reports to track key performance indicators (KPIs) and other business metrics.
Collaboration with Teams: Work closely with sales, marketing, and operations teams to understand their data needs and provide analytical support.
Data Migration and Integration: Assist in data migration projects and ensure seamless integration of Salesforce with other business systems.
Training and Support: Provide training and support to end-users on data-related functionalities within Salesforce.
Performance Monitoring: Monitor Salesforce system performance and recommend improvements for data management processes. Run reports in SQL to derive business insights - sales, inventory, etc.
Demand Planning: Assist with customer demand planning analysis, in-stock reporting, and financial forecast planning/reporting.
Business Process Management: Maintains existing and develops new company business processes and approval workflows to increase effectiveness across departments by following Sales and Lead Pipeline process procedures, data management, and the conservation of account records.
Data Analysis and Reporting - Develop, track, and deliver reports that capture key metrics to determine trends that help drive business decisions.
ERP: Assist product team in SAGE POs uploading and forecasting
Our CustomersCurrently Redemption Plus works with large and medium size players in three large verticals:• Large Family Entertain Centers (FEC) operators like Dave & Busters• Small and Medium Multiple location retail outlets with Arcades (bowling alleys, movie theatres, etc)• Route operators that service "Crane Machines" in high-traffic areas
Our products
See http://www.redemptionplus.com/
The Search ProcessDerby Management is coordinating the search process for Redemption PlusRedemption Plus, recognizes that past and future success is directly related to the quality of the people on the team.
Through careful selection, the company had identified individuals who possess the ability, desire, and dedication to grow with Redemption Plus. Why is our client a great career move?If you would like to work for a company where your creative skills are essential to success, and your proven past successes are appreciated and valued, then please read further.
Success in this senior analytical position is defined by an individual who loves the professions of Marketing Analytics, Sales, and Data Science, and wants the opportunity to drive customer value and is committed to making it happen.
The result of these efforts is a base of highly satisfied customers providing the ability for the company to increase "share of wallet" in current markets, drive lead generation, and expand into additional markets.
The company believes your assessment of customers, products, and market developments is essential information to run the business profitably.
Required Data Science and Business Analytics Skills :•
Develop, troubleshoot, and maintain code and web pages using Classic ASP.
Develop, troubleshoot, and maintain code and web applications using VB.Net and various components of the .NET Framework.•
Develop, troubleshoot, and maintain code and web pages using PHP.•
Develop, troubleshoot, and maintain scripts for automation with python.•
Salesforce Application development; including Visualforce pages/Lightning pages, Lightning Web Components, apex classes and triggers.•
Create, Deploy, and maintain Objects in Salesforce.com•
Create, Deploy, and maintain reports in Salesforce.com•
Understanding of statistical analysis techniques and methodologies.•
Create interactive dashboards and visualizations using tools such as Tableau, Power BI, or similar.•
Knowledge of data modeling concepts and database design principles.•
Familiarity with data visualization tools (e.g., Tableau, Power BI)•
Proficiency in SQL for database management and data manipulation:•
Create, Deploy, and maintain Microsoft SQL queries, stored procedures, and functions.•
Create, Deploy, and maintain Microsoft Report Services datasets and reports.•
Write efficient SQL queries to extract, manipulate, and analyze data from relational databases.
Nice to have skills:• Experience managing workflow with Realisable IMan•
Experience creating, managing, and automating tasks with VisualCron•
familiarity with Sage 300 ERP•
Understanding of machine learning concepts is a plus.
Experience:
Minimum of 6 years of experience in business analysis, data analysis, or a related field, with at least a senior or lead role.
Functional knowledge of Salesforce.com data structure and understanding of how to leverage the tool to meet complex process and reporting requirementsProficiency in data analysis tools (e.g., SQL, Excel, Tableau, Power BI).
Proven experience as a data analyst, preferably with a focus on Salesforce.
Experience with Salesforce reporting tools such as Salesforce Reports, Dashboards, and Einstein Analytics.
Experience monitoring and analyzing metrics with the ability to create actionable insights.
Proficiency in Salesforce CRM; using and building reports to monitor and analyze new business opportunities and sales programs, dashboard experience preferred.
Must have proven knowledge and practical application of the Salesforce APIs
Personal Attributes Required for Success:
Business Acumen: Unique combination of being business-minded and highly analytical while also having a strong technical background in Salesforce.com
Personal Productivity: Ability to maintain a high level of activity, manages multiple competing priorities, and work effectively in a results-driven culture.
Minimal Oversight: Able and willing to work independently with minimal supervision
Exceptional Communication abilities: written, verbal, and presentation communication skills.
Organization and Details: Attention to detail, excellent organizational and time management skills. Commitment to "right the first time"
Initiative: Take initiative to recommend process improvements and demonstrate creative thinking
Learning: exhibits a passion for learning new technologies and methods
High Integrity: Put the company's reputation first in all interactions
Adaptable: Priorities often change due to customer circumstances. Ability to excel in an environment where your focus may have to shift.
Self Confident so that you know anything is possible with hard work, planning, and good teammates
Able to prioritize responsibilities with the appropriate level of urgency
Has the ability to critique your own work and others' work, and absorb and apply feedback
Highly motivated and strong work ethic; someone who takes initiative and does not wait to be told to do things
Other Travel: Ability to travel up to 20% of the time.
Education. Education: Bachelor's degree in Data Science, Statistics, Computer Science, Information Technology, or a related field.
Compensation. Marketplace competitive: Base and Bonus