Sr. Database Test Engineer - Automation-- Construction Technology

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