ETL Data Quality Analyst

Published date Posted on Indeed on Sep 10, 2021 (9 d ago)

NCSolutions is hiring a ETL Data Quality Analyst to play a key role in their sales efforts with Advertisers and Agencies across the U.S.!

SUMMARY:
NCSolutions (NCS) empowers the CPG ecosystem to create and deliver more effective advertising with purchase-based audiences and sales measurement solutions. We harness the unrivaled data resources of our parent companies, including our exclusive rights to the TV and digital currency data. Leveraging these assets coupled with scientific rigor and leading edge technology, we help our clients continuously improve advertising performance, everywhere their ad appears.


RESPONSIBILITIES:
Performs quality control and quality assurance testing of applications using a set of testing tools, testing framework, processes and methodologies
Create Test Plans to ensure the delivery of test data to data warehouses used in downstream systems
Reviews requirements and other project documentation and provides feedback, with an emphasis on testability
Creating or modifying test scripts and use cases based on requirements.
Validate and analyze data loaded into the data warehouses
Participates in technical design reviews, component/code reviews and testing reviews
Provides feedback as to the testability and ensures that business requirements are met
Executes detailed test cases/scripts and associated data employing manual testing using unix scripting
Documents test procedures and findings
Researches, documents, assesses, and facilitates the resolution of incidents
Assess and revise test sequence and scope based upon test results and or changes in product design
Makes recommendations based on assessed risks to quality by applying various verification and validation techniques in coordination with the Development Team (QA Lead, Project Managers, and Development Managers)
Work closely within other NCS teams for various needs:
The QA Lead to design and ensure overall integrity of the testing strategy
Application Development teams preparing data for their testing/validation needs.
Operations Team for data support questions and tasks
DBA Team to test data load processes
Data analysis / Tracking down sources of unexpected results or unusual data

QUALIFICATIONS:
Bachelor’s degree in computer science or related
Highly developed analytical, problem solving and communication skills with a strong focus on detail
Understanding relational database objects and views
Understanding database load strategies
Expert in Relational Database testing with excellent PL SQL skills and queries
Ability to multi task and remain flexible when priorities or work direction change


REQUIRED EXPERIENCE:
Minimum of 7 or more years of IT experience with 4 years in manual testing data load processes, focusing on complex SQL queries
Experience interpreting and understanding data models and ER diagrams
Data warehouse testing experience
Knowledge and experience with scripting languages


DESIRED EXPERIENCE:
Experience in CPG or Media research
Knowledgeable in RDBMS systems such as Yellowbrick and Oracle with ‘nice to have’ experience in AWS and Snowflake systems.
Experience in SQL


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Piper Companies is looking for a SQL Database Refactoring Developer, Tech Lead for a Managed Services organization in Remote.Responsibilities for the SQL Database Refactoring Developer, Tech Lead Locating and cataloging all Oracledatabase objects, develop compatibility matrix wit

Roofstock is the leading marketplace for investing in single-family rental homes. Our mission is to make real estate investing radically accessible, cost effective and simple. We want to use technology to transform the way real estate is bought and sold and make real estate inves

Facet Wealth Facet Wealth |
|
6 d ago

About The Role:At Facet Wealth, we put the client above all else. As a Salesforce Engineer at Facet Wealth, you will work with our Engineering & Sales teams, playing a critical role in developing the Salesforce components and tools used by our sales team. Our goals are focuse

The candidate can be located anywhere in the US as this will be a remote work-from-home role. The candidate will need to have strong internet at home. Please submit candidates who have some of the below experience, this is a data-focused role.SQL Developer/analytics experienceMic

The candidate can be located anywhere in the US as this will be a remote work-from-home role. The candidate will need to have strong internet at home. Please submit candidates who have some of the below experience, this is a data-focused role.SQL Developer/analytics experienceMic

More jobs by this company

Software Development Engineer in Test (SDET)Full Time / PermLas Vegas or Remote in USAOur client is a dynamic FinTech company that is enabling the next generation of cashless, mobile, and omni-channel payment solutions for the gaming, lottery, sports betting, entertainment, and h