Business Intelligence Analyst (Store Support Center, Lenexa, KS)

About Ace Retail Holdings

Ace Retail Holdings (ARH), the division of Ace Hardware Corporation that owns and operates the Great Lakes and Westlake Ace Hardware chains, is one of the largest hardware retailers in the United States.  ARH has been in operation for over a century and operates over 220 neighborhood stores located throughout the United States.  Great people make ARH stand out in our industry, and we are looking for individuals who strive for personal and professional growth, and who want to work with a company dedicated to serving our customers and communities.

Service, Passion, Respect, Integrity, Teamwork and Excellence

Job Title:            Business Intelligence Analyst             
Department:               Information Technology
Reports To:                 Senior Manager, Data Analytics & Reporting
Exemption Status:     Exempt (Salary)

About Westlake Ace Hardware
Ace Retail Holdings (ARH), the division of Ace Hardware Corporation that owns and operates the Great Lakes and Westlake Ace Hardware chains, is one of the largest hardware retailers in the United States. ARH has been in operation for over a century and operates over 220 neighborhood stores located throughout the United States. Great people make ARH stand out in our industry, and we are looking for individuals who strive for personal and professional growth, and who want to work with a company dedicated to serving our customers and communities.

General Job Summary
This Business Intelligence Analyst position will be responsible for the development and maintenance of data-driven reporting and analytics solutions that will be used by the organization to help make informed business decisions.
Essential Duties and Responsibilities   
•    Oversee end-to-end development of reporting, primarily using Microsoft software such as Power BI and SSRS, including the creation and maintenance of data models to achieve business objectives.
•    Work with internal customers across multiple business units to understand their needs and build solutions accordingly.
•    Maintain the seamless operation of existing reports and dashboards, identifying and resolving issues related to performance, data quality, and reliability.
•    Assist with converting legacy reports to newer Power BI or SSRS solutions.
•    Assist with maintenance and enhancement of existing SQL Server data warehouse.
•    Document current operational processes and workflows as needed.
•    Handle ad hoc data-related requests as needed.
Other Essential Requirements
Ability to exhibit and incorporate our Core Values into daily decisions and interactions with others:
o    WINNING – In business, money is the score. To win, we must perform, compete, and have fun. At Ace, we win through people- our strength is being helpful.
o    EXCELLENCE – Excellence honors God and inspires people. We aspire to be the best, to continuously improve and to inspire others by giving the team our very best.
o    LOVE – Love the people, love the work and love the results.
o    INTEGRITY – For Ace to win, we need to be able to trust each other. And trust will require us to be honest, reliable, caring, of high character and of unquestioned ethics.
o    GRATITUDE – We recognize that we are blessed to be in the business of serving others.
o    HUMILITY – We strive for greatness with a humble, modest and respectful attitude.
o    TEAMWORK – We will fight the natural tendency for control and credit in favor of collaboration and mutual success, recognizing that…Together, we are Ace. 

Minimum Skills, Requirements and Qualifications
•    Bachelor’s degree or equivalent combination of education and experience preferred.
•    At least six months of experience with development of reports and dashboards, including usage of Power BI, Microsoft SSRS, and SQL Server database queries.
•    Willingness to learn new systems and technologies; eagerness to develop analytical and report writing skills with a passion for data.
•    Strong communication skills, with ability to discuss requirements and data insights with both technical and non-technical stakeholders.
•    Understanding of relational database principles.
•    Self-motivated with the ability to work in a fast-paced and ever-changing environment.
•    Strong ability to multitask and prioritize projects.
•    Application development experience is a plus.
•    Prior experience with SSAS, Power Apps, Access, and/or Microstrategy is a plus.
•    Prior experience within a retail store support setting is a plus.

Compensation Details

$60000/year

For a full list of benefits and open positions, please visit us at: