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
Brightspeed
Charlotte, North Carolina

Brightspeed is looking for a Senior Project Manager to join our 3rd Party Circuit team! As Senior Project Manager, you will provide overall program management support and reporting associated with the end to end lifecycle of off-net network solutions. Ability to facility project creation and managem...

Promoted
Rnc, Inc.
Charlotte, North Carolina
Remote

Level I - II IT Technician: On-site & Remote Support Position. Level II Technician providing on-site and remote support. Support, troubleshoot, research, and resolve computer hardware and software problems related to:. Desktop support, manage client requests. ...

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
Canonical - Jobs
Charlotte, North Carolina
Remote

The role of a Linux Desktop Support Engineer at Canonical. You will be accountable for delivering an outstanding technical support experience on the full Desktop and Server technical stack at Canonical. Linux and Customer Success to build a career with Canonical and support the technical needs of cu...

Promoted
Deloitte
Charlotte, North Carolina

Responsible for the day-to-day operations of and support for applications and systems to include: Microsoft Exchange servers, Microsoft Outlook, DNS, Active Directory and other applications as deployed by the Unified Communications team. Work with vendors to support Deloitte's email and Active Direc...

Promoted
Red Ventures
Charlotte, North Carolina

The Launch Program is your opportunity to onboard into your full-time role at Red Ventures in a cohort-style environment that provides in-depth training on our beliefs, culture, business model, and leadership. After your initial onboarding period, you'll join one of our teams, meet your manager and ...