Company / Location Information

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.

Primary Function

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.

Responsibilities

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.

Qualifications

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

Education

Bachelor's Degree in Related Field

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.

ADA Statement & EEO Statement

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.

Qualifications

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
Bachelor's Degree in Related Field

Benefits

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

Responsibilities

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

✨ Job alerts

✨ Job alerts

Database Marketing Analyst/Engineer