Sr. Database Test Engineer - Automation-- Construction Technology

Stanley Black & Decker, Inc.•Denver, CO

1d•$90,000 - $162,000•Remote

About The Position

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:

Requirements

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

Nice To Haves

Experience in construction and pre-fabrication a Bonus

Responsibilities

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

Benefits

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.
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.
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.
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.