Manager, Marketing Technology
The Sherwin-Williams Company, Cleveland, OH, United States
Overview
The Manager, Marketing Technology is pivotal to the Data-Driven eXperience (DDX) team, responsible for overseeing marketing technology/database operations and new development as well as coordinating a matrixed team in executing all DDX deliverables across marketing automation, customer insights + visualization, and marketing measurement.
The Manager, Marketing Technology will define and oversee processes for intake and workflow, quality control, governance, and documentation across the full DDX team. These efforts will support Sherwin-Williams in driving greater insights, personalization, engagement, and improved lead nurturing for all business-to-business market segments (Residential Repaint, New Residential, Commercial, Multi-Family, Healthcare and Hospitality), as well as the direct-to-consumer market segment (Do It Yourself).
This role is not hybrid or remote and will report to our Cleveland, OH Headquarters location.
Core Responsibilities
Marketing Database/MarTech Development and Operations. Lead a team of four internal resources and/or oversee an external agency partner(s) in:
Customer data strategy/architecture/infrastructure/integration design and development, such as …
Provide insight & technology recommendations that result in solutions to critical business problems
Design, implement and document multi-platform architectures with a focus on performance, flexibility, reliability, scalability, and identity resolution
Identify architectural risks and create plans to mitigate risks
Program scoping, development and implementation related to data integration, aggregation, availability, and processing to drive and enable actionable insights from complex data sets by working with appropriate team members and stakeholders
Oversee the development of the database mapping and migration process of legacy data to new systems
Identify and resolve production and application issues by determining and pursuing best courses of action
Provide support to team members by responding to user questions, resolving issues, and troubleshooting
Monitor system performance by performing root cause analysis and integrating new features
MarTech application strategy/architecture/infrastructure/integration design and development, such as having an overall understanding of how data flows throughout the MarTech stack and why each element of a system is chosen
Safely set up, integrate and administer tools, ensuring the marketing team understands why the setup was done and how this setup matches and can improve/automate marketing processes beyond top-of-funnel activities
Plan how the next version of the stack will manifest to accomplish business goals
Assess tools/vendors that could solve a problem and work cross-functionally to ensure the right marketing problems are defined and considered during the assessment phase
Establish vendor relationships based on business needs and the MarTech landscape
Project management through intake, prioritization, enablement and management. Train teams to meet MarTech needs and grow effectively. Build and maintain a team that develops diverse competencies to avoid reliance on one platform or method.
Day-to-day monitoring and operations of the Marketing Database and associated software and infrastructure, including daily delivery and ingestion of all assigned relevant files/data integrations, monitoring for issues and optimization opportunities
Coordinate with internal IT resources and external agencies in troubleshooting data delivery issues
Ensure and approve access to the marketing database and tools for appropriate internal resources
Actively manage data queries in ongoing UAT processes and other testing
Facilitate collaboration across the DDX team, external marketing database provider, and Sherwin-Williams IT teams to troubleshoot data discrepancies and ensure clear data understanding
Recommend additional controls by identifying issues and writing improved procedures
Improve systems by understanding current practices and proposing optimizations/modifications as needed
Provide updates to users on database issues, updates, and key projects and tasks
Facilitate collaboration with other PSG departments and teams to ensure all business objectives and requirements are documented and translated for all parties to understand
Build relationships with key business and technology stakeholders across the organization
Gather requirements, test files and assist in the delivery of additional database development phases, specifically integration of new digital data sources and adaptation of existing infrastructure to accommodate new data
Documentation; cross-functional alignment throughout the process
Stakeholder support, including answering questions and providing summaries to queries and data access as appropriate
Provide DDX "consultation" for marketing technologies/processes not directly under DDX's purview
Ensure alignment on data business rules and key aggregates
Ensure compliance with privacy and other internal policies as appropriate, including regional, national, and international legislation
Own and prepare technical/data summary reports from start to finish; build the query, collect and analyze the data, and summarize the information and trends for the final audience
DDX Marketing Operations & Executional Excellence
Providing leadership across the full, matrixed DDX team and external agency partner(s) in scheduling, process and validation of DDX deliverables across marketing automation, customer insights + visualization and marketing measurement.
Develops, implements and oversees adherence to executional processes, such as access and governance, documentation requirements and processes for managing, storing documentation (GitHub, etc.), peer review and other processes for QC and validation; establishing and enforcing stage gates for release of deliverables
Standardization of business rules, and technical requirements across deliverables (for example CAC inclusions/exclusions by deliverable type, standardization of flags, standardization of account counting logic)
Education
Required: Bachelor’s Degree
Preferred: Bachelor’s Degree in Computer Science, Information Technology, Math, Software Engineering or related field
Knowledge & Experience
Required: Core understanding of relational database design concepts (ex: table design, table relationships; 1:1; 1-many), primary & foreign key designations, etc.
Core understanding of omni-channel platforms, data flows, and MarTech capabilities
Competency in writing, interpreting, trouble shooting and summarizing basic to intermediate SQL queries
5+ years working with and writing detailed requirement specifications for data warehouses/infrastructure/processes and/or database delivery
5+ years working with IT methodologies (ex: Systems Development Life Cycle, Agile and/or Waterfall), test planning and use cases
Excellent communication (verbal and written) skills
Demonstrated ability to influence without authority
Can translate technical ideas into non-technical terms without sacrificing the quality of information given
Effective problem-solver, able to think through and propose alternative options
Preferred: Experience with B2B and B2C customer data
Experience administering business intelligence or data visualization platforms
Experienced user in Tableau or similar
Experience in Digital Analytics platforms and integration
8+ years working with and writing detailed requirement specifications for data warehouses/infrastructure/processes and/or database delivery
8+ years working with IT methodologies (ex: Systems Development Life Cycle, Agile and/or Waterfall), test planning and use cases
Technical/Skill Requirements
Required: Experience in SQL programming, SQL server data types and functions
Knowledge of relational database structures, documentation and processes
Experienced user in Tableau or similar
Preferred: Familiar with developing SSIS packages to perform ETL functions in a data warehouse environment
Experience administering business intelligence or data visualization platforms
#J-18808-Ljbffr
The Manager, Marketing Technology is pivotal to the Data-Driven eXperience (DDX) team, responsible for overseeing marketing technology/database operations and new development as well as coordinating a matrixed team in executing all DDX deliverables across marketing automation, customer insights + visualization, and marketing measurement.
The Manager, Marketing Technology will define and oversee processes for intake and workflow, quality control, governance, and documentation across the full DDX team. These efforts will support Sherwin-Williams in driving greater insights, personalization, engagement, and improved lead nurturing for all business-to-business market segments (Residential Repaint, New Residential, Commercial, Multi-Family, Healthcare and Hospitality), as well as the direct-to-consumer market segment (Do It Yourself).
This role is not hybrid or remote and will report to our Cleveland, OH Headquarters location.
Core Responsibilities
Marketing Database/MarTech Development and Operations. Lead a team of four internal resources and/or oversee an external agency partner(s) in:
Customer data strategy/architecture/infrastructure/integration design and development, such as …
Provide insight & technology recommendations that result in solutions to critical business problems
Design, implement and document multi-platform architectures with a focus on performance, flexibility, reliability, scalability, and identity resolution
Identify architectural risks and create plans to mitigate risks
Program scoping, development and implementation related to data integration, aggregation, availability, and processing to drive and enable actionable insights from complex data sets by working with appropriate team members and stakeholders
Oversee the development of the database mapping and migration process of legacy data to new systems
Identify and resolve production and application issues by determining and pursuing best courses of action
Provide support to team members by responding to user questions, resolving issues, and troubleshooting
Monitor system performance by performing root cause analysis and integrating new features
MarTech application strategy/architecture/infrastructure/integration design and development, such as having an overall understanding of how data flows throughout the MarTech stack and why each element of a system is chosen
Safely set up, integrate and administer tools, ensuring the marketing team understands why the setup was done and how this setup matches and can improve/automate marketing processes beyond top-of-funnel activities
Plan how the next version of the stack will manifest to accomplish business goals
Assess tools/vendors that could solve a problem and work cross-functionally to ensure the right marketing problems are defined and considered during the assessment phase
Establish vendor relationships based on business needs and the MarTech landscape
Project management through intake, prioritization, enablement and management. Train teams to meet MarTech needs and grow effectively. Build and maintain a team that develops diverse competencies to avoid reliance on one platform or method.
Day-to-day monitoring and operations of the Marketing Database and associated software and infrastructure, including daily delivery and ingestion of all assigned relevant files/data integrations, monitoring for issues and optimization opportunities
Coordinate with internal IT resources and external agencies in troubleshooting data delivery issues
Ensure and approve access to the marketing database and tools for appropriate internal resources
Actively manage data queries in ongoing UAT processes and other testing
Facilitate collaboration across the DDX team, external marketing database provider, and Sherwin-Williams IT teams to troubleshoot data discrepancies and ensure clear data understanding
Recommend additional controls by identifying issues and writing improved procedures
Improve systems by understanding current practices and proposing optimizations/modifications as needed
Provide updates to users on database issues, updates, and key projects and tasks
Facilitate collaboration with other PSG departments and teams to ensure all business objectives and requirements are documented and translated for all parties to understand
Build relationships with key business and technology stakeholders across the organization
Gather requirements, test files and assist in the delivery of additional database development phases, specifically integration of new digital data sources and adaptation of existing infrastructure to accommodate new data
Documentation; cross-functional alignment throughout the process
Stakeholder support, including answering questions and providing summaries to queries and data access as appropriate
Provide DDX "consultation" for marketing technologies/processes not directly under DDX's purview
Ensure alignment on data business rules and key aggregates
Ensure compliance with privacy and other internal policies as appropriate, including regional, national, and international legislation
Own and prepare technical/data summary reports from start to finish; build the query, collect and analyze the data, and summarize the information and trends for the final audience
DDX Marketing Operations & Executional Excellence
Providing leadership across the full, matrixed DDX team and external agency partner(s) in scheduling, process and validation of DDX deliverables across marketing automation, customer insights + visualization and marketing measurement.
Develops, implements and oversees adherence to executional processes, such as access and governance, documentation requirements and processes for managing, storing documentation (GitHub, etc.), peer review and other processes for QC and validation; establishing and enforcing stage gates for release of deliverables
Standardization of business rules, and technical requirements across deliverables (for example CAC inclusions/exclusions by deliverable type, standardization of flags, standardization of account counting logic)
Education
Required: Bachelor’s Degree
Preferred: Bachelor’s Degree in Computer Science, Information Technology, Math, Software Engineering or related field
Knowledge & Experience
Required: Core understanding of relational database design concepts (ex: table design, table relationships; 1:1; 1-many), primary & foreign key designations, etc.
Core understanding of omni-channel platforms, data flows, and MarTech capabilities
Competency in writing, interpreting, trouble shooting and summarizing basic to intermediate SQL queries
5+ years working with and writing detailed requirement specifications for data warehouses/infrastructure/processes and/or database delivery
5+ years working with IT methodologies (ex: Systems Development Life Cycle, Agile and/or Waterfall), test planning and use cases
Excellent communication (verbal and written) skills
Demonstrated ability to influence without authority
Can translate technical ideas into non-technical terms without sacrificing the quality of information given
Effective problem-solver, able to think through and propose alternative options
Preferred: Experience with B2B and B2C customer data
Experience administering business intelligence or data visualization platforms
Experienced user in Tableau or similar
Experience in Digital Analytics platforms and integration
8+ years working with and writing detailed requirement specifications for data warehouses/infrastructure/processes and/or database delivery
8+ years working with IT methodologies (ex: Systems Development Life Cycle, Agile and/or Waterfall), test planning and use cases
Technical/Skill Requirements
Required: Experience in SQL programming, SQL server data types and functions
Knowledge of relational database structures, documentation and processes
Experienced user in Tableau or similar
Preferred: Familiar with developing SSIS packages to perform ETL functions in a data warehouse environment
Experience administering business intelligence or data visualization platforms
#J-18808-Ljbffr