QA Engineer, Data Warehousing at Softworld Inc

Job Title: QA Engineer, Data Warehousing

Location: Morristown NJ 07960 REMOTE but NOTE: Only Candidates living in the CST and EST time zones.

Onsite Requirements:

• SQL
• SSIS
• Testing
• Must come from a Property & Casualty Insurance or Banking background.

Job Description:

• We are looking for innovative, talented, and self-motivated individuals interested in working with a cross-functional team focused on implementing and supporting our internal data warehouse.

Key Objectives:

Hands-on experience with:

• EDW source to target testing (SQL scripting - manual and automation).
• Data transformation/manipulation testing (SQL scripting - manual and automation).
• Data quality/completeness validation (SQL scripting - manual and automation).
• Experience in running the processes through the scheduler.

Quality Assurance, Process Improvement and Collaboration:

• Develop and execute comprehensive test plans to validate data within on-prem and cloud data warehouses.
• Conduct thorough testing of ETL processes, dimensional data models, and reporting outputs.
• Identify, document, and track data quality issues, working closely with data engineers to resolve them.
• Validate data loading, transformation, and aggregation processes.
• Ensure data consistency and integrity across different data sources and systems.
• Collaborate with the Data Quality and Data Engineering team to define quality benchmarks and metrics.
• Continuously improve QA testing strategies and methodologies.
• Implement best practices for data validation and error handling.
• Assist in the design and implementation of data quality assurance tools and frameworks.
• Work closely with BA, data architect, data engineers, QA, and stakeholders to understand data requirements and deliverables.
• Work closely with the Lead Data QA Engineer to design, develop, maintain, and support testing infrastructure.
• Provide detailed reports on data quality findings and testing outcomes.
• Extensively use Task management and defect management tool (i.e. Jira and Confluence) to manage deliverable.
• Well versed with the comprehensive QA testing methodology (i.e. functional, non-functional, system, regression, smoke test, performance testing, black box testing, etc.).
• Contribute insights and recommendations to enhance data quality and processing efficiency.

You're a Great Fit If You Have

• Minimum 3 to 5 years of Quality Assurance experience (manual/automated testing) with a proven track record of improving Data Quality by implementing QA best practices within organization.
• SSIS & MSSQL experience (intermediate or senior level).
• Experience with Insurance Data Warehouse, data and its processes.
• Experience with the Snowflake and DBT is a plus.
• Experience in using QA automation tools.
• ETL process knowledge; Knowledge of data warehouse testing procedures.

Desirable qualifications/pluses:

• Knowledge of Insurance Data & its processes.
• Data validation experience between on-prem & cloud (i.e. hybrid) architecture.
• Familiarity with cloud computing and the data ecosystem on Snowflake.

Requirements:

• Bachelors or master's in computer science or equivalent.
• Experience with Insurance Data Warehouse, data and its processes.
• Strong understanding of Data Warehouse & Data Quality fundamentals.
• 3 to 5 years of experience in data warehouse development/testing.
• 3 to 5 years of experience with SQL Server and SSIS/SSAS/SSRS testing.
• Must be experienced in Data Warehousing Projects with good knowledge of ETL testing.
• Strong in SQL, RDBMS, ETL, and DW concepts.
• Experience in validating Reports/Dashboards on tools like Tableau, MS Power BI, etc.