Data Warehouse QAGravity IT Resources

Gravity IT Resources
Charlotte, North Carolina
Full-time

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 :

  • 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.
  • 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.
  • 30+ days ago
Related jobs
Gravity IT Resources
Charlotte, North Carolina

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. Collaborate with data engineers, data analysts, and business analysts to ensure data accuracy and integrity. Technical inte...

Gravity IT Resources
Charlotte, North Carolina

Work closely with business users and technical teams to identify and address configuration challenges, ensuring that data is correctly integrated and aligned with system functionalities. You will work closely with both business and technical teams to develop data requirements, manage data mapping, a...

Promoted
Randstad Digital
Charlotte, North Carolina

To provide intermediate technical evaluation, consultation, and support of global desktop computing. Provides intermediate-level technical support for desktop endpoints which includes implementation, configurations, control, maintenance, troubleshooting, security, and usage monitoring. ...

Promoted
Post Modern Communications
Huntersville, North Carolina

This is a full-time on-site role for a Help Desk Technician at Post Modern Communications in Huntersville, NC. The Help Desk Technician will be responsible for providing technical support, troubleshooting hardware and software issues, and assisting users with IT-related problems. Experience with hel...

Promoted
Trusted Security Solutions
Indian Trail, North Carolina

Technical Customer Support Specialist . The role of Technical Customer Support Specialist centers around 3 main areas of competency as outlined below. Be a supportive and amicable member of our team willing to support others whenever needed . Support the growth and development of the company through...

Promoted
Apex Systems
Charlotte, North Carolina

Seeking an Industrial Control System (ICS) Server Administrator that is responsible for the operational technology server infrastructure and associated applications that support our plant and field control systems. Strong experience with VMware, Windows, Ubuntu(Linux) operating systems. Experience w...

Promoted
Red Knight Solutions, LLC
Charlotte, North Carolina

Providing customer break fix support for designated equipment. ...

Promoted
Brenntag
Charlotte, North Carolina

Lead/assistoperations manager with plant wide meetings. Lead/assistoperations manager with plant wide meetings. Trainoperations personnel and ensure maintenance of training records. Leads andinspires a high performing Operations Team that supports Brenntag's Core Valuesand the Brenntag Way execution...

Promoted
Slalom Consulting
Charlotte, North Carolina

Slalom is seeking a talented, self-starting Commerce Project Manager to lead the discovery, implementation, and release phases of complex commerce and Salesforce multi-cloud projects. As a Commerce Project Manager, you will lead large, complex, enterprise multi-work stream projects with focus on qua...

Promoted
S&ME INC,
Charlotte, North Carolina

Construction Materials Project Manager. Collaborate with cross-functional teams to deliver projects on time and within budget, demonstrating your strategic project management skills. You have 1 year of proven work experience as a project manager, supervisor or team leader. You will be a key player i...