Data Warehouse QA Job at Gravity IT Resourcing, Charlotte, NC

WmpFZG5MYXRKRFY0SnR5Wm9yMkhYbHlsTmc9PQ==
  • Gravity IT Resourcing
  • Charlotte, NC

Job Description

Job Description: Data Warehouse QA Analyst
Position : Data Warehouse QA Analyst
Contract : 6-month initial contract (potential for extension)
Location : Remote (Core hours: Central Time Zone 8-5)
Start Date : As soon as possible
About the Role : We are seeking a Data Warehouse QA Analyst to join our team supporting the residential and supply business. You will be instrumental in testing data and analytical products within our data warehouse and data lake environments before they are released to production and business users.
Key Responsibilities :
  • Design and develop test cases for data products in a data warehouse/lake environment.
  • Perform manual testing to ensure industry standards are met.
  • Prepare documentation, test plans, and test scripts.
  • Validate data pipelines and dashboards in Google Cloud Platform (GCP) and AWS.
  • Use SQL and Python to extract and validate data.
  • Test dashboards built in Tableau and Power BI.
  • Track and report defects using JIRA.
  • Collaborate with data engineers, data analysts, and business analysts to ensure data accuracy and integrity.
  • Participate in Agile methodologies, including two-week sprints and Scrum processes.
Technical Skills Required :
  • Cloud Platforms : Proficiency in Google Cloud Platform (GCP) and AWS is mandatory.
  • SQL and Python : Strong experience in writing SQL queries and using Python for data extraction.
  • Testing Tools : Experience with JIRA for defect tracking and Agile project management.
  • Data Visualization : Familiarity with Tableau and Power BI for testing dashboards.
  • ERP Systems : Experience with Oracle ERP systems and data migrations is a plus.
Qualifications :
  • Experience : 5-7 years of experience in data warehouse testing.
  • Industry Knowledge : Understanding of data products, supply chain logistics, or manufacturing is beneficial but not required.
  • Education : Relevant educational background in IT or related fields.
Interview Process :
  • Round 1 : Initial screen (15-30 minutes) focusing on background and soft skills.
  • Round 2 : Technical interview with data engineers, data analysts, and business analysts, including writing SQL queries and presenting solution designs.
Examples of Projects :
  1. Sales Team Support : Testing an analytical product that predicts customer churn based on sales trends and ensures that the algorithm’s outputs are accurate and actionable.
  2. Revenue Risk Analysis : Validating solutions that analyze revenue risk and supply chain disruptions, ensuring the data pipelines and products are built correctly.
Additional Information :
  • This role focuses on validating data pipelines rather than building them.
  • The team operates within an Agile methodology, and tasks are managed in JIRA.
  • The data warehouse and lake environments are built on AWS and GCP, with source data in Oracle, IBM, and SQL Server ERPs.

Job Tags

Contract work, Remote job,

Similar Jobs

AAS Healthcare Staffing

Registered Dental Assistant Job at AAS Healthcare Staffing

 ...-centric family practice in Sealy, TX, where we prioritizeproviding top-quality dental care in a welcoming environment. We are currentlyseeking an experienced Registered Dental Assistant to join our team. As a Dental Assistant in our practice, youwill play a vital role... 

Fourier Ltd

C++ Front Office Trading Team Developer - HFT Job at Fourier Ltd

 ...management workflow enhancements, expanding the supported product set on their platform, and extending its reach to new markets and trading protocols. All of this will be undertaken with a focus on the performance, scalability, and reliability of the system. There are... 

Connvertex Technologies Inc.

Power BI/Power Automate Developer Job at Connvertex Technologies Inc.

 ...datasets and transform them into insightful and visually appealing Power BI reports and dashboards. Requirements Gathering:...  ...into actionable requirements. Data Modeling: Design and develop data models that optimize Power BI's performance and ensure data... 

Generation Auto Group

Automotive Biller/ Title Clerk Job at Generation Auto Group

Job descriptionAutomotive biller wanted. Automotive experience a plus but not required. Great working environment and great office staff. Family owned and operated, great atmosphere. Salary, 401k and medical. We even match your 401k! CDK or Reynolds experience a plus....

Mondelez International

Part Time Nabisco Merchandiser/Stocker Job at Mondelez International

Join our Mission to Lead the Future of Snacking at Mondelz International Join our team of Part Time Nabisco Merchandiser and fulfill the merchandising needs of our customers through communication & relationship building, stocking store shelves, and maintaining or changing...