Regional Business Intelligence Analyst

ABC Supply, the nation’s largest distributor of exterior building products, is seeking a talented Regional Business Intelligence Analyst to join its team. This role will provide hands-on customer/product-focused analysis by developing reports, tools, and dashboards for use by management at various levels within the organization. This person will work at the West Region Office in Tempe, AZ

Reporting to the Vice President of the Region, this associate will manipulate data to create actionable outputs and reports. These outputs will support decision making and suggest actionable conclusions throughout key areas of pricing and merchandising. The associate must also be able to function independently by finding trends or issues and bringing them to attention.

Job duties may include:

• Retrieve, manipulate, and validate pricing and merchandising data into actionable outputs both in conjunction with our SQL data warehouse team and on your own.

• Automate various reporting, email distribution, and light application tasks in SQL, Excel, and Outlook using Python and PowerShell.

• Support region-wide implementation of pricing resets by automating and managing analytical tools and processes that assist field pricing teams in making more informed pricing decisions.

• Author, schedule, and run recurring reports, dashboards, and quarterly review materials.

• Run ad-hoc analysis to answer complex business questions as needed.

Specific qualifications include:

• Bachelor’s Degree required (Business, Accounting, Computer Science, Mathematics, Analytics, or Statistics preferred)

• Proven ability to develop in SQL.

• Intermediate Microsoft Excel skills including vlookups, formulas, and pivot tables required

• Proven ability to manipulate data and run ad hoc analysis (2+ years experience)

• Experience using Python, R, Tableau and/or Answers and other computer coding preferred.

Skills and traits:

• Strong data manipulation and problem solving skills required.

• Self-directed time and project management skills required.

• Ability to work independently or in a group setting with a complex flow of information.

Benefits may include:

• Health, dental, and vision coverage - eligible after 60 days, low out of pocket

• 401(k) with generous company match - eligible after 60 days, immediately vested

• Employer paid employee assistance program

• Employer paid short term and long term disability

• Employer paid life insurance

• Flex spending

• Paid vacation

• Paid sick days

• Paid holidays