Back to Careers

Lead Data Quality Assurance Engineer

Date Posted: 
Employment Type: 
Direct Hire
Job ID: 

Lead Data Quality Assurance Engineer

The Data Warehouse team is in search of a data geek whose primarily responsibilities will focus on testing the data flow between the Enterprise Data Warehouse and a multitude of external applications. Working closely with the ETL Development, Business Intelligence, Digital Marketing, and other internal teams, this position is responsible for analyzing cross functional data and developing testing strategies (data specific) along with automating regression test plans for reusability. This position is great for a developer with a testing mindset who strives for data accuracy.

Key responsibilities:

  • Analyze, profile, and interpret data for one or more business teams to improve business efficiency by using various analytical methodologies
  • Create robust and stable data pipelines to analyze and test email marketing campaign data and help ensure maximum personalization of emails
  • Analyze high volumes of customer interaction data on website to drive insights and maintain 95% web data accuracy
  • Understand and test complex database structures across multitude of database systems using SQL scripting
  • Analyze project requirements to create and execute test plans, covering both high level & detailed testing, across a variety of data projects
  • Determine effort estimates, dependencies and timelines for data testing needs related to new project efforts
  • Conduct comprehensive source to target data testing, identifying issues with data accuracy, hygiene, and transformation logic
  • Create test scripts to validate data primarily using Oracle, SQL, PL/SQL and DB2 databases
  • Coordinate and lead cross team meetings to develop and review End-To-End test plans
  • Automate test cases, for ongoing Production data monitoring, by using advanced tools like Alteryx/iCEDQ
  • Develop Production data validation scripts using various programming paradigms (Apache Groovy, Java, SQL etc.)
  • Proactively monitor Production data, identifying and documenting issues within Key Performance Indicators (KPIs) across business units
  • Act as a key liaison for subject matter and technical expertise of our evolving data warehouse
  • Participate in and provide active feedback in all AGILE meetings and activities (SCRUMs, Sprint Planning, Retro)
  • Direct data governance, research, and best practices towards alignment with company goals and strategies
  • 2+ years' leading and managing projects for a team of Data Quality Analysts at onsite and offshore.
  • Direct activities, assign responsibilities, set performance expectations, and motivate DQA team members toward achieving project objectives
  • Master’s degree in a technology related field with 1+ year of experience with Oracle / MS SQL
  • OR
  • Bachelor’s degree in technology related field with 5+ years of experience in Oracle / MS SQL
  • Intermediate to advanced SQL skills, across multiple relational database types
  • Strong understanding of Data Warehouse, ETL, & BI Concepts
  • Experience with Agile methodology
  • Experience with the data tools Tableau and Alteryx
  • Experiencing using MS Excel for data analysis tasks
  • Experience writing and executing test plans, specifically related to data testing
  • Professional experience with discovery, reporting, tracking, and testing data defects
  • Basic understanding of Java and Apache Groovy, for writing data validation queries
  • Ability to clearly & concisely communicate issues in written & verbal fashion
  • Strict attention to detail
  • 2+ years' experience managing a project team
  • Experience working with Onsite / Offshore team model
  • Experience with Informatica and / or iCEDQ a big plus
  • Comfortable working in a fast-paced, deadline driven environment