Compeer Financial is seeking collaborative, innovative and dynamic professionals to be a part of our Top Workplace culture!

Tell me more about this opportunity.

Position Overview:
This position evaluates and performs functional, integration and regression testing for various data-related engagements. Supports Business Data Analysts, ETL Developers and other stakeholders in analysis of business needs, process improvements and new technologies. Develops procedures to efficiently create and execute test plans, track defects and resolve identified issues. Develops automated test scripts and maintains an automation framework using QA software tools and processes. Provides subject matter expertise and mentorship across the organization. Proactively identify problems with acceptance criteria (lack of clarity, inconsistencies, technical limitations) and communicates these issues early.

Essential Functions:

• Collaborates with Business Systems Analysts, ETL Developers, and other stakeholders to review project requests, participate in design sessions and determine testing goals.
• Estimates, prioritizes, plans and coordinates testing activities.
• Utilizes various testing methods to ensure quality, including black box, white box, regression, and automated testing.
• Writes, executes and maintains both manual and automated test cases for functional, integration and regression testing which includes translating both simple and complex business rules to SQL queries and executing those queries to validate data quality and accuracy and ensure that it meets agreed-upon requirements and applicable QA standards.
• Provides testing status updates to the project team.
• Manages and reports test results which will require clear and concise documentation and an ability to conduct root cause analysis and communicate complex information to both technical and non-technical personnel.
• Tracks data issues and works with team leads from discovery to resolution.
• Collaborates with reporting and analytics teams to conduct data quality investigations.
• Maintains test environments to include managing test data, configuring systems for specific test needs, ensuring compliance with standards.
• Leads efforts to develop, implement and review quality processes and methodologies.
• Participates with cross-functional Data and Business Technology teams to formulate best practices.
• Researches new testing tools, technologies and strategies.
• Facilitates meetings with Data, Project Delivery and/or business unit team members.

Minimum Qualifications & Required Knowledge, Skills and Abilities:

• Bachelor's degree in math, computer science, management information systems, or related field or an equivalent combination of education and experience sufficient to perform the essential functions of the job.
• Minimum of 3 years of experience in a software or data development environment as an application/ETL tester, business analyst, technical writer or developer.
• Knowledge of software testing methodologies, tools and best practices.
• Knowledge of business applications, process improvement, project management systems, and agile methodology.
• Solid knowledge and experience in writing clear, concise and comprehensive test plans and test cases.
• Solid knowledge in writing complex SQL queries on large tables (millions of records) and ensure data integrity is maintained throughout the ETL lifecycle.
• Specialized experience with data warehouses, APIs, ETL testing and SQL scripting.
• Knowledge of queries, scripting and coding frequently used in QA Automation tools.
• Experience creating automated test scripts using QA software tools and processes.
• Knowledge of effective automation test design and development methods.
• Effective communication skills to clearly and concisely convey technical issues to customers and to share ideas, solutions and feedback with team.
• Effective interpersonal, analytical, organizational and planning skills.
• Ability to apply a methodical and logical approach to problem solving.
• Critical thinking skills with attention to detail and accuracy.
• Quick learner who thrives in a collaborative team environment.
• Ability to coordinate tasks to meet established deadlines.
• Ability to foster collaborative working relationships across the organization.
• Ability to train and mentor others.
• Demonstrates initiative to remain technically competent by keeping abreast of industry best practices.
• Ability to work independently and collaboratively with other teams to achieve goals and represent the business.

Who is Compeer Financial?
Compeer Financial exists to champion the hopes and dreams of rural America. By joining our team, you will help empower those in agriculture and rural communities to achieve their goals and expand their possibilities. We embrace business agility and innovative approaches to serving our clients and communities.

Why join our team?

• Amazing team members who are passionate about serving agriculture and rural America.
• Investment in our team members' education, growth and development.
• Engagement in our communities through giving back and volunteerism.
• Flexible, collaborative and dynamic work environment.
• Great benefits:
  • Medical, Dental, Vision insurance
  • 401K (3% Compeer contribution & up to an additional 6% match)
  • Paid time off (vacation, sick leave, holidays, volunteer time)

Find out why our team members choose Compeer Financial by watching this video.

How do I apply?
Qualified candidates, please apply online at www.compeer.com/careers.

Compeer Financial is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.