Data Warehouse QA Analyst
Data Warehouse QA Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Job Title ETL Tester
Location Hybrid Wilmington MA
Hybrid Wilmington MA on Wednesdays and 1 other day
Duration 6 months
Visa USC GC
Need local with DL or State ID
- Can QA DWH objects not Database
- Reports QA Work
- SQL Server experience
- Understanding of Datawarehouse facts and dimensions
- Seema is the DWH theyd be reporting into
- BE apart of the legacy DWH upgrade
- Look through DWH scripts and QA the new build objects
- SQL Server important
- Data Savvy
- Ability to communicate properly the findings from the data issues
- Understand or have some knowledge of SSRS reporting reports
- Report outputs from SQL Server
- Having exposure to Jira or ticketing systems
- No other specific QA tracking system QA Logs basic QA logs
Position Overview:
We are seeking a detailoriented Data Warehouse QA Analyst to join our team. The ideal candidate will have a strong background in quality assurance for Data Warehouse (DWH) objects specifically within SQL Server environments. This role involves reviewing and validating DWH scripts reporting findings and ensuring the accuracy and quality of our data warehouse systems during an important legacy DWH upgrade.
Key Responsibilities:
Quality Assurance of DWH Objects:
- Review and validate data warehouse objects ensuring they meet quality standards and functional requirements.
- Reporting QA Work:
- Document and report QA findings including data issues and discrepancies in a clear and concise manner.
- SQL Server Expertise:
- Utilize SQL Server to conduct tests and validate data integrity within the DWH environment.
- Understanding Data Warehouse Concepts:
- Leverage knowledge of data warehouse facts and dimensions to inform testing strategies and validate data relationships.
- Collaboration with Team:
- Work closely with Seema and the data warehouse team to align QA efforts with project goals and timelines.
- Legacy DWH Upgrade Participation:
- Actively participate in the upgrade process by examining DWH scripts and QAing new build objects to ensure they meet specifications.
- Data Savvy Analysis:
- Analyze data outputs to identify inconsistencies anomalies and potential issues providing actionable insights to improve data quality.
- Communication of Findings:
- Effectively communicate data findings to stakeholders ensuring clarity and understanding of any issues or necessary actions.
- Reporting Skills:
- Familiarity with SSRS (SQL Server Reporting Services) to help in validating report outputs and assisting in reporting processes.
- Ticketing Systems Experience:
- Use Jira or other ticketing systems to log issues track progress and manage QA tasks.
Experience:
- Proven experience in QA for Data Warehouse environments particularly with DWH objects and a solid understanding of SQL Server.
- Technical Skills:
- Strong SQL skills with the ability to write and execute queries for testing purposes.
- Understanding of data warehouse architecture including facts and dimensions.
- Familiarity with SSRS is a plus.
Employment Type
Full Time
