Commercial Market Intelligence Analyst

Stanley Black & Decker, Inc.

Commercial Market Intelligence Analyst managing the ETL process for key data used in business analytics. Collaborating with cross-functional teams to ensure data quality and accuracy across reporting systems.

Posted 6/2/2026full-timeRemote • 🇨🇴 ColombiaJuniorMid-LevelWebsite

Tech Stack

Tools & technologies

ETLSQL

About the role

Key responsibilities & impact

Manage end-to-end external data process (ETL) for assigned accounts as follows: Data acquisition: Collaborate with customer accounts to obtain periodic data on agreed schedule, and verify data is in loadable/usable format
Data Staging: Ensure data is properly staged, resolving load errors and verifying completeness; Work with internal partners to maintain accurate data cleansing (material and account cross referencing)
Data Loading: Confirm data is loaded into all analytics and reporting systems
Issue Resolution: Work with internal partners and customers directly to resolve data issues
Process Improvement: Collaborate with internal partners and customers to identify and execute improvement initiatives and projects. Examples include (but are not limited to) optimization of load timing, improved data cleansing, and process documentation.
Complete regular mass validations during critical period ends to ensure data accuracy / consistency
Integrate new accounts as assigned
Act as subject matter expert for external data, interfacing with Analytics, Finance, Operations and Sales teams as needed
Work through conflicting issues, roadblocks and dependencies; proactively manage risks, changes, and communication with project stakeholders.
Flex to big picture strategic view as required.

Requirements

What you’ll need

Bachelor’s degree in business or a related field
Minimum of 2 years of data management experience, preferable experience with consumer products company
Systems knowledge or ability to learn quickly: SAP
Systems knowledge or ability to learn quickly: Business WHSE / SAP HANA
Systems knowledge or ability to learn quickly: Snowflake
Proficient in all Microsoft Suite Software, especially MS Excel
Demonstrated detail-oriented, self-reliant, problem-solving skills
Demonstrated effective time management skills through managing multiple tasks simultaneously
Professional verbal and written communication skills with comfort in presenting to all levels of the organization
Basic – Intermediate understanding of SQL (Structure Query Language)
Basic – Intermediate understanding of Power BI

Benefits

Comp & perks

Competitive salary plus receive entitlements and benefits unique to your country of hire
Career Opportunity
Learning & Development
Diverse & Inclusive Culture
Purpose-Driven Company

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETLdata managementdata cleansingSQLPower BIdata validationdata stagingdata loadingissue resolutionprocess improvement

Soft Skills

problem-solvingtime managementcommunicationcollaborationdetail-orientedself-reliantflexibilitystrategic thinkinginterpersonal skillspresentation skills