Senior Data Quality Assurance Engineer

Southern New Hampshire University is a team of innovators. World changers. Individuals who believe in progress with purpose. Since 1932, our people-centered strategy has defined us — and helped us grow a team that now serves over 180,000 learners worldwide.

Our mission to transform lives is made possible by talented people who bring diverse industry experience, backgrounds and skills to the university. And today, we're ready to expand our reach. All we need is you.

Make an impact — from near or far

At SNHU, you'll have the option to work remotely in the following states: Alabama, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Mississippi, Missouri, Nebraska, New Hampshire, New Mexico, North Carolina, North Dakota, Ohio, Oklahoma, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, West Virginia, Wisconsin and Wyoming.

We ask that our remote employees have access to a reliable internet connection and a dedicated, properly equipped workspace that is free of distractions. Employees must reside in, and work from, one of the above approved states.

The opportunity

The Sr. Data Quality Assurance Engineer is part of our Data Services team that ensures business-applicable data is curated, accurate, accessible, and convenient for use by the business to inform data-driven our decisions and strategic programs. The Sr. Data Quality Assurance Engineer thoroughly tests the raw and curated data, metadata, data extractions, loads, transformations, and aggregations used to support our needs. These deliverables include (but are not limited to) data pipelines, warehouses, integrations, marts, stores, lakes, virtualizations, models, and associated database objects. The Sr. Data Quality Assurance Engineer reports to the Data Quality Assurance Manager. This role can work 100% remotely within our approved states. #LI-Remote

What you'll do:

• You will test data transformations, ETL processes, and data services to ensure accuracy, completeness, and performance.
• You will collaborate with database administrators, data engineers, and other partners to understand data requirements, data models, and system architecture.
• You will participate in the testing and validating emergency production bug fixes.
• You will assume a leadership role in special testing projects and tasks.
• You will ensure that required documentation, such as architectural specifications, our requirements, and functional documentation, is up to date and follows set standards.
• You will ensure that deliverables meet functional and design specifications and requirements.
• You will follow all data quality assurance standards, processes, and best practices.
• You will develop and automate test suites for data quality, metadata, regression, smoke, functionality, and performance.
• You will analyze and ensure changes are reflected in the test case and test cases are updated based on the solution.
• You will log defects in a detailed, understandable, and reproducible manner.
• You will track defects through closure by working with the Development team.
• You will provide guidance and recommendations for data quality improvements, data cleansing, and data governance programs.
• You will communicate testing status completely for the team.
• You will mentor guidance to user acceptance testers, fellow QA engineers, and the Development team.
• You will train and assist onboarding new team members.
• You will work with peers, management teams.
• Attendance, punctuality, and reliability are essential functions of this role.
• Other responsibilities as assigned.

What we'd like to see:

• 7 years of database development or data Quality Assurance experience with practical work in a quantitative, data-driven business environment working directly with data.
• 2 years' experience in data Quality Assurance testing.
• Knowledge and practice of data quality assurance best practices and methods in a data services environment.
• High-level understanding of relational database architecture, data warehousing, data manipulation, summarizing/aggregating data, and data extraction from multiple, different data sources.
• High proficiency in SQL programming for SQL Server with the ability to develop and maintain complex queries and scripts for data validation and testing.
• Experience with Visual Studio using C# unit testing.
• Sound knowledge of Software Development Life Cycle (SDLC) best practices based on experience with Kanban and Agile methodologies, including source code control best practices.
• Experience with Azure Data Factory, including developing pipelines and their supporting SQL, implementing pipelines, and monitoring their execution and outcomes.

Additional Experience with:

• Experience with Azure DevOps, including Boards and Git source code control.
• Knowledge and practice of data quality management principles.
• Experience in defect tracking and release management.
• Have lead experience in manual and automated testing tasks.

We believe real innovation comes from inclusion - where different experiences, perspectives and talents are celebrated. So if you're wondering whether SNHU is right for you, take the leap and apply. You might be just the person we're looking for.

Compensation

The annual pay range for this position is $91,388.00 - $146,247.00. Actual offer will be based on skills, qualifications, experience and internal equity, in addition to relevant business considerations. We expect this position to be hired in the following target hiring range $100,983.00 - $136,624.00.

Exceptional benefits (because you’re exceptional)

You’re the whole package. Your benefits should be, too. As a full-time employee at SNHU, you’ll get:

• High-quality, low-deductible medical insurance

• Low to no-cost dental and vision plans

• 5 weeks of paid time off (plus almost a dozen paid holidays)

• Employer-funded retirement

• Free tuition program

• Parental leave

• Mental health and wellbeing resources