Data QA Automation Engineer
Omaha, NE, US, 68137-2210
AgCountry Farm Credit Services (AgCountry), Farm Credit Services of America (FCSAmerica) and Frontier Farm Credit are financial cooperatives that operate under shared management across eight states. While each association is owned by its local farmers and ranchers, they collaborate by pooling resources, expertise, and talent to provide affordable credit, crop insurance, and financial services.
Our associations are united by a common mission and commitment to serving rural America and supporting each other, which drives the success of the farmers, ranchers, and agribusiness we serve. We take pride in being a great place to work, and this enthusiasm is reflected in the relationships our team members foster with one another and with our customers.
Job Summary
We are seeking a Data QA Automation Engineer who will work within an agile business intelligence development environment, develop quality assurance and testing strategies, create, and maintain test cases using automated testing tools, and build automated regression test suites. You will be asked to verify test results utilizing testing tools and utilities and provide timely test result feedback to a project team. Providing first level support and configuration of the testing tools and testing environment while collaborating with project team members to improve overall product quality.
Essential Duties & Responsibilities
Customer Service:
- Take the necessary steps to ensure our customers’ needs are met to the maximum extent possible in an accurate and timely manner.
- Communicate with technical and non-technical team members, leaders, and customers.
- Maintain a close and strong working relationship with project team members and leadership.
- Provide on-going support and maintenance of test automation tools, including the development of technical documentation.
Quality Assurance:
- Collaborate with project teams to develop and promote quality assurance practices to improve overall data quality.
- Champion new processes, software and/or systems to improve organization’s data integrity and data governance effectiveness.
- Identify and communicate when QA processes are not being adhered to or when insufficient quality conditions exist in a project or process.
- Thoroughly test all business intelligence and data warehouse changes to ensure that the business requirements have been satisfied before approving the promotion of the changes to the production environment.
Data Integrity Testing:
- Display a ‘test to break’ attitude, and a drive toward 100% test coverage.
- Demonstrate ability to take the point of view of the customer.
- Possess a strong desire for quality and attention to detail.
- Create test scripts and test plans to enable streamlined application testing practices.
- Mentor project team members on writing test scenarios and proper testing procedures.
- Prioritize testing based on relative risk to system. Analyze, recommend, implement, configure and administer automated testing tools targeted to enhance data integrity and quality assurance practices.
- Create testing strategies for manual and automated testing to meet specific project needs.
- Provide training and support in the use of testing automation products and strategies. Understand and test data warehouse ETL or other relevant data transformation processes.
- Understand data needs and define strategies to manage data in support of effective testing.
Education Requirements
- Bachelor's degree in Computer Science is preferred.
Years of Experience
- 4 + years of experience, QA, or database development related role with extensive experience in developing and implementing test plans.
Certification and Technical Requirements
- Demonstrated knowledge of automated test tools.
- A working knowledge of data testing best practices including data profiling and modeling in relational, dimensional and data warehousing scenarios.
- Hands-on experience with software testing at all phases (unit, integration, regression, system/acceptance, load and performance, end-to-end) is required.
- Ability to learn and excel in the use of an automated testing framework and develop automated tests within the framework.
- Strong ability to develop and execute Structured Query Language (SQL) statements against data structures using modern/common query tools
- Proficient in Windows environment using previous and the latest Microsoft Office suite, Visual Studio, Team Foundation Server (or other centralized source control system ) and Microsoft SQL Server.
- Develop and execute data set test plans to validate transformations as part of the data validation process.
- Demonstrated knowledge of PowerShell scripting, C# and VB Script experience preferred.
Why Us:
For qualifying positions, we provide a competitive benefits package designed to support health and well-being, financial security, and work-life balance:
- Health Benefits: Comprehensive medical, dental, and vision insurance
- Retirement Plans: 401(k)
- Paid Time Off: Vacation, sick leave, paid holidays, and parental leave
- Additional Benefits: Life and disability insurance, Employee Assistance Program (EAP), wellness programs, tuition assistance, and short-term incentive pay
For a comprehensive overview of our total reward offerigs, click here.
About Us:
AgCountry has 45 offices, is based in Fargo, North Dakota and serves portions of North Dakota, Minnesota, and Wisconsin, FCSAmerica is based in Omaha, NE and has 42 local offices serving rural communities and agriculture in Iowa, Nebraska, South Dakota, and Wyoming. Frontier Farm Credit has six offices serving eastern Kansas. Together, we support nearly 82,000 producers and agribusinesses, meeting the needs of today’s agricultural industry with our combined 2600+ employees providing lending, risk management, technology, commodity marketing, and customer and employee education.
AgCountry Farm Credit Services, ACA, Farm Credit Services of America, ACA, and Frontier Farm Credit, ACA are Equal Employment Opportunity employers, and they comply with all applicable federal, state, and local fair employment practices laws.