Sr. Business Analyst

The Senior Business Analyst reports to the Pricing & Analytics Manager as part of the Pricing & Analytics team, and is tasked with report creation, development, and refinement (Power BI, Excel), data querying (SQL, SAP, ADW Tables), analytics and other ad hoc requests.
These tasks relate to the reporting of all performance metrics with a specific focus on revenue and profitability for the wholesale subsidiary of Ace Hardware, Emery Jensen Distribution (EJD). The channels that comprise EJD are designated as Pro Lumber Yards, E-Commerce, Hardware, Paint, and Grocery. Each Channel will require separate analysis.
Reporting and analysis responsibilities include, but are not limited to, top and bottom-line profitability on vendors and items; on customers, channels and retail markets; assortments, programs, and products; vendor programs, promotional offerings; and efficiency measurables.
The Senior Business Analyst works hand in hand with the appropriate Pricing & Analytics, Sales, Merchandising, Operational, and Finance team members to ensure visibility to financial and performance metrics.
What youll do Create, develop and refine Power BI dashboards. These dashboards, which are used by the EJD Sales, Finance, Merchandising and Leadership teams are crucial for the tracking and monitoring of EJD revenue, sales, margin and customer profitability results and performance.Develop and publish timely routine reports (monthly, quarterly, annually) that provide visibility and insight into sales, profitability and financial performance by channel, category, vendor, and customer to enable achievement of short- and long-term sales and profitability goals. (e.g.: Merch Stats, Customer Profitability, Promotional Billbacks)Analyze reports and provide insights and recommendations to improve sales and profitability. In partnership with the Pricing & Analytics Manager, support with and lead ad hoc reporting development and analysis projects. Communicate findings to stakeholders and EJD leadership team.Support the Finance, Sales and Merchandising teams with developing budget targets and create templates and files to report and track progress.Train other EJD team members on the use and best practices of Power BI dashboardsBuild and provide ad-hoc reports and analysis as needed: including the data gathering. Provide data from SAP and ADW via ad-hoc query pulls when requested.Works and communicates with EJD Department leads, Finance, Merchandising, Sales,Operations and ACE Analyst peersMentor, coach, and cross-train Pricing & Analytics team members (including Business Analyst, Sales Data Analyst, and Pricing Specialist) to help team members grow and develop and ensure there is strong coverage and capabilities across the team. Support with other Pricing & Analytics team responsibilities when team members are out of office.What you need to succeed.. Ability to write queries using SQL and Dax
Ability to develop data visualization tools (Power BI)
Strong Excel skills
Duties require knowledge of commonly used concepts, practices & procedures for Financial Analysis and Reporting
4-year college degree and at least 5-7 years of related work experience
Proficient in Microsoft Outlook, Word, Access, Power Point
Knowledge of SAP and guided Ad-hoc reporting tools
Proven ability to multi-task projects and meet deadlines
Strong interpersonal and written/verbal communications skills
Proactive, detail oriented, well organized
#LI-AC1
Compensation Details: $80000 - $103000
Why should you join our team? We live our values - W.E.L.I.G.H.T (Winning, Excellence, Love, Integrity, Gratitude, Humility, and Teamwork). Gratitude. Humility. Love. You dont often see values like these in most corporate statements, but Ace is different. These things are important to us. They represent our commitment to the company, our employees, to Ace retailers and to the Ace brand.
In addition to providing our employees a great culture, Ace / Emery Jensen Distribution also offers competitive benefits* that address lifes necessities and perks, many of which expand and improve year after year, including:
Incentive opportunities, based on role/grade level (rapid company growth over the past 3 years resulted in incentives being paid out above 106.6% of your target opportunity!)Generous 401(k) retirement savings plan with a fully vested matching contribution the first year, in addition to an annual discretionary contribution (once eligibility requirements have been met). Over the past five years, company contributions (matching & discretionary) for fully eligible employees have averaged 7.5% of total compensation.Comprehensive health coverage (medical, dental, vision and disability up to 26 weeks short-term disability and long-term disability) & life insurance benefits for you and your dependents21 days of vacation immediately available (prorated in the first year) and up to 6 paid holidays depending on the month of hireCompany Car, phone and fuel card are provided for field-based positionsFlexible working arrangements (Non-Field positions can work from home up to 2 days per week)Your career at Ace is more than just a job. Its a chance to be part of something meaningful. We help locally-owned businesses thrive and make an impact in their communities and we support our employees in doing the same by offering an annual Ace Cares Week, 20 hours off work per year to volunteer at an organization of your choice, opportunities to help Childrens Miracle Network Hospitals and the Ace Helpful Fund through the Ace FoundationAce invests in every employee we hire, with a key focus on development and coaching. We offer on-site classes, facilitator-led courses, and a generous tuition assistance program, plus a performance management approach that goes beyond the typical annual reviewWe know the work environment matters. Thats why Ace holds frequent campus events like Employee Appreciation Week, vendor demos, cookouts, and merchandise salesWe bring them to you! Services such as mobile spas, auto maintenance, car wash and detailing, dry cleaning, dentists, eye doctors, flu shots, recycling and more!Employee discounts on Ace merchandise (including top brands like Weber, Traeger, Yeti, Craftsman, DeWalt and more), travel, fitness, computers and thousands moreBirth/Adoption bonding paid time offAdoption cost reimbursementEmployee Assistance Program (EAP) access to free visits to therapists and lawyers, guidance on financial matters, elder and childcare, and assistance with tickets to entertainment eventsIdentity theft protection* Benefits are provided in compliance with applicable policies. Want to be notified when new jobs are posted? Follow the link below to create an account and set up custom job alerts: Create Job Alert We want to hear from you!
Emery Jensen Distribution delivers wholesale products and best-in-class service to independent retailers in the Pro Lumber Yards, Home Centers, Paint, Hardware Stores, Decorating Stores, and E-retailer space. Our goal is to support sustainable and profitable growth for our customers by offering the broadest assortments, best pricing, and most knowledgeable team. We have national scale, a regional focus and the commitment to serve our customers and support each other. Come find out why a career with Emery Jensen Distribution is right for you.
Equal Opportunity Employer
Emery Jensen Distribution is committed to a policy of promoting equal employment opportunities. The company recognizes the importance of diversity and leveraging the skills and talents of all people to the mutual advantage of each individual and the organization. The company is committed to the prevention of employment discrimination related to race, religion, color, sex (including sexual harassment), gender identity, national origin, age, marital status, disability and military or veteran status, sexual orientation or any other action covered by federal or applicable state/local laws.
Disclaimer The pay range for this position starts as listed in the job posting, but could be higher based on education and experience. Please note, compensation decisions are dependent on the facts and circumstances of each opening. We take into consideration the minimum requirements outlined in the job description, such as an individuals education, training and experience, the positions work location, required travel (if any), and external market conditions when determining the final salary for potential new hires. Be aware that salary estimates published via alternate online job boards may not be a true representation of the actual pay range offered for this position. Please refer to the Emery Jensen Distribution position description for the accurate starting pay range information and feel free to discuss this with a Talent Acquisition professional if you are chosen to move forward with an interview. This written Position Description is not intended to cover all aspects of the position listed. It is meant to cover the basic/general essential job functions of a particular position. Emery Jensen Distribution reserves the right to change job duties, including essential job functions, according to business necessity. Required Preferred Job IndustriesCustomer Service