Sr Data Warehouse QA Engineer

Job Summary

The Senior Data Warehouse QA Engineer ensures the quality and integrity of the data warehouse and lakehouse platforms. This role works as part of an agile team, writes test automation scripts, validates Extract/Transform/Load (ETL) processes, ensures data quality, and verifies business logic. This role collaborates with data engineers, data analysts, data scientists, business partners and other stakeholders to maintain and build trust in the quality of the data we provide in the data warehouse environment.

The Senior Data Warehouse QA Engineer reports to the Senior Manager, IT Infrastructure.

About UFCU

Our Credit Union was founded in 1936 and has grown to serve members throughout Texas and beyond. At UFCU, we are more than just a financial institution, and our people are more than just employees. We are dedicated to our purpose of empowering our Members to achieve financial success and build brighter futures.

In pursuit of our aspiration that UFCU is loved by millions of Members and built to thrive for generations, we are guided by our values:

Purposefully Member-Obsessed

We are driven by a profound sense of empathy to deeply understand our Members’ needs and preferences, what brighter futures means to them, and the obstacles in their way. We act in our Members’ best interests, forever seeking to empower their financial success.

Possibilities Reimagined

We are inspired to courageously experiment, learn, and iterate in pursuit of positive impact for our Members, UFCU, and coworkers. We challenge assumptions, embrace diverse perspectives, and make use of data and insights.

Performance Excellence Rooted in Unwavering Integrity

We do the right thing, always. We champion teamwork, accountability, continuous improvement, and celebrate successful outcomes of others, fostering an inclusive environment of excellence and collaboration.

Essential Functions

Test Automation

• Develop and maintain automated test scripts for data validation and ETL processes.
• Ensure comprehensive test coverage for data pipelines and transformations.
• Ensure test case library is version controlled and part of the Software Development LifeCycle (SDLC).

ETL Validation

• Validate ETL processes to ensure accurate and timely data integration.
• Identify and resolve data discrepancies and inconsistencies.

Data Quality Assurance

• Implement data quality checks and validation rules to ensure data accuracy and completeness.
• Monitor data quality metrics and perform regular audits.

Business Logic Testing

• Verify business logic and data transformations to ensure they meet requirements.
• Collaborate with business analysts to understand and validate business rules.

Collaboration & Support

• Work closely with data engineers, analysts, and other stakeholders to support data quality initiatives.
• Assist in troubleshooting and resolving data-related issues.
• Write test cases for User Stories and Features.
• Operate in an Agile environment working as part of an Agile Scrum team in project sprints.

Documentation & Best Practices

• Maintain comprehensive documentation of test cases, test scripts, and data validation procedures.
• Establish and enforce best practices for data quality assurance and testing.

Other

• Adheres to all company policies, procedures, and business ethics codes.
• Completes required regulatory training as assigned.
• Maintains strict adherence to and compliance with all laws, rules, regulations, and internal controls specific to the role, including but not limited to Bank Secrecy Act, Anti-Money Laundering, USA Patriot Act, OFAC and Fair Lending regulations.

Knowledge/Skills/Abilities     

Knowledge

• Advanced knowledge of data warehousing concepts and ETL processes.
• Experience with Azure SQL Server, Databricks and other data platforms.
• Strong proficiency in SQL, T-SQL, and Python.
• Strong knowledge of data quality assurance best practices.

Skills

• Strong problem-solving and troubleshooting skills, with a proactive approach to identifying and resolving data issues.
• Strong communication skills (written, verbal, and listening) with the ability to communicate effectively with staff of varying technical expertise.
• High level of organization and prioritization.
• Strong analytical skills with high level of detail orientation.

Abilities

• Strong ability to manage multiple priorities and work in a fast-paced, agile, dynamic environment.
• Strong ability to write and develop test automation scripts for data validation.
• Ability to write test cases and clarify acceptance criteria in User Stories
• Strong ability to collaborate with business and IT teams to successfully design and implement data quality initiatives.
• Ability to build strong relationships, manage expectations, and balance competing priorities.
• Ability to anticipate and address challenges, resolve conflicts, and remove obstacles.
• Ability to handle ambiguity and to pivot as projects and priorities evolve.
• Ability to troubleshoot and resolve complex data issues.

Core Competencies

• Demonstrating Member Obsession

• Puts themselves in the Member’s shoes
• Looks for friction points
• Makes it personalized and easy

• Demonstrating Performance Excellence

• Sets standards for elevating excellence
• Ensures elevated quality
• Takes responsibility
• Conducts continuous improvement

• Demonstrating Innovation

• Challenges current thinking
• Approaches change with a positive mindset

Experience

Minimum Requirements

• Bachelor’s degree in Information Technology, Computer Science, or a related field, or equivalent work experience.
• Minimum seven (7) years of hands-on experience in data quality assurance, ETL validation, and test automation.
• Strong proficiency in SQL, T-SQL, and Python.
• Minimum five (5) years of hands-on experience working in an Agile development environment
• Strong experience with data quality assurance best practices.
• Minimum five (5) years of hands-on experience with cloud-based data platforms, such as Azure SQL Server, Synapse, or Databricks.
• Minimum five (5) years’ experience with data warehousing concepts and ETL processes.
• Minimum five (5) years hands-on experience with scripting and automation tools such as Python or equivalent.
• Must be bondable

Preferred Requirements

• Experience in the financial services/credit union industry.

Physical Demands

The physical demands described are representative of those that must be met by an employee, with or without accommodation, to successfully perform the essential functions of this job.  Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

Frequent

• While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle or feel; reach with hands and arms; and talk or hear.
• Specific vision abilities required by this job include close vision, distance vision, peripheral vision, and ability to adjust focus.
• Employee will make extensive use of the telephone and virtual communications requiring the ability to explain complex information effectively and accurately.

Work Environment

The work environment characteristics described are representative of those an employee encounters while performing the essential functions of this job. 

• This is a remote work from home position, requiring occasional on-site work at UFCU Plaza in Austin, Texas. The specific schedule and expectations for on-site presence may vary based on departmental or organizational needs.
• This position may involve periodic stressful conditions.
• May occasionally require an adjusted work schedule, overtime, and evening/weekend hours.
• May occasionally move from one work location/branch to another.
• Public contact position, requiring appropriate professional appearance.
• Frequent computer use at a workstation of up to two hours at a time.
• The noise level in the work environment is usually

#INDUFCU