QA Data Migration Engineer

Title: QA Data Migration Engineer

Job Description:

Seattle, WA (Hourly W2; Hybrid)

Applicants must live in Washington state and be currently authorized to work in the United States on a full-time basis. The employer will not sponsor applicants for work visas. The employer may not have resources available to support STEM OPT training requirements. No C2C - Pivotal does not accept unsolicited applications or resumes from third-party recruiters/agencies.

Why clients choose Pivotal Consulting:
We are a technology management consulting firm helping Fortune 500 companies improve their performance – we specialize in making People, Process, and Technology work together! Our clients count on us to deliver excellence and seek our guidance on business and technology strategy, technology modernization, and cloud transformation initiatives. Simply put; by listening to our clients closely and focusing on delivering quality, we bring them peace of mind.

After guiding and helping numerous clients from global enterprises to mid-market firms to non-profit organizations, we are now experiencing breakthrough growth!

What we are looking for:
Pivotal Consulting is seeking an experienced Data Migration Test Analyst to support enterprise data migration initiatives into Snowflake within an Azure environment. This role focuses on validating data accuracy, completeness, integrity, and transformation as data moves from legacy systems into modern cloud platforms.

The ideal candidate has strong experience in data validation, ETL/ELT testing, source-to-target reconciliation, SQL analysis, data quality testing, and automated testing. Experience with Alteryx is highly preferred.

What you will do:

• Design and execute testing strategies for data migration and modernization projects.
• Validate source-to-target mappings, transformations, and business rules.
• Perform reconciliation testing to ensure migrated data is complete and accurate.
• Write and run SQL queries to validate large datasets.
• Create and maintain test cases, test plans, and test evidence.
• Test ETL/ELT pipelines and data ingestion processes.
• Develop automated validation scripts and reusable testing frameworks.
• Investigate and document data issues, defects, and reconciliation exceptions.
• Support functional, integration, regression, and UAT testing.
• Partner with Data Engineers, Data Architects, and Business stakeholders to resolve data issues.
• Validate reports, dashboards, and analytics outputs in Snowflake.
• Participate in Agile ceremonies and defect triage.

What makes you a good fit:

• 5+ years of experience in Data Warehouse, ETL, or Data Quality Testing.
• Experience with enterprise data migration and cloud-based platforms.
• Strong source-to-target reconciliation and data validation experience.
• Advanced SQL skills.
• Hands-on experience with Snowflake and Microsoft Azure.
• Experience testing ETL/ELT pipelines and data integrations.
• Familiarity with Azure DevOps, Jira, or similar tools.
• Strong understanding of data quality and data governance concepts.

Preferred qualifications:

• Alteryx Designer or Alteryx Server experience.
• Experience building automated data validation workflows in Alteryx.
• Experience with QuerySurge or similar comparison tools.
• Experience with legacy platforms such as SQL Server, Teradata, or enterprise EDW systems.
• Background in Financial Services, Banking, Lending, or Wealth Management.
• Basic Python scripting for testing automation.
• Experience validating Power BI datasets or Azure analytics solutions.

Why our employees love working at Pivotal:
We believe our strength comes from our differences, and as a Certified Minority-Owned Business (MBE) and a majority women-led firm, we are committed to fostering and promoting a culture of diversity and inclusion. We believe our team and our community are our greatest assets and we strive to promote both daily.

From providing our employees with the time to pursue company-sponsored certifications, to supporting and partnering with multiple non-profit organizations brought forth by our employees (such as Food Lifeline, United Way, and the Seattle Humane Society), we are proud to support both our fellow Pivotalites and the causes close to their hearts.

As we grow, we are anchored and driven by our Four Core Values:

• Be Engaged – We are present, committed, and accountable to our clients and to each other.
• Consistently Deliver – We are dedicated and reliable by consistently delivering excellence.
• Always Better – We continuously evolve, inspired to drive beyond the everyday norm.
• Do Happy – Be passionate and bring fun and creativity into everything you do.

Compensation, Diversity and Benefit Information:
The pay range for this position in Washington is $45-$60/hr. W2 plus benefits; however, base pay offered may vary depending on job-related knowledge, skills, candidate location, and experience.

Pivotal Consulting is committed to creating and supporting a diverse and inclusive team and serving all communities. All qualified applicants will be considered for employment regardless of race, gender, gender identity or expression, sexual orientation, religion, national origin, disability, age, or veteran status.
                   
Pivotal Consulting offers a comprehensive benefit package, including medical, dental and vision insurance, and 401k.