At PEMCO it's all about people, starting with our customers. We're a mutual insurance company owned by our Northwest policyholders since 1949. We believe in listening to our customers and showing that we understand them in ways that others don't. At PEMCO, you will enjoy the benefits of working for a thriving and growing company, sharing ideas, learning and seeing the impact of your work, while also enjoying positive energy and work-life balance. We're a company of 500+ relationship-focused, community-minded people, serving our policyholders from our modern office in the South Lake Union neighborhood of Seattle.
Why We Need You
PEMCO is seeking a Senior Database QA Engineer with the Information Management (IM) team to help deliver solutions that give PEMCO competitive advantages in the highly data-centric insurance market. You will work closely with data engineers and data analysts to plan, create, execute, and maintain test cases for a variety of data warehousing, data integration, reporting and analytical solutions. You will help design and develop test automation that enables the IM team to deliver faster while ensuring that our solutions provide accurate, timely, and relevant information.
What You'll Be Doing
* Plan, develop, and execute test strategies. * Develop, maintain, and enhance test suites to verify the validity and accuracy of ETL processes. * Troubleshoot, log, and regress bugs associated with new functionality and sustainment updates. * Collaborate with data engineers and analysts on troubleshooting and resolving issues * Coordinate with other testers, developers, project managers, and business subject matter experts, through the test execution. * Design and develop test automation solutions to increase team velocity. * Prepare builds and deployment instructions and work with DBAs on production releases. * Work closely with data engineers and analysts to inform solution designs in terms of testability. * Help define and implement team development best practices that ensure the quality of our solutions.
What You'll Bring
* Minimum 6 years database testing experience involving ETL, SSIS, Stored Procedures, and schema design using MS SQL Server 2012 or later. * Expert data analysis skills using SQL. * Ability to effectively apply various test methodologies based on objectives and requirements. * Ability to refine high-level design ideas and requirements into concrete and measurable test criteria. * Proactive and passionate about database testing, and data analysis. * Demonstrated strengths in development of test plans, test cases, test strategy, and test automation. * Strong data analysis skills including the ability to interpret the meaning of the data and the intent of the data processing design. * Able to interpret and communicate test findings in terms of priority and severity and participate in the effective triaging of bugs. * Ability to manage multiple projects & deadlines effectively. * Ability to manage change in a fast paced environment. * Excellent communication skills * Visual Studio Team Services * Experience with Agile development methodologies
* Experience with Tableau or other business intelligence / reporting tools * Experience with BIML * Insurance Industry experience
We've Got You Covered
* Competitive salary * 200% match on your 401(k) up to 6% of your pay * Generous medical, dental, disability and life insurance plans * A friendly, professional work environment * The opportunity to work at a place of integrity, where customer service is emphasized
Equal Opportunity Employer
At PEMCO, we celebrate and support our differences. We know employing a team rich in diverse thoughts, experiences, and opinions allows our employees, our products and our community to flourish. PEMCO is honored to be an equal opportunity workplace. We are dedicated to equal employment opportunities regardless of race, color, ancestry, religion, sex, national orientation, age, citizenship, marital status, disability, gender identity, sexual orientation or Veteran status.
Let your dream job find you.
Sign up to start matching with top companies. It’s fast and free.