Technical Business Analyst

Title:                          Technical Business Analyst Company:                 Redemption PlusIndustry:Distributor: Toys & Prizes for Family Entertainment Centers (FEC)Brand:                        Products that perform. Services that Web:                          Location:           Ovreland Park, KSCandidate Location:  45 minute commute  Report to:               Chief Technical OfficerHybrid:                       Partial WFHVersion:                     V5About our ClientHeadquartered 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.Position SummaryMust Have:·     Applicants must be currently authorized to work in the United States on a full-time basis.·     2 years experience using SQL to analyze data from an ERP/MRP system·     2 years experience analyzing historical sales data by product.·     5 years experience at a product company between $20M and $200M in Revenue·     Must live within 40 miles of Hopkinton, MAWe 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 person we are searching for 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 SalesForceDashboard 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 areasOur productsSee 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.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  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 ·    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.General Management SkillsHigh Volume: Experience with a business that offers 1,000+ sku catalogs would be helpful.Metrics: Proven ability to discuss your accomplishments in quantitative terms and the resulting revenue metricsExperience:Minimum of 5 years of experience in business analysis, data analysis, or a related field, with at least a senior or lead role.Functional knowledge of 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).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.Salesforce APIs:Must have proven knowledge and practical applicationPersonal Attributes Required for Success:Business Acumen: Unique combination of being business-minded and highly analytical while also having a strong technical background in 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 supervisionExceptional 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 thinkingLearning: exhibits a passion for learning new technologies and methodsHigh Integrity: Put the company's reputation first in all interactionsAdaptable: 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 teammatesAble to prioritize responsibilities with the appropriate level of urgencyHas the ability to critique your own work and others' work, and absorb and apply feedbackHighly motivated and strong work ethic; someone who takes initiative and does not wait to be told to do thingsOtherTravel: Ability to travel up to 20% of the time.In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.EducationEducation: Bachelor's degree in Data Science, Statistics, Computer Science, Information Technology, or a related field.Compensation: Marketplace competitive: Base and Bonus=end=

Created: 2025-03-01