Database Market Engineer

A.O. Smith is a global leader applying innovative technologies and energy-efficient solutions to products manufactured and marketed worldwide. The company is one of the world's leading manufacturers of residential and commercial water heating equipment and boilers, as well as a manufacturer of water treatment products for residential and light commercial applications. A. O. Smith is headquartered in Milwaukee, Wisconsin, with approximately 12,000 employees at operations in the United States, Canada, China, India, Mexico, the Netherlands, and the United Kingdom.

Responsible for the development and maintenance of our current organizational data warehouse and reporting platform which includes SQL Server, Snowflake, AWS, API end points, and Tableau Server Environment. Data Integration via ETL/ELT processes to move, transform, and stitch data between systems to create datasets that produce actionable information for our Business Stakeholders. Managing and organizing raw data for accessibility and usability, while also ensuring data quality, integrity, and security across platforms. Collaborate with Stakeholders to translate business requirements into technical specifications and deliver solutions to our Stakeholders. Build Actionable Tableau Dashboards from our organizational data. Understand the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations.

• Interview and Communicate with Business Stakeholders to gather requirements and collaborate through all phases of development.
• Data Integration from disparate data sources such as SAP, Five9, Salesforce, Postal Data, Product Surveys, S3, SFTP, and various sources to create a data warehouse for our Organizational Data.
• Building and maintain data pipelines from SQL Server, APIs, Glue, Snowflake, and other data platforms to enhance our Organizational Data, and support our organization's data-driven initiatives.
• Responsible for analyzing complex logical database designs, logical data models, and optimize database performance to ensure scalability for growing data volumes and processing demands.
• Maintain Organizational KPI's that provide visibility into the business and marketing activities; work with business stakeholders to align the reports using tools like Microsoft Excel, Tableau, SSRS and SQL Server.
• Develop and Maintain complex Executive, Operations, Sales, Logistics, and Marketing Tableau Dashboards.
• 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 match back 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.
• Perform other duties as assigned.

• Bachelor's Degree in a related field.
• 3+ year of related data experience or related University Projects which required ETL/ELT processes.
• Proficient in Visualization tools such as Tableau, Python, SQL, API Framework, PowerShell, Scripting
• Understanding of Cloud Eco-System and Snowflake.
• Understanding of Source Control such as GitHub
• Results-oriented project management skills
• Analytical and problem-solving skills
• Strong ability to analyze information
• Strong written and verbal communication skills
• Knowledge and experience with Data Analysis
• Data migration / Integration tools
• Data modeling

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.

#LI-AO

#LI-Hybrid

In developing this job description care was taken to include all competencies needed to successfully perform in this position. However, for Americans with Disabilities Act (ADA) purposes, the essential functions of the job mayor may not have been described for purposes of ADA reasonable accommodation. All reasonable accommodation requests will be reviewed and evaluated on a case-by-case basis.

We consider all applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, gender identity and expression, marital or military status. We also provide reasonable accommodations to qualified individuals with disabilities in accordance with the Americans with Disabilities Act and applicable state and local law.