Sherwin-Williams
Business Systems Analyst
Sherwin-Williams, Cleveland, Ohio, us, 44101
Job Description
Job duties include contact with other employees and access confidential and proprietary information and/or other items of value, and such access may be supervised or unsupervised. The Company therefore has determined that a review of criminal history is necessary to protect the business and its operations and reputation and is necessary to protect the safety of the Company's staff, employees, and business relationships.
Responsibilities
CORE RESPONSIBILITIES AND TASKS
The
Business Systems Analyst
will play a key role on the Data-Driven eXperience (DDX) team, serving as a key liaison between the external marketing database provider, other DDX team members (in campaign management, reporting, and data science roles) and internal Sherwin-Williams technology teams to ensure data integrations and data understanding that meet and exceed the needs of our customers, field sales team, and internal marketing stakeholders (focused on eBiz).
On an ongoing basis, the person in this role will aid in the management of day-to-day database operations - focused on integrations between 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. The DDX Digital BSA will facilitate extensions/integrations of additional digital data/data sources as appropriate, under the guidance of the Marketing Manager, Customer Data. 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).
Core Responsibilities:
Support 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 Act as key bridge/conduit between non-technical departments (ex: eBiz/ecommerce Marketing teams) and IT on DDX integrations, to ensure all business objectives and requirements are documented and translated for all parties to understand, including:
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 Determine operational objectives by studying business functions, gathering information, evaluating output requirements and formats Providing support to internal eBiz (ecommerce/digital team) stakeholders, including answering questions and providing summaries to queries and data access as appropriate Serve as the DDX "consultant" for marketing technologies/processes not directly under DDX's purview Serve as a key point of contact across other internal teams to ensure alignment on data business rules and key aggregates Support DDX lead in ensuring 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
Qualifications
POSITION REQUIREMENTS
FORMAL EDUCATION:
Required:
Bachelor's Degree (alternatively, 5 years of direct industry experience in lieu of a 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.). 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 TECHNICAL/SKILL REQUIREMENTS:
Required:
Intermediate-to-Advanced SQL Querying and Aggregation skill Data Research, Analysis, and Validation Proficiency in Microsoft Office Applications Preferred:
Experience with Snowflake Database Technology Exposure to Oracle, MariaDB, and SQL Server Database Technologies a plus TRAVEL REQUIREMENTS:
10%
About Us
Here, we believe there's not one path to success, we believe in careers that grow with you. Whoever you are or wherever you come from in the world, there's a place for you at Sherwin-Williams. We provide you with the opportunity to explore your curiosity and drive us forward. Sherwin-Williams values the unique talents and abilities from all backgrounds and characteristics. All qualified individuals are encouraged to apply, including individuals with disabilities and Protected Veterans. We'll give you the space to share your strengths and we want you show us what you can do. You can innovate, grow and discover in a place where you can thrive and Let Your Colors Show!
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/Affirmative Action employer committed to an inclusive and diverse workplace. 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.
Job duties include contact with other employees and access confidential and proprietary information and/or other items of value, and such access may be supervised or unsupervised. The Company therefore has determined that a review of criminal history is necessary to protect the business and its operations and reputation and is necessary to protect the safety of the Company's staff, employees, and business relationships.
Responsibilities
CORE RESPONSIBILITIES AND TASKS
The
Business Systems Analyst
will play a key role on the Data-Driven eXperience (DDX) team, serving as a key liaison between the external marketing database provider, other DDX team members (in campaign management, reporting, and data science roles) and internal Sherwin-Williams technology teams to ensure data integrations and data understanding that meet and exceed the needs of our customers, field sales team, and internal marketing stakeholders (focused on eBiz).
On an ongoing basis, the person in this role will aid in the management of day-to-day database operations - focused on integrations between 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. The DDX Digital BSA will facilitate extensions/integrations of additional digital data/data sources as appropriate, under the guidance of the Marketing Manager, Customer Data. 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).
Core Responsibilities:
Support 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 Act as key bridge/conduit between non-technical departments (ex: eBiz/ecommerce Marketing teams) and IT on DDX integrations, to ensure all business objectives and requirements are documented and translated for all parties to understand, including:
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 Determine operational objectives by studying business functions, gathering information, evaluating output requirements and formats Providing support to internal eBiz (ecommerce/digital team) stakeholders, including answering questions and providing summaries to queries and data access as appropriate Serve as the DDX "consultant" for marketing technologies/processes not directly under DDX's purview Serve as a key point of contact across other internal teams to ensure alignment on data business rules and key aggregates Support DDX lead in ensuring 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
Qualifications
POSITION REQUIREMENTS
FORMAL EDUCATION:
Required:
Bachelor's Degree (alternatively, 5 years of direct industry experience in lieu of a 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.). 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 TECHNICAL/SKILL REQUIREMENTS:
Required:
Intermediate-to-Advanced SQL Querying and Aggregation skill Data Research, Analysis, and Validation Proficiency in Microsoft Office Applications Preferred:
Experience with Snowflake Database Technology Exposure to Oracle, MariaDB, and SQL Server Database Technologies a plus TRAVEL REQUIREMENTS:
10%
About Us
Here, we believe there's not one path to success, we believe in careers that grow with you. Whoever you are or wherever you come from in the world, there's a place for you at Sherwin-Williams. We provide you with the opportunity to explore your curiosity and drive us forward. Sherwin-Williams values the unique talents and abilities from all backgrounds and characteristics. All qualified individuals are encouraged to apply, including individuals with disabilities and Protected Veterans. We'll give you the space to share your strengths and we want you show us what you can do. You can innovate, grow and discover in a place where you can thrive and Let Your Colors Show!
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/Affirmative Action employer committed to an inclusive and diverse workplace. 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.