Note: The job is a remote job and is open to candidates in USA. Sherwin-Williams is a leading company in the paint and coatings industry, seeking a Manager of Marketing Technology to join their Data-Driven eXperience team. This role is responsible for overseeing marketing technology operations, leading a team, and ensuring effective execution of marketing automation and customer insights initiatives.
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)
Skills
- Bachelor's Degree
- 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
- Experience in SQL programming, SQL server data types and functions
- Knowledge of relational database structures, documentation and processes
- Experienced user in Tableau or similar
- Bachelor's Degree in Computer Science, Information Technology, Math, Software Engineering or related field
- 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
- Familiar with developing SSIS packages to perform ETL functions in a data warehouse environment
Benefits
- This role is hybrid/remote eligible and will report to our Cleveland, OH Headquarters location.
Company Overview
Company H1B Sponsorship