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.!
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.
The ETL Data Quality Analyst will be responsible for performing testing of our applications, ensuring accurate reporting is completed, and revisions and recommendations are made for improvements based on test results.
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
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
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
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