Business Analyst / Bellevue, WA / Business / SAGS7103717
Bellevue, WA
Why Work for Us?
Established in 2006, continues to grow dramatically within the IT/telecommunications/Automobility and SCM industry. We encourage our employees in personal development with a passion to succeed and we offer an excellent benefit package. Every employee has access to Medical, Vision, Dental, Life and 401K plus many more.
401K with Employer Match
Company Paid Dental, Vision, Life and Medical up to 100%
Paid Sick Leave
Chance for VISA sponsoring
Tableau Analytics and Dashboards Promotion Analysis Sales / Financial Analysis Excel Data Modeling Sales/Finance Operations Analyst
Create and maintain financial modeling and prepare for monthly financial submissions with Category Managers Support Category Manager with promotion performance analysis tracking promotion spend, performance, lift, CPIR Interface with Machine Learning / AI team to maximize promo ROI via price elasticity modeling Support Supply Chain Manager with Forecast Accuracy analysis and reporting, provide promotion performance insights Build and maintain Tableau and Excel based dashboards and share out to team/leadership as needed Prepare Weekly Business Review reporting tracking standard business metrics and sales performance Prepare Promotion Financial summaries and submit for financial approval as needed by Category Managers Compile weekly forecasts from Category Manager and Supply Chain managers for tracking forecast accuracy metrics Analyze and report on site traffic and conversion rates as related to promotion activity Analyze and report on Gift Certificate spend and attach rates of purchase products Analyze Trade-in Program promotions and track attach rates, device mix, cost and recovery Prepare and submit documentation for promotion approval - TIM/PUMI submissions Build Tableau dashboards and reporting ad-hoc as needed by Category Manager and Supply Chain Manager
Skills and Qualifications
Strong proficiency in Tableau is required, with experience building and publishing dashboards meeting varied business needs Experience supporting a sales/marketing team in a data-centric role Experience tracking and analyzing sales promotion performance General understanding of business finance terminology and P&L Demonstrated ability to work under pressure, meet deadlines and support a fast-paced team 5 - 7 years of relevant work experience required Strong proficiency in Microsoft Excel, building advanced modeling preferred Proficiency in Excel Power Query desired
BTI Solutions, Inc. is an equal opportunity employer m/f/d/v.
recruiting@btisolutions.com
BTI Solutions
801 E Campbell Rd. Suite 230, Richardson, Texas 75081, USA
Office:+1-972-992-0030, Fax:+1-972-992-0050