Share this Job

Date: Aug 31, 2017

Location: Austin, TX, US, 78701

Company: A. O. Smith Corporation

Company / Location Information

Aquasana is a leader in water filtration. Our filters are marketed in nearly every country around the world. Our mission to make whole-body ‘water health’ as easy, accessible and economical as possible.

Aquasana drinking water filters strip out more than 99% of the chlorine, lead, herbicides, pesticides, industrial solvents and cysts found in tap water while preserving its healthiest elements, which include calcium, magnesium and potassium. Aquasana shower filters remove nearly double the amount of chlorine required for certification without sacrificing shower height or water pressure. Aquasana whole house filters remove 99% of chlorine from a household water supply and can also be customized to tackle customers’ specific water challenges. The filters produce the healthiest and best-tasting water available.

Health-conscious consumers know that it is critical to filter tap water before they drink it, cook with it or bathe in it because it is loaded with harmful chemicals. Only 91 contaminants are regulated by the Safe Drinking Water Act, yet more than 60,000 chemicals are used within the U.S. Aquasana was acquired by A. O. Smith Corporation in 2016.  A. O. Smith is a global leader in water technology which includes water heating and treatment. This position would ideally be located at our facility in Austin, Texas (in the Dallas/Fort Worth area); however, our facility in Milwaukee at our Corporate Technology Center may also be considered.



Primary Function

Responsible for the identification and resolution of information flow, content issues and the transformation of business requirements into logical data models.  Help identify opportunities to reduce data redundancy, trends in data uses and single sources of data.  Responsible for analyzing complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements.  Understand the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations.


  • Maintain a complete operations and business scorecards that provide visibility into the business and marketing activities and work with business stakeholders to align the reports using tools like Microsoft Excel, Microsoft Dynamics, BIME analytics, SSRS and SQL Server.
  • Consolidate data from sources like ERP and customer behavior data from Microsoft Dynamics, VOIP data from Mitel, customer surveys from PowerReviews and Survey Gizmo, website traffic and stats from Google Analytics and ecommerce data from MySQL to help develop reports to measure performance using tools like SSIS, stored procedures and Toad.
  • Must have have some experience with ETL processes (extract, transform, load).
  • Plan for workflows in MS Dynamics for order processing to better manage backlog and logistics.
  • Maintain a central repository of customer behavior data with information that would be the backbone for various marketing campaigns like direct mail, promotional email campaigns and social media marketing.
  • Assist in developing marketing forecast models for subscription and non-subscription based customers and help determine their life time value.
  • Assist in performing matchback analysis to measure performance of various sales campaigns.
  • Support in defining trends, proving and disproving hypotheses, and finding areas for efficiency and improvement.
  • Manage and implement various marketing related projects as defined by the leadership team using the appropriate tools.
  • Collect survey responses to improve products and operations to drive customer satisfaction.
  • May perform other duties as assigned.


  • Minimum of 5 years work experience in SQL, SSRS, Tableau and MS Excel.
  • Must have a bachelor's degree in IT or another related discipline. A Master's Degree in a related discipline is preferred.
  • Proficient with Microsoft Office (Excel, Word, Outlook, etc.)
  • Analytical and problem solving skills.
  • Strong ability to analyze information.
  • Strong written and verbal communication skills.

We Offer


We Offer:  Competitive compensation package 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.

Nearest Major Market: Austin

Job Segment: Database, Telecom, Telecommunications, Information Systems, Marketing, Technology