Manager, Marketing Technology
Sherwin-Williams
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).
On an ongoing basis, the person in this role will lead the management of day-to-day DDX team operations – focused on integrations between our customer data platform, digital data source systems (ecommerce, proprietary customer applications, and custom solutions – such as our color chip ordering experience), our marketing data warehouse, and reporting environments. This role will facilitate extensions/integrations of additional digital data/data sources as appropriate, under the guidance of the Marketing Director, DDX. This role will also facilitate requirements gathering/scoping, implementation, and ongoing management of the technical components of related marketing initiatives, such as quality checks of data sets, consulting on business rules and logic for integrations, and/or coordination of ad-hoc data sizing requests. These efforts will support Sherwin-Williams in driving greater insights, 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).
At Sherwin-Williams, our purpose is to inspire and improve the world by coloring and protecting what matters. Our paints, coatings and innovative solutions make the places and spaces in our world brighter and stronger. Your skills, talent and passion make it possible to live this purpose, and for customers and our business to achieve great results. Sherwin-Williams is a place that takes its stability, growth and momentum and translates it to possibility for our people. Our people are behind the strength of our success, and we invest and support you in:
Life … with rewards, benefits and the flexibility to enhance your health and well-being
Career … with opportunities to learn, develop new skills and grow your contribution
Connection … with an inclusive team and commitment to our own and broader communities
It's all here for you... let's Create Your Possible
At Sherwin-Williams, part of our mission is to help our employees and their families live healthier, save smarter and feel better. This starts with a wide range of world-class benefits designed for you. From retirement to health care, from total well-being to your daily commute—it matters to us. A general description of benefits offered can be found at http://www.myswbenefits.com/. Click on “Candidates” to view benefit offerings that you may be eligible for if you are hired as a Sherwin-Williams employee.
Compensation decisions are dependent on the facts and circumstances of each case and will impact where actual compensation may fall within the stated wage range. The wage range listed for this role takes into account the wide range of factors considered in making compensation decisions including skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. The wage range, other compensation, and benefits information listed is accurate as of the date of this posting. The Company reserves the right to modify this information at any time, with or without notice, subject to applicable law.
Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable federal, state, and local laws including with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act where applicable.
Sherwin-Williams is proud to be an Equal Employment Opportunity employer. All qualified candidates will receive consideration for employment and will not be discriminated against based on race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, pregnancy, genetic information, creed, marital status or any other consideration prohibited by law or by contract.
As a VEVRAA Federal Contractor, Sherwin-Williams requests state and local employment services delivery systems to provide priority referral of Protected Veterans.
Please be aware, Sherwin-Williams recruiting team members will never request a candidate to provide a payment, ask for financial information, or sensitive personal information like national identification numbers, date of birth, or bank account numbers during the application process.
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
Core Responsibilities
Marketing Database/MarTech Development and Operations. Leading a team of four internal resources and/or overseeing 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 necessary action
Provide support to team members by responding to user questions, resolving issues, and troubleshooting
Monitor the 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 administers tools, ensuring the marketing team understands why the setup was done in such a way 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
Ability to assess tools/vendor’s value. Consider tools/vendors that could solve a problem and work closely cross-functionally and lead efforts 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. Ability to train teams hire and train teams to meet MarTech needs and grow effectively. You must build and maintain a team that develops diverse competencies, avoiding reliance on one platform or method. The goal is to align marketing processes with technology to enhance both and achieve overall business objectives.
Day-to-day monitoring and operations of the Marketing Database and associated software and infrastructure, including:
Ensuring daily delivery and ingestion of all assigned relevant files/data integrations (primary digital sources), monitoring for issues and optimization opportunities
Coordinating with internal IT resources and external agencies in troubleshooting data delivery issues
Ensuring and approving access to the marketing database and tools for appropriate internal resources
Actively managing data queries in ongoing UAT processes and other testing
Facilitating across DDX team resources, external marketing database provider, and Sherwin-Williams IT teams to troubleshoot data discrepancies and ensure clear data understanding
Recommending additional controls for implementation by identifying issues, and writing improved procedures
Improving systems by understanding current practices, proposing and optimizations and modifications as needed
Providing updates to users on database issues, updates, and key projects and tasks
Facilitating collaboration other PSG departments and teams, to ensure all business objectives and requirements are documented and translated for all parties to understand, including:
Build relationships with key business and technology stakeholders across the organization
Gathering requirements, test files and assisting 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
Providing 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; from building the query, collecting and analyzing the data, and summarizing 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 (ex: CAC inclusions/exclusions by deliverable type, standardization of flags, standardization of account counting logic)