Share this Job

Business Analyst

Date: Aug 3, 2019

Location: Austin, TX, US, 78701

Company: A. O. Smith Corporation

Company Information


At Aquasana we believe clean water and a healthy environment are the most important components to healthy living and overall well-being. Our sole focus is providing best-in-class water filtration products so every home can enjoy great-tasting, healthy water.  Aquasana is part of A. O. Smith's North American Water Treatment division, which has experienced double-digit growth for the last several years through organic growth and acquisitions and is the primary direct-to-consumer division of the company operating the highest trafficked website across all subsidiaries.


Why Aquasana?


This is an exciting opportunity for someone looking to make a name for themselves not only with a great company but in the field of Analytics. A lot of work has been done to build Aquasana into the success story it’s been but much work remains to be done on the automation, systems infrastructure, and analytics’ capabilities front if we’re going to take Aquasana to the next chapter of continued success. YOU will be a huge part of that process.


You will get to own your own projects, build your own pipelines and datasets, and get firsthand knowledge on how to properly run a business using all the information at your disposal. This will not be the type of task where all the “grunt work” falls to a junior hire, and this won’t be akin to an internship. You will get to go beyond merely cleaning up datasets, building canned reports, and writing basic SQL scripts. You will be driving the business by delivering meaningful insights and using your analytical chops to drive changes in process, development, and fundamental changes to the business.

Primary Function


Aquasana, part of A. O. Smith's North American Water Treatment Division, is looking for a Business Analyst located out of our Austin, Texas office.  The Business Analyst will own and operate the coordination of all pricing changes in the appropriate electronic system and execute all requests for information through the writing of SQL queries, ETL process, or publishing reports to Tableau Server.


  1. Understanding all data pipeline processes, schedules, and purposes
  2. Creating data pipelines through ETL process
  3. Ad-hoc analysis and reporting in SQL Server, Excel, & Tableau
  4. Turn repeat requests into automation opportunities by identifying commonalities in like requests for information
  5. Run executive and business review meetings specific to business metrics and KPIs owned by the Business Intelligence Department, and ensure timely delivery of information by establishing update process for all reports
  6. Educate Sales, Customer Service, Marketing, and other stakeholders on the information we have at our disposal and how they might leverage it toward their goals
  7. Manage customer expectations and requests for all assigned tasks
  8. Funnel emails, IMs, and other communications into the ticketing system; either through the writing of requests on behalf of others or by educating customers on how to submit considered requests
  9. Upkeeping documentation in the ticketing system and the BI Team’s website
  10. Maintain consistent and accurate customer pricing across necessary electronic platforms.
  11. Administering pricing requests including additions/changes/deletions of products from existing price lists, new customer price lists, transfer pricing setup and maintenance, intercompany transfers, price adjustments and price blocks in SAP
  12. Maintain and build promotional codes and behaviors within SAP, including site-wide discounts.
  13. Identify new means of electronically implementing pricing updates to minimize time to go to market with new initiatives.
  14. Work closely with IT and Marketing in the implementation of new initiatives which might be related to toll free marketing campaigns.
  15. Work together with sales staff with promos and to achieve margin goals within the company.
  16. Adhere to and help to identify company pricing policies to meet internal profit margins and maintain competitiveness within the marketplace.
  17. Other duties may be assigned as needed.


  • Bachelor's Degree or equivalent relevant work experience required; Bachelor's degree preferred
    • Preferably in Mathematics, Engineering, Statistics, Logic or related quantitative and statistical reasoning discipline
  • Minimum of 1 year related work experience
  • Intermediate to advanced experience in Microsoft Excel
    • Pivot Tables
    • Formulas
    • Visualizations and table formats
  • Intermediate to advanced experience in MSFT Office Suite
  • SQL
    • Familiarity with relational database concepts required
    • 0.5 – 2 years’ experience (academic or otherwise) preferred
  • Ability to apply logic and mathematics to appropriate tools and services
  • Excellent written and oral communication skills
  • Tableau experience a plus
  • Jira experience a plus

We Offer

Competitive base salary, bonus plan and comprehensive benefits plans which include medical and dental insurance, company-sponsored life insurance, retirement security savings plan, short- and long-term disability programs and tuition assistance.  Employee discounts on water filtration products are included along with a casual dress code. This role is in our dog-friendly Austin, Texas office (near Pease Park) with free parking and weekly delivery of free snacks/fruit to the office.

Nearest Major Market: Austin

Job Segment: Business Analyst, Engineer, ERP, Intern, Database, Finance, Engineering, Technology, Entry Level