Sr. ETL QA Analyst - Military Veterans

Overview

Why GMF Technology?

GM Financial is set to change the auto finance industry and is leading the path of embarking on tech modernization - we have a startup mindset, and preserve our small company culture, in a public company environment with financial stability and intense growth over a decade-plus history. We are data junkies and trust in data and insights to advance our business objectives. We take our goal of zero emission, zero collision, zero congestion, and zero friction very seriously. We believe as an auto finance market leader we are in the driver's seat to lead us in the GM EV mission to change the world. We are building global platforms, in LATAM, Europe, China, U.S. and Canada - and we are looking to grow our high-performing team. GMF is comprised of over 10,000 team members globally. Join our fintech culture within a Blue-Chip company where we are changing the way we use technology to support our customers, dealers and business.

As a Sr. Quality Assurance Analyst on our Data Quality team, you will work to ensure high-quality data in the warehouse. Your primary focus will be on driving data quality assurance, scaling automation strategies, and improving testing techniques. You will work closely with various teams and stakeholders, including the project agile team, to improve data quality. Your job duties will include defining and scaling automation strategies, improving testing techniques, and analyzing mapping issues to devise test strategies and resolution steps. Your expertise will help drive data quality assurance and enhance testing techniques.

Responsibilities

WHAT MAKES YOU AN IDEAL CANDIDATE?

• Build solid partnership with highly skilled and motivated team members to drive forward process improvements and team cohesion
• Communicates and coordinates with stakeholders, product owners, scrum masters, agile teams, data architects, and data engineers distributed across multiple locations
• Identify opportunities for automation, detection of data anomalies, improvement within QA test case scenarios and execution, fast-track implementation of solutions
• Continually track progress using metrics and dashboards, quantify defect trends and opportunity areas for improvement
• Design, develop and present findings of complex data queries necessary to fully understand data quality conflicts
• Coordinate test data availability for executing pertinent test scenarios
• Develop automation of data validations incorporating checks based on business rules including exceptions, inconsistencies, tolerance levels, and valid output
• Identify conflict resolution path in compliance with project objectives and business requirements
• Identify trends, thresholds and workflow behaviors in ETL workflows, data pipelines and strategize issue resolution processes
• Evaluate risk levels and roadblocks for defect severity and promptly apply updates to the project team via DevOps boards
• Collaborate and contribute on defect triage sessions to resolve impediments
• Stay current with relevant emergent technologies and quickly grasp best technology approach from tech stack to implement faster solutions in data quality assurance
• Comply with all security policies and procedures to ensure that the highest level of system and data confidentiality, integrity and accountability is maintained
• Comprehensive quality assurance knowledge with a strong attention to detail and a stronger sense of urgency for identifying roadblocks and delivering quality data.

Qualifications

Experience

• High School Diploma required And
• Bachelor's Degree in related field or equivalent experience preferred
• 4-6 years experience with complex querying and analyzing data, SQL required
• 4-6 years experience with data testing tools, test automation required
• 2-4 years experience in data warehousing environment preferred
• 2-4 years advanced ETL, data pipelines preferred
• Strong understanding of the data management principles, data modeling, quality assurance, defect management, conflict resolution, ETL processes, databases, data analysis
• Strong understanding of Data Quality principles, concepts and best practices
• Understanding of data warehousing concepts, medallion architecture, data lake, delta lake, cloud, on-prem data
• Aptitude for research, root cause analysis and high standards for ensuring quality data for the organization
• Ability to evaluate existing and propose new data quality assurance processes, standards and best practices
• Proficiency in advanced SQL scripting, complex SQL joins
• Experience using Databricks, Unity Catalog
• Exposure to Microsoft Azure
• Experience with Python, PySpark
• Experience working with Agile Scrum teams preferred
• Strong interpersonal, verbal and writing skills
• Experience mentoring mid-level analysts

What We Offer: Generous benefits package available on day one to include: 401K matching, bonding leave for new parents (12 weeks, 100% paid), tuition assistance, training, GM employee auto discount, community service pay and nine company holidays.

Our Culture: Our team members define and shape our culture - an environment that welcomes innovative ideas, fosters integrity, and creates a sense of community and belonging. Here we do more than work - we thrive.

Compensation: Competitive pay and bonus eligibility

Work Life Balance: Flexible hybrid work environment, 2-days a week in office

NOTE- At this time we are unable to provide Visa sponsorship for this position

#LI-Hybrid

#LI-MH1I