Sr. Database Test Engineer - Automation
Come make the world and accelerate your success.
It takes great people to achieve greatness. People with a sense of purpose and integrity. People with a relentless pursuit of excellence. People who care about making things better For Those Who Make The World. Sound like you? Join our top-notch team of approximately 48,000 diverse and high-performing professionals globally who are making their mark on some of the world's most beloved brands, including DEWALT®, BLACK+DECKER®, CRAFTSMAN®, STANLEY®, CUB CADET®, and HUSTLER®.
The Job:
As a Sr. Database Test Engineer - Automation, you'll play a critical role in ensuring the quality, reliability, and performance of our database systems and applications. As a remote employee and a key member of our Construction Technology team, you will:
Design, develop, and execute test cases for database objects including stored procedures, functions, triggers, and views
Validate business logic and complex calculations implemented in stored procedures
Perform ETL pipeline testing to ensure accurate data extraction, transformation, and loading
Validate data across source, staging, and target systems for completeness, accuracy, and consistency
Conduct data reconciliation using row counts, aggregates, and field-level comparisons
Identify, analyze, and report data discrepancies and defects with clear root cause analysis
Develop and maintain SQL queries and scripts for automated data validation
Validate handling of edge cases, null values, and exception scenarios
Support UAT and production data validation activities
Collaborate with data engineers, backend developers, and business stakeholders to clarify requirements and resolve issues
Document test cases, test results, and data validation reports
The Person:
You love to learn and grow and be acknowledged for your valuable contributions. You're not intimidated by innovation. Wouldn't it be great if you could do your job and do a world of good? In fact, you embrace it. You also have:
Strong proficiency in SQL, including complex joins, subqueries, CTEs, and aggregations
Experience in implementing strategies to reduce contention and deadlocks in multi-user environments.
Demonstrated experience in assessing and benchmarking database performance, including identifying bottlenecks and optimizing query execution.
Hands-on experience testing stored procedures, functions, triggers, and views
Experience in ETL testing and data validation across multiple systems
Solid understanding of data warehousing concepts (fact/dimension tables, Slowly Changing Dimension (SCDs), star/snowflake schemas).
Experience with relational databases such as Maria DB or MySQL
Strong understanding of data quality, data reconciliation, and validation techniques
Positive attitude with passion for customer value
Excellent communication and teamwork skills
Experience in construction and pre-fabrication a Bonus
The Details:
You'll receive a competitive salary and a great benefits plan, including:
Medical, dental, life, vision, disability, 401(k), Employee Stock Purchase Plan, paid time off, and tuition reimbursement in addition to programs & benefits in support of your well-being.
Discounts on Stanley Black & Decker tools and other partner programs.
And More:
We want our company to be a place you'll want to be - and stay. Being part of our team means you'll get to:
Grow: Be part of our global company with 20+ brands to grow and develop your skills along multiple career paths.
Learn: Have access to a wealth of learning resources, including our digital learning portal.
Belong: Experience an awesome place to work, where we have mutual respect and a great appreciation for a wide range of perspectives and experiences.
Give Back: Help us continue to make positive changes locally and globally through volunteerism, giving back, and sustainable business practices.
What's more, you'll get that pride that comes from empowering makers, doers, protectors, and everyday heroes all over the world. We're more than the #1 tools company. More than a driving force in outdoor power equipment. More than a global leader in industrial. We're visionaries and innovators. As successful as we've been in the past, we have so much further to go. That's where you come in. Join us!
LI-NM1
LI-Remote
The base pay range for this position in Colorado is $90,000- $162,000 per year. Pay is based on market location and may vary depending on job-related knowledge, skills, and experience. A sign-on payment may be provided as part of the compensation package, in addition to a full range of medical, financial, and/or other benefits, dependent on the position offered. Applicants should apply via Stanley Black and Decker's internal or external careers site.
We Don't Just Build The World, We Build Innovative Technology Too.
Joining the Stanley Black & Decker team means working in an innovative, tech-driven and highly collaborative team environment supported by over 58,000 professionals in 60 countries across the globe. Here, you'll get the unique chance to impact some of the world's most iconic brands including STANLEY TOOLS, DEWALT, CRAFTSMAN, MAC TOOLS and Black + Decker. Your ideas and solutions have the potential to reach millions of customers as we work together to write the next chapter in our history. Come build with us and take your career to new heights.
Who We Are
We're the World's largest tool company. We're industry visionaries. We're solving problems and advancing the manufacturing trade through innovative technology and our Industry 4.0 Initiative. We are committed to ensuring our state-of-the-art "smart factory" products and services provide greater quality to our customers & greater environmental and social value to our planet. We are unique in that we have a rich and storied history dating back to 1843, but that hasn't stopped us from evolving into a vibrant, diverse, global growth company.
Benefits & Perks
You'll get a competitive salary and a comprehensive benefits plan that includes medical, dental, life, vision, wellness program, disability, retirement benefits, Employee Stock Purchase Plan, Paid Time Off, including paid vacation, holidays & personal days, and tuition reimbursement. And, of course, discounts on Stanley Black & Decker tools and products and well as discount programs for many other vendors and partners.
What You'll Also Get
Career Opportunity: Career paths aren't linear here. Being part of our global company with 60+ brands gives you the chance to grow and develop your skills along multiple career paths.
Learning & Development:
Our lifelong learning philosophy means you'll have access to a wealth of state-of-the-art learning resources, including our Lean Academy and online university (where you can get certificates and specializations from renowned colleges and universities).
Diverse & Inclusive Culture:
We pride ourselves on being an awesome place to work. We respect and embrace differences because that's how the best work gets done. You'll find we like to have fun here, too.
Purpose-Driven Company:
You'll help us continue to make positive changes in the local communities where we work and live as well as in the broader world through volunteerism, giving back and sustainable business practices.
EEO Statement:
All qualified applicants to Stanley Black & Decker are considered for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran's status or any other protected characteristic.
If you require reasonable accommodation to complete an application or access our website, please contact us at (860) 827-3923 or at accommodations@sbdinc.com . Due to volume, we cannot respond to unrelated inquiries about the status of a completed application or resetting an account password.
Know Your Rights: Workplace discrimination is illegal (eeoc.gov) (http://www.eeoc.gov/sites/default/files/2023-06/22-088\EEOC\KnowYourRights6.12ScreenRdr.pdf)
